How to get valid JSON from text fields with special characters ?
How to get valid JSON from text fields with special characters ?
Until recently, I have been successful in implementing the server side processing example with hidden row details - using JSON input served from a MYSQL db. Very impressed with DataTables!
Unfortunately, now that I added a text field with special characters - my JSON is invalid. The field with the problem is Description.
http://ageara.com/exp3/server_processing_details_col.php
Looking for suggestions for filtering / sanitizing / cleaning text response from mysql_select to generate valid JSON?
Thus far I haven't had any success with TRIM() in PHP.
Unfortunately, now that I added a text field with special characters - my JSON is invalid. The field with the problem is Description.
http://ageara.com/exp3/server_processing_details_col.php
Looking for suggestions for filtering / sanitizing / cleaning text response from mysql_select to generate valid JSON?
Thus far I haven't had any success with TRIM() in PHP.
This discussion has been closed.