jeudi 10 mai 2018

Join Many to many table in Laravel

I have two many to many table

  1. Users(id, name,email)
  2. reqs(req_id,quantity_req,status)
  3. req_user(id, req_id,user_id) Is it possible to join those table so as to retrieve data
     $u_id = $request->user_name;
 $start_date = $request->get('start_date');
$end_date = $request->get('end_date');
      $req = DB::table('reqs')
            ->join('req_user', 'reqs.req_id', "=", 'req_user.req_id')
 ->whereBetween('date_applied', [$start_date, $end_date])
            ->where('user_id', $u_id)
            ->pluck('req_id');


from Newest questions tagged laravel-5 - Stack Overflow https://ift.tt/2jP1y0j
via IFTTT

Aucun commentaire:

Enregistrer un commentaire