ssp.class.php version in sqli?

ScottSchmidt

I noticed the ssp.class.php file (which looks like is required for server-side processing) is in SQL. Is there a updated sqli version? OR a different method? I am just looking for the most simple solution.

Link to file:
https://github.com/DataTables/DataTables/blob/master/examples/server_side/scripts/ssp.class.php

ScottSchmidt

Code is from: https://datatables.net/examples/data_sources/server_side.html
// SQL server connection information
$sql_details = array(
'user' => '',
'pass' => '',
'db' => '',
'host' => ''
);

/* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* If you just want to use the basic configuration for DataTables with PHP
* server-side, there is no need to edit below this line.
*/

require( 'ssp.class.php' );

echo json_encode(
SSP::simple( $_GET, $sql_details, $table, $primaryKey, $columns )
);

If I do use the file as is, does that mean adapt all my files to SQL? like my index.php & con.php files.

ScottSchmidt

Might of found the answer to my 2nd question according to Allen: "No - don't use the SSP class at all if you are using Editor. Editor's own libraries have built in support for server-side processing and will automatically detect a server-side processing request - ." https://editor.datatables.net/examples/simple/server-side-processing.html

Source: https://datatables.net/forums/discussion/31880/ssp-class-php-not-found

allan

Both the demo SSP class and Editor use PDO rather than the PHP mysqli_* functions.

Do you have the MySQL PDO driver installed on your PHP install? If so, go with that .

Allan