I have two many to many table
- Users(id, name,email)
- reqs(req_id,quantity_req,status)
- 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