我尝试从特定的时间戳中获取数据到数据库DT中。 我尝试这样做,但不是工作代码:
Route::get('/l', function(){
$day = date('Y-m-d H:i:s', strtotime($_GET['day']));
$users = DB::select('select * from DT where (`timestamp` = "'.$day.'")' );
return $users;
})->middleware('auth:api');
在《邮递员》中,我输入参数:Day 2020-07-01
有人帮忙吗?
解决了!
Route::get('/l', function(){
$day = date('Y-m-d ', strtotime($_GET['day']));
$users = DB::select('select * from DT where (`timestamp` like "'.$day.'%")' );
})->middleware('auth:api');