Invalid Json reponse with extrawhere condition

zlen

I use the PHP SSP class from this address : http://74.207.246.202/ssp/example/.

With this class, all my pages using Datatable work because it allows me to put the conditions in the SQL query. In recent days, I try to parse the result of two new tables (with the same column names as those in which I already use Datatable and it works) and I get the error tn/1 saying Datatable can not encode JSON return of the script.

What is very strange is that if I do a var_dump ($results), I get a good result makes sense. Why json_encode does not?

I also noticed that if I apply the condition "column_id = 1", so using the "=" json is not created. What can produce it, knowing that it works fine on all other pages?

tangerine

That is a third-party class, not part of the DataTables package. The author of the class offers support here: https://emranulhadi.wordpress.com/2014/06/05/join-and-extra-condition-support-at-datatables-library-ssp-class/

zlen

Don't thought about that. Thank you