DEV Community

Huzoor Bux
Huzoor Bux

Posted on

DataTables Server-side Processing with PHP and MySQL

DataTables is a library of jQuery that displays the list records in an HTML table using an intuitive interface. It offers features such as search, pagination, and sort.

In an earlier article, we saw a custom code that allows search and pagination of the records. In addition, DataTables will enable us to limit the number of records displayed on a page.

DataTables extension supports both client-side as well as server-side processing. This article will show you the database results using DataTables server-side processing.

A PHP file calls domain class by sending the table, column, and configuration details to the function. The domain class executes the query and returns an array of results. The JSON format encodes the resultant array and will be sent as a response to the DataTables AJAX program.

Tutorial: https://www.phplift.net/datatables-server-side-processing-with-php-and-mysql/
Demo: https://demos.phplift.net/datatables-server-side-processing/
Download Code: https://www.phplift.net/?wpdmact=process&did=MjUuaG90bGluaw==

Top comments (0)