mysql - 限制 DB::laravel 中多个表的查询

Question

我正在对多个表运行查询，我想将其限制为 5 个结果，但它给我以下错误。

$projects = DB::query("select * from project, project_budget,user 
                    where prj_id=pb_prj_id 
                    and prj_usr_id=usr_id 
                    and prj_status = 'open' 
                    and prj_expiry>'".date("Y-m-d H:i:s")."' 
                    order by prj_updated_date desc")->take(5)->get();

SQLSTATE[HY000]: 一般错误: 1096 没有使用表 (SQL: select * limit 5)

Answer 1

我通过使用查询生成器解决了。

$projectExpiry = date("Y-m-d H:i:s"); 
$projects =     DB::table('project')
                ->join('project_budget', 'project.prj_id', '=', 'project_budget.pb_prj_id')
                ->join('users', 'project.prj_usr_id', '=', 'users.prj_usr_id')
                ->where('prj_status',  '=' , 'open')
                ->where('prj_expiry',  '<' , $projectExpiry )
                ->orderBy('prj_updated_date',  'desc')
                ->take(5)->get();