I am newbie to Laravel, I need to implement Pagination on query. Below is the query I am sending, what next to achieve it.
$arrAirlines = DB::table("(SELECT air.airline_id, air.title FROM `tbl_com_airlines_airports` as aa
left join tbl_com_airlines as air ON air.airline_id = aa.airline_id
where aa.country_id ='".$countryId."' and aa.is_deleted ='0' and air.org_id ='".$orgId."'
and (Select count(*) from tbl_com_airlines_airports where aa.is_domestic ='1')>1)")
;
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire