5,321
edits
Laravel: Difference between revisions
→Parameters/Variables
| Line 85: | Line 85: | ||
return 'User '.$id; | return 'User '.$id; | ||
}); | }); | ||
</syntaxhighlight> | |||
==Database== | |||
===Query Builder=== | |||
;From subquery: | |||
<syntaxhighlight lang="php"> | |||
$subquery = DB::connection('bayarea')->table(DB::raw("restaurants x, parking y")) | |||
->select("x.id as id1", "y.id as id2")->where("x.id", "=", $restaurant_id); | |||
$mainquery = DB::connection('bayarea')->table(DB::raw("({$subquery->toSql()}) as t1"))->mergeBindings($subquery)->...->get(); | |||
</syntaxhighlight> | </syntaxhighlight> | ||