laravel版本:5.0
准备工作:
在mysql数据库中增加一条信息:
操作mysql流程: mysql -h localhost -u root -p 然后输入密码进入 mysql->
创建数据库:CREATE DATABASE name;
选中数据库: use name;
显示表:show tables;
创建表: CREATE TABLES table_name;
查找表中信息: select * from table_name;
[{"id":"1","username":"chuanyu","password":"123456","email":"admin@qq.com","role":"1","status":"0","created":"0","updated":"0"}]
然后在app/ route.php 中增加一条:
Route::get('addUser/select/{id}','HomeController@addUser')->where('id' ,'[0-9]+');
在 Controllers/HomeController.php 中增加一个函数:
public function addUser($id)
{
$res = DB::select('select * from tb_user where id = :id', ['id' => $id]);
return $res;
}
注意:需要在 HomeController.php 开头包含 use DB; 引用DB
最后,在浏览器中输入:
http://192.168.30.104/laravel5.0/public/addUser/select/1
输出结果:
[{"id":"1","username":"chuanyu","password":"123456","email":"admin@qq.com","role":"1","status":"0","created":"0","updated":"0"}]
总体流程: 在浏览器输入-->被路由到 route.php, 解析最后色 addUser/select/1 --> 转到 controller进行处理--> 对数据库进行操作DB:select并返回结果 -->显示