Question

laravel5怎么在路由中使用数据库查询

Answer 1

Route::model('user','User');

Route::get('/hi', function(){
header('content-type:text/html;charset=utf8');
//$rs=DB::select('select * from cf_user limit 0,100');
$rs=User::find();
dd($rs);
//return"hi";
});

数据库:

数据库配置:
'mysql' => [
'driver' => 'mysql',
'host' => 'localhost',
//'host' => env('DB_HOST', 'localhost'),
'database' => 'test',
//'database' => env('DB_DATABASE', 'forge'),
'username' => 'root',
//'username' => env('DB_USERNAME', 'forge'),
'password' => 'qaz123',
//'password' => env('DB_PASSWORD', ''),
'charset' => 'utf8',
'collation' => 'utf8_unicode_ci',
'prefix' => '',
'strict' => false,
],