@@ -53,11 +53,11 @@ |
||
53 | 53 | Connect::config($connections); |
54 | 54 | |
55 | 55 | |
56 | -$dbSub = DB::table("users")->where("2 = ?",[2])->limit(10); |
|
56 | +$dbSub = DB::table("users")->where("2 = ?", [2])->limit(10); |
|
57 | 57 | |
58 | -$data = DB::fromSub(function (Query $query) { |
|
59 | - return $query->from("users")->selectRaw('first_name')->where("1 = ?",[1])->limit(10); |
|
58 | +$data = DB::fromSub(function(Query $query) { |
|
59 | + return $query->from("users")->selectRaw('first_name')->where("1 = ?", [1])->limit(10); |
|
60 | 60 | }, 'sub') |
61 | - ->where('4 = ?',[4]) |
|
62 | - ->joinSub($dbSub, 'sub','sub.id = users.id and 3 = ?',[3]); |
|
61 | + ->where('4 = ?', [4]) |
|
62 | + ->joinSub($dbSub, 'sub', 'sub.id = users.id and 3 = ?', [3]); |
|
63 | 63 | var_dump($data->toSQL(), $data->flatBindings()); |
64 | 64 | \ No newline at end of file |
@@ -64,7 +64,7 @@ discard block |
||
64 | 64 | ->get(); |
65 | 65 | |
66 | 66 | |
67 | -var_dump($data);; |
|
67 | +var_dump($data); ; |
|
68 | 68 | |
69 | 69 | |
70 | 70 | /** |
@@ -132,13 +132,13 @@ discard block |
||
132 | 132 | * |
133 | 133 | * Select * from (select * from users) as sub |
134 | 134 | */ |
135 | -$dbSub = DB::table("users")->where("2 = ?",[2])->limit(10); |
|
135 | +$dbSub = DB::table("users")->where("2 = ?", [2])->limit(10); |
|
136 | 136 | |
137 | -$data = DB::fromSub(function (Query $query) { |
|
138 | - return $query->from("users")->selectRaw('first_name')->where("1 = ?",[1])->limit(10); |
|
137 | +$data = DB::fromSub(function(Query $query) { |
|
138 | + return $query->from("users")->selectRaw('first_name')->where("1 = ?", [1])->limit(10); |
|
139 | 139 | }, 'sub') |
140 | - ->where('4 = ?',[4]) |
|
141 | - ->joinSub($dbSub, 'sub','sub.id = users.id and 3 = ?',[3]); |
|
140 | + ->where('4 = ?', [4]) |
|
141 | + ->joinSub($dbSub, 'sub', 'sub.id = users.id and 3 = ?', [3]); |
|
142 | 142 | var_dump($data->toSQL(), $data->flatBindings()); |
143 | 143 | |
144 | 144 |
@@ -263,7 +263,7 @@ |
||
263 | 263 | */ |
264 | 264 | public function setBindings(array $params = [], string $type = 'where'): Query |
265 | 265 | { |
266 | - $this->bindings[$type] = array_merge($this->bindings[$type],$params); |
|
266 | + $this->bindings[$type] = array_merge($this->bindings[$type], $params); |
|
267 | 267 | |
268 | 268 | return $this; |
269 | 269 | } |