DataTable in php, Mysql and Ajax example by WebTuts

DataTables Example Processing with PHP and mysql, how to fetch data from database with sorting and pagination, Server-side Processing with PHP,Simple example datatable with php, display records list from database with the help of ajax, you can make php crud without page refresh click here
for simple php crud click here
for codeigniter tutorial click here
The plugin i use datatables

[D-Orientale]

this is not good, you must use the serverSide option and processing, and using LIMIT in the query, not selecting all the data from table. DataTable send variables like $_REQUEST["start"] which is the offset start of selection and $_REQUEST["length"] which is the LIMIT number.

[rotanapisey]

how to use database query with join in server side processing?

[mustaphasodruldeen]

doesnt work, error DataTables warning: table id=myTable - Requested unknown parameter '0' for row 0, column 0

[vishwajeetmandal]

I tried this but it throws an invalid json response error. kindly help

[muhammadaqil]

error DataTables warning: table id=myTable - Requested unknown parameter '0' for row 0, column 0. what the problem??

[lumierre]

What if my approach was PDO and OOP? And All of my methods are in one php file?

[lovewithcloud]

Thanks, can we send a post request with a parameter to any API to get the data ?

[christiantampus]

how to display data having the same age? pls help thank you