JSON character encoding in php script

Question

I am retrieving json from a php file that connects to the database and then creates the json to be imported into my page via an ajax call.

Some of the database columns have file paths in them, ie images/myfolder/myfile

The json that I see when I open the page in a web browser formats the file path like this:

\/images\/myfolder\/myfile

Are the escaped characters going to break the json?

i.e, if i do var icon_image = myData.file

will icon_image hold: \/images\/myfolder\/myfile or /images/myfolder/myfile

I am hoping the second option from above, but if it doesn't how do I get it to display as /images/myfolder/myfile

I have put mb_internal_encoding( 'UTF-8' ); at the top of the php page

The script that generates the json is as follows:

mb_internal_encoding( 'UTF-8' );
mysql_select_db($database_growth_conn, $growth_conn);
$query_rs_icons = sprintf("SELECT * FROM icons_ico ORDER BY name_ico");
//echo($query_rs_icons);
$rs_icons = mysql_query($query_rs_icons, $growth_conn) or die(mysql_error());
$row_rs_icons = mysql_fetch_assoc($rs_icons);
$totalRows_rs_icons = mysql_num_rows($rs_icons)
$rows = array();

while($r = mysql_fetch_assoc($rs_icons)) {
    $rows[] = $r;
}

$jsondata = json_encode($rows);
echo '{"icons":'.$jsondata.'}';

Why would they break the json? What gives you the idea it would? I don't understand. — Pekka
– Pekka, Commented Nov 10, 2010 at 13:21
just because in the output on the browser it has \/ i reaslised it was an escaped character but was not sure how json dealt with it. so thats why i asked the question, just searching for knowledge! — Dizzy Bryan High
– Dizzy Bryan High, Commented Nov 10, 2010 at 14:18

bobince · Accepted Answer · 2010-11-10 13:21:56Z

1

are the escaped characters going to break the json?

No. A backslash-escaped non-special punctuation is just the same as the punctuation itself. The JS string literals "a/b" and "a\/b" result in the same string value, a/b.

json_encode escapes the forward slash character for you so that if you try to include a string with the sequence </script> in it in a script element, it doesn't prematurely end the script block.

answered Nov 10, 2010 at 13:21

bobince

538k111 gold badges675 silver badges846 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Dizzy Bryan High Over a year ago

nice thanks, i wanted to check before i started doing the jquery that was going to use it,

Collectives™ on Stack Overflow

JSON character encoding in php script

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related