Postingan lainnya
Membuat query builder laravel
Membuat Query Builder di laravel
cara merubah query ini menjadi query builder gimana yah
SELECT nm.nama_project , us.name FROM tbl_project nm , users us , tbl_task ts
WHERE nm.id_project = ts.id_project AND
us.id_users = ts.id_users AND ts.id_project = '54' AND us.id_users = '4'
ini kurang sediikit tinggal nambahin AND us,id_users = '4'
$DataTask = DB::table('tbl_task')
->join('tbl_project', 'tbl_project.id_project', '=', 'tbl_task.id_project')
->join('users', 'users.id_users', '=', 'tbl_task.id_users')
->where('tbl_task.id_project', '=', $id)
->get();
0