PHP - Mysql Table

iso sio

Hi There
i like to know how to use mysql table instead of json for selecting data with the child Row ?

Currently below is given in Example

$(document).ready(function() {
var table = $('#example').DataTable( {
"ajax": "objects.json",
"columns": [
{
"className": 'details-control',
"orderable": false,
"data": null,
"defaultContent": ''
},
{ "data": "a" },
{ "data": "b" },
{ "data": "c" }
],
"order": [[1, 'asc']]

} );

but i 'd like to select data from mysql Table
and i don't know how to select my php file
Thanks
iso

tangerine

Look at the server-side example
https://datatables.net/examples/data_sources/server_side.html
and note the different ajax call.

colin

Hi @iso sio ,

One thing to note with your question, is that Json is the transport format - whereas MySQL is the storage. You would still use Json to get the data from the server to the client.

Cheers,

Colin

iso sio

Dar tangerine
thanks for your response tried but unfortunately i could not succeed ,
would appreciate if i can get the script for CHILD ROW how to connect my select.php
which corospondence with mysql DB Table

kthorngren

Does this blog help?
https://datatables.net/blog/2017-03-31

Kevin