Recommended Approach for Load Datatable from Database Table (PHP/SQL Server)

dmm001

Hi, Many of these technologies are new to me as I have not been a programmer for a very long time. I would like to understand if I am only currently interested in DataTables (not the Editor) what would be a good/recommended way to load/initialize a Datatable with the rows from a database table. I know that I could simply write some PHP to open a recordset and output the fields with the required html tr/td formatting, but I sense that there is a better way to do this using Ajax to call a PHP Rest API for the database call or some other approach?

I appreciate any input you can provide.

kthorngren

The Ajax docs explain using ajax loaded data. Take a look at these ajax loaded examples. You might be interested in this blog that discusses using the Editor server side libraries with Datatables. It doesn't require using Editor client side nor the license. Just might make it easier for you to handle ajax loaded data.

Kevin

dmm001

Thanks @kthorngren. I will be sure to take a look.