lundi 1 avril 2019

Sql whereNOTIn in laravel

I need your support to use whereNOTIn with laravel 5 to show all id in (times) table and they not in (booking)table and user_id

 $bookappoitm=DB::table('times')
    ->where('times.Dates_id',$id)
    ->whereNOTIn('id',function($query){
           $query->select('times_id')->from('bookappoitments')
           ->where('users_id',Auth::user()->id)
           ->get();
        })->get();



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire