How to make paging from the basics

I have a lot tables on my project and I found DataTable is very helpful. DataTable is very easy to config on how you want the pagination, global search, custom search
so on.

There are couple of ways to get your data to view. I found the best way always to get your query to return as array then json_encode it then make ajax callback to build it

Regards