为什么我查询数据库记录出现很奇怪的错误?
我的代码是这样的,
$users = DB::table('users')->when(false, function ($query) {
$query->where('id',12)->get();
}, function ($query) {
$query->where('id',8)->get();
});
return [$users];
{“connection”:{},”grammar”:{},”processor”:{},”bindings”:{“select”:[],”from”:[],”join”:[],”where”:[8],”groupBy”:[],”having”:[],”order”:[],”union”:[],”unionOrder”:[]},”aggregate”:null,”columns”:null,”distinct”:false,”from”:”users”,”joins”:null,”wheres”:[{“type”:”Basic”,”column”:”id”,”operator”:”=”,”value”:8,”boolean”:”and”}],”groups”:null,”havings”:null,”orders”:null,”limit”:null,”offset”:null,”unions”:null,”unionLimit”:null,”unionOffset”:null,”unionOrders”:null,”lock”:null,”operators”:[“=”,”<”,”>”,”<=”,”>=”,”<>”,”!=”,”<=>”,”like”,”like binary”,”not like”,”ilike”,”&”,”|”,”^”,”<<”,”>>”,”rlike”,”not rlike”,”regexp”,”not regexp”,”“,”*”,”!“,”!*”,”similar to”,”not similar to”,”not ilike”,”*”,”!*”],”useWritePdo”:false}
你只是构建了一个queryBuilder 并没有执行实际的query or sql,所以返回的其实就是一个Builder对象,听超哥的,去看看基础吧,不然问题会越来越多,甚至你可能会遇到你独有的问题