Language support in creating json from php

Question

I would like to json in Korean. The language of my aap is English. The problem is that its replace Korean language to ?????. My code snippet is:

<?php
 $mysqli = new mysqli ( '50.62.209.85:3306', 'local', 'root123', 'android');
// Check if album id is posted as GET parameter
 $myq = $mysqli ->query ( 'SELECT id, url, name FROM HollywoodMovies' );
 while ( $myr = $myq->fetch_assoc () ) {
 $array["items"][] = (array(
'id' => $myr['id'],
'id' => $myr['url'],
'title' => $myr['name'],
));
}
echo json_encode($array);
?>

http://stackoverflow.com/questions/21645243/why-my-json-string-is-null/21645380#21645380 might help you.. — Abhik Chakraborty, Mar 21 '14 at 10:02
Are you sure the data is coming correctly from the database...?! — deceze, Mar 21 '14 at 10:03
Tried utf8_encode or something like https://gist.github.com/muhqu/863757? What do the results look like? — Jonast92, Mar 21 '14 at 10:04
why you put comma `,` at the end of title index in array (or is this typo mistake) and two index with same name `id`?? — Blu, Mar 21 '14 at 10:16
@BluAngel its work fine only problem in title its just allow english but korean language replace with ????? question mark — user3445805, Mar 21 '14 at 10:23
can you try that line `print_r($array)` before `echo json_encode($array);` and see what is output print? — Blu, Mar 21 '14 at 10:27

score 0 · Answer 1 · edited Mar 21 '14 at 10:11

0

json_encode documentation

string json_encode ( mixed $value [, int $options = 0 [, int $depth = 512 ]] )

For paramater value:

All string data must be UTF-8 encoded

Check if your data is encoded in UTF-8

edited Mar 21 '14 at 10:11

Nick Weaver

47,228
12
98
108

answered Mar 21 '14 at 10:06

openghost

62
3

okay thanks but in above code what can i do because i dont know php please help me. – user3445805 Mar 21 '14 at 10:11
Okay, but for graphicly manage your database? Creat, edit, view table, etc. – openghost Mar 21 '14 at 17:31
So what is the collation of the columns who content text data for the table HollywoodMovies ? You can see that with the following navigation: server -> db -> table -> structure – openghost Mar 22 '14 at 12:21

Language support in creating json from php

1 Answers1