Datatables ssp::complex error PHP ssp.class.php

stevenrojas888

I am using server side datatables. I send a query where to ssp::complex. The query is made. The problem is when you type something in the search input. I get an error and it doesn't work. Any idea?

ERROR

JS

$('.tablaClientesSS').DataTable({ processing: true, serverSide: true, ajax: { "url": "serversideajax/clientes.serverside.php", } });

PHP

`<?php

session_start();

if ($_SESSION['perfil'] === 'principal') {
$principal = $_SESSION['id'];
} elseif ($_SESSION['perfil'] === 'secundario') {
$principal = $_SESSION['principal'];
}

/*
* DataTables example server-side processing script.
*
* Please note that this script is intentionally extremely simply to show how
* server-side processing can be implemented, and probably shouldn't be used as
* the basis for a large complex system. It is suitable for simple use cases as
* for learning.
*
* See http://datatables.net/usage/server-side for full details on the server-
* side processing requirements of DataTables.
*
* @license MIT - http://datatables.net/license_mit
*/

/* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* Easy set variables
*/

// DB table to use
$table = 'clientes';

// Table's primary key
$primaryKey = 'id';

// Array of database columns which should be read and sent back to DataTables.
// The db parameter represents the column name in the database, while the dt
// parameter represents the DataTables column identifier. In this case simple
// indexes
$columns = array(
array( 'db' => 'id', 'dt' => 'id' ),
array( 'db' => 'tipoCliente', 'dt' => 'tipoCliente' ),
array( 'db' => 'id', 'dt' => 'acciones' ),
array( 'db' => 'razonSocialNombres', 'dt' => 'razonSocialNombres' ),
array( 'db' => 'apellidos', 'dt' => 'apellidos' ),
array( 'db' => 'documentoNit', 'dt' => 'documentoNit' ),
array( 'db' => 'fcFn', 'dt' => 'fcFn' ),
array( 'db' => 'celular', 'dt' => 'celular' ),
array( 'db' => 'correo', 'dt' => 'correo' ),
array( 'db' => 'fechaCreacion', 'dt' => 'fechaCreacion' ),
array( 'db' => 'creadoPor', 'dt' => 'creadoPor' )
);

// SQL server connection information
$sql_details = array(
'user' => 'root',
'pass' => '',
'db' => 'insurance',
'host' => 'localhost'
);

// $sql_details = array(
// 'user' => 'u780303142_seguros',
// 'pass' => 'Angel2018',
// 'db' => 'u780303142_seguros',
// 'host' => 'localhost'
// );

$where = " principal=".$principal;

/* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* 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( '../modelos/ssp.class.php' );

echo json_encode(
SSP::complex( $_GET, $sql_details, $table, $primaryKey, $columns, $whereResult = null, $where)
);`

allan

Try this version of the SSP script which will hopefully resolve it.

Allan