Why are you returning this error?

Question

Why are you returning this error?

Navigation

#1 by (0 votes)

2

I'm using the jQuery Datatable plugin and started server-side activation

but when loading it it informs an alert:

DataTables warning: table id = example - Invalid JSON response. For more information about this error, please see link

Why is this error still occurring? WHY Invalid response from JSON, which is invalid ????????

The page with the html table:

<script type="text/javascript" language="javascript" class="init">

$(document).ready(function() {
    $('#example').DataTable( {
        "processing": true,
        "serverSide": true,
        "ajax": "scripts/server_processing.php",

        "order": [[ 0, "asc" ]]
    } );
} );

</script>

And server_processing.php :

<?php
$table = 'tbl_medic';
$primaryKey = 'id_Medic';

$columns = array(
    array( 'db' => 'nome', 'dt' => 0 ),
    array( 'db' => 'cidade',  'dt' => 1 ),
    array( 'db' => 'cep',   'dt' => 2 ),
    array( 'db' => 'crm',     'dt' => 3 ),
    array( 'db' => 'email', 'dt' => 4 ),
    array( 'db' => 'pastaDocumentos',     'dt' => 5 )
);

$sql_details = array(
    'user' => '***', //Usuário do banco de dados
    'pass' => '***', //Senha do banco de dados
    'db'   => '***', //Banco de dados
    'host' => 'localhost'
);

require_once( 'ssp.class.php' );
echo json_encode(
    SSP::simple( $_GET, $sql_details, $table, $primaryKey, $columns )
);

php jquery jquery-datatables

asked by anonymous 29.06.2017 / 22:49

1 answer

How to select multi-row information DataGridView C # How to use the reference of a file of a barrel in the same folder with Typescript

score 0 · Answer 1

Hello!

Try to force the array to object as follows:

$columns = (object) array(
    array( 'db' => 'nome', 'dt' => 0 ),
    array( 'db' => 'cidade',  'dt' => 1 ),
    array( 'db' => 'cep',   'dt' => 2 ),
    array( 'db' => 'crm',     'dt' => 3 ),
    array( 'db' => 'email', 'dt' => 4 ),
    array( 'db' => 'pastaDocumentos',     'dt' => 5 )
);