Learn jQuery datatables server side processing with php and mysql - fetch records from database and display it in html table datatables using ajax request.
Read this post on kodingmadesimple.com