I am writing "ments" from my website in my database with PHP using mysql_real_escape_string(). this will escape stuff out, as well as single-quote (') and double-quotes ("). when I load these ments back into my website, I'm using AJAX to load them, triggered by the scroll bar of a DIV to load 5 more on each scroll bar that reached bottom of DIV.

Everything works fine until an entry containes escaped \' (single-quote)

var ajax_entry_items = JSON.parse(http.responseText);

the JSON.parse function gives the error

Uncaught SyntaxError: Unexpected token ' in Google Chrome.

How can I still input single-quotes and double-quotes in my ments in my database and bring them back to display them on the website ? The double-quotes and single-quotes e back escaped but for some reason the single-quote, escaped, generates the

Unexpected token" error.

Thanks.

I am writing "ments" from my website in my database with PHP using mysql_real_escape_string(). this will escape stuff out, as well as single-quote (') and double-quotes ("). when I load these ments back into my website, I'm using AJAX to load them, triggered by the scroll bar of a DIV to load 5 more on each scroll bar that reached bottom of DIV.

Everything works fine until an entry containes escaped \' (single-quote)

var ajax_entry_items = JSON.parse(http.responseText);

the JSON.parse function gives the error

Uncaught SyntaxError: Unexpected token ' in Google Chrome.

How can I still input single-quotes and double-quotes in my ments in my database and bring them back to display them on the website ? The double-quotes and single-quotes e back escaped but for some reason the single-quote, escaped, generates the

Unexpected token" error.

Thanks.

• php
• javascript
• ajax
• json

• Run your text through the JSON validator. It can help in debugging issues like this. jsonformatter.curiousconcept. – Brandon J. Boone Commented Jun 3, 2012 at 12:30

2 Answers 2

It is not allowed to enclose strings in single quotes, nor to escape single quotes, in JSON. You must escape double quotes and must not escape single quotes.

You should encode the data you're outputting from the database with json_encode():

echo json_encode($data);