也许你没有标签和发送请求到你的控制器。必须是一个行动,以提供所有的请求信息。如果你想动态地做,在...
我试图从数据库表中筛选项目,我所做的就是获取我想要排除的in,然后通过-> whereNotIn在laravel中传递in $idcontracts=array(); $idbike=array(); $biciCorretta = array(); $findcontract=Contract::whereRaw('? between data_inizio and data_fine', [$datainizio])->whereRaw('? between data_inizio and...
or try pluck in laravel here DB::table('user') ->select('id','name') ->whereNotIn('id', DB::table('curses')->where('id_user', '=', $id)->pluck('user_id')) ->get(); M Mohammad Ali Abdullah $created_po = array(); $challan = modelname::where('fieldname','!=', 0...
高效写法 $users=User::whereNotIn('id',function($query)use($user){$query->select('toUserId')->from('relation')->where('relation.userId',$user->id);}); 低效率写法 $actionRelationsArray=Relation::select('toUserId')->where('userId',$user->id)->get()->pluck('toUserId');$users=...
)- get(); } 1.5.3 addSelect方法 如果你想要添加一个select 可以这样做: public function getArticlesInfo() { $query...= DB::table('articles')- select('title as articles_title'); $articles = $query- addSelect('id')-...whereNotIn('id', [1, 3, 5, 8])- get(); dd($articles...
you can simply pass a array into whereNotIn() laravel function. With query builder $users = DB::table('applications') ->whereNotIn('id', [1,3,5]) ->get(); //will return without applications which contain this id's With eloquent. $result = ModelClassName::select('your_column_name...
EDIT-另一种方法,您可以尝试不使用左连接,而是使用>whereNotExists进行原始查询
public function whereIns(): callable { /* @var Arrayable|array[] $values */ return function (array $columns, $values, string $boolean = 'and', bool $not = false) { /** @var \Illuminate\Database\Eloquent\Builder $this */ $type = $not ? 'not in' : 'in'; ...
9、IN查询 $ids= '1,2,3,4';$idArr=explode(',',$ids);$result= User::whereIn('id',$ids)->get();$result= User::whereIn('id',$ids)->orWhereIn('pid',$ids)->get();$result= User::whereIn('id',[110,119,120])->get(['name']);$result= User::whereNotIn('id',[110,11...
个人感觉 Eloquent ORM 的 where 条件解析场景并不是那么的丰富,很多条件的拼装都需要引入额外的 orWhere, whereNotIn, whereBetween, whereNotBetween 来辅...