lundi 2 mai 2016

Pagination In laravel Data table

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