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