How to implement pagination with server side get api in Datatables?

Today, We want to share with you jquery datatable server side pagination.In this post we will show you DataTables AJAX Pagination with Search and Sort, hear for implementation of Bootstrap DataTable jQuery DataTable server side sorting,pagination and searching using PHP and MySQL we will give you demo and example for implement.In this post, we will learn about Laravel Datatable Pagination Sorting and Search server side processing with an example.

Bootstrap DataTable Using PHP, Mysql, Ajax, Json with server side script

Bootstrap DataTable is just like a table that can easily integrated with Bootstarp using Bootstrap table styling option.

Latest compiled and CSS and JavaScript


Now we need to create a Mysql Table from which data will be populated.
CREATE TABLE `tbl_datatable`

CREATE TABLE `tbl_datatable` (
`id` int(10) NOT NULL auto_increment,
`name` varchar(250) NOT NULL default '',
`price` varchar(250) NOT NULL default '',
`pcode` varchar(250) NOT NULL default '',
`created_at` timestamp DEFAULT CURRENT_TIMESTAMP,

This is file where datatable will be displayed.

First name Product Price Product Code Start Date

The jquery Code:

PHP Server side Scripting Code

Now Server side Scripting Code start here.

"iTotalRecords" => $iTotal,
"iTotalDisplayRecords" => $iFilteredTotal,
"aaData" => array()

while ( $aRow = mysql_fetch_array( $rResult ) )
$row = array();
for ( $i=0 ; $i

I hope you get an idea about datatables server-side processing using php with mysql.
I would like to have feedback on my blog.
Your valuable feedback, question, or comments about this article are always welcome.
If you enjoyed and liked this post, don’t forget to share.

Leave a Comment