Laravel 5动态地将巨大的mysql数据提取到jquery-datatable

Question

I am using Laravel 5.2/Mysql as backend and jquery-datatable in frontend. I need to fetch huge amount of records from mysql database to Jquery-datable. I checked and found that there is a dynamic way of listing data here

but this fetch records directly from single table to the view and I need to fetch records from three different tables with join. Is there any other option/way to fetch records dynamically (dynamic pagination) to the Datatable with joining multiple tables using Laravel.

Answer 1

Take a look at the Eloquent documentation: https://laravel.com/docs/5.4/eloquent-relationships#eager-loading, specially the with method.

Also, in order to paginate you can use the ->paginate(num_records) https://laravel.com/docs/5.4/pagination