---
description: >-
  https://www.phpflow.com/php/datatables-example-server-side-processing-with-php/
---

# DataTables Example – Server-Side Processing With PHP

{% file src="https://3988971916-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LXUV09EJOZ8BKB8YL5I%2F-LzzMpF-3BcQY4AJLf93%2F-LzzN-dtZ8gqcuqJncRz%2Fsimple_datatable_example_code.zip?alt=media&token=4d0821c5-a3ce-464c-ab12-45b863be0f66" %}

## DataTables Example – Server-Side Processing With PHP

Last Updated On: [October 22, 2017](https://www.phpflow.com/php/datatables-example-server-side-processing-with-php/)| By: [Parvez](https://www.phpflow.com/author/admin/)

In previous post [Data Table jQuery Plugin](https://www.phpflow.com/jquery/data-table-table-plug-in-for-jquery/), we have learn what is jQuery datatable plugin and how to use jQuery datatable in your application,now in this tutorial i will describe how to use data table with server side scripting.I am using PHP and MySQL to get records from server side.In this tutorial our aim to get data from MySQL with help of php and passed data to jQuery datatable constructor.

> Also Checkout other tutorial of Datatable,

* [Part 1: Introduction of Datatable](https://www.phpflow.com/jquery/data-table-table-plug-in-for-jquery/)
* [Part 2- DataTables Example – Server-side Processing with PHP](https://www.phpflow.com/php/datatables-example-server-side-processing-with-php/)
* [Part 3 – How to add RowId and RowClass on each record using Datatable](https://www.phpflow.com/jquery/how-to-add-rowid-and-rowclass-on-datatable/)
* [Part 4 – Datatable Pagination, Sorting and Search – Server Side (PHP/MySQl) Using Ajax](https://www.phpflow.com/php/datatable-pagination-sorting-and-search-server-side-phpmysql-using-ajax/)
* [Part5 – Export the jQuery Datatable data to PDF,Excel,CSV and Copy](https://www.phpflow.com/php/how-to-export-the-jquery-datatable-data-to-pdf-excel-csv-and-copy/)
* [Part 6 – Datatable Responsive – Using PHP and Mysql with Ajax](https://www.phpflow.com/php/datatable-responsive-using-php-and-mysql-with-ajax/)

![datatable-with-php](https://www.phpflow.com/wp-content/uploads/2014/09/datatable-with-php-300x108.png)

#### There Are Following Steps Need To Achieve Over Goal:

**Step 1:** we will include jquery datatable and jquery library.

| 12345678 | \<!-- DataTables CSS -->\<link rel="stylesheet" type="text/css" href="http://ajax.aspnetcdn.com/ajax/jquery.dataTables/1.9.4/css/jquery.dataTables.css">\<!-- jQuery -->\<script type="text/javascript" charset="utf8" src="http://ajax.aspnetcdn.com/ajax/jQuery/jquery-1.8.2.min.js">\</script>\<!-- DataTables -->\<script type="text/javascript" charset="utf8" src="http://ajax.aspnetcdn.com/ajax/jquery.dataTables/1.9.4/jquery.dataTables.min.js">\</script> |
| -------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |

**Step 2:** Created HTML table in your web page.

| 123456789101112131415161718192021 |  \<div class=""> \<table id="example" class="display" width="100%" cellspacing="0">        \<thead>            \<tr>                \<th>Empid\</th>                \<th>Name\</th> \<th>Salary\</th>                          \</tr>        \</thead>        \<tfoot>            \<tr>               \<th>Empid\</th>                \<th>Name\</th> \<th>Salary\</th>                            \</tr>        \</tfoot>    \</table>    \</div> |
| --------------------------------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |

**Step 3:** Apply Datatable functionality on our HTML table.

| 1234567891011 | $( document ).ready(function() {$('#example').dataTable({ "bProcessing": true,                 "sAjaxSource": "response.php", "aoColumns": \[ { mData: 'Empid' } ,                        { mData: 'Name' },                        { mData: 'Salary' }                ]        });  }); |
| ------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |

**Step 4:** Now we will create `response.php` file and write down below code.

| 1234567891011121314151617 | $data = array( array('Name'=>'parvez', 'Empid'=>11, 'Salary'=>101), array('Name'=>'alam', 'Empid'=>1, 'Salary'=>102), array('Name'=>'phpflow', 'Empid'=>21, 'Salary'=>103) );              $results = array( "sEcho" => 1,        "iTotalRecords" => count($data),        "iTotalDisplayRecords" => count($data),          "aaData"=>$data);/\*while($row = $result->fetch\_array(MYSQLI\_ASSOC)){  $results\["data"]\[] = $row ;}\*/ echo json\_encode($results); |
| ------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |

> Here we have taken constant array instead of MySQL records, I am assuming you will replace this constant array with your MySQL result set.

[  Live Demo](https://www.phpflow.com/demo/datatable/)

[ Download Source Code](https://www.phpflow.com/source_code/simple_datatable_example_code/simple_datatable_example_code.zip)

&#x20;[Php](https://www.phpflow.com/category/php/)  [datatable with ajax](https://www.phpflow.com/tag/datatable-with-ajax/), [datatable with php](https://www.phpflow.com/tag/datatable-with-php/), [DataTables Example](https://www.phpflow.com/tag/datatables-example/), [Server-side Processing with PHP](https://www.phpflow.com/tag/server-side-processing-with-php/).  [permalink](https://www.phpflow.com/php/datatables-example-server-side-processing-with-php/).
