Why My PHP code is not working to show UTF-8 from mysql?

Question

This is my code

$sql = 'SELECT * from customer';
  $statement = $connection->prepare($sql);
  $statement->execute();
  if($statement->rowCount())
  {
    $row_all = $statement->fetchall(PDO::FETCH_ASSOC);

    echo json_encode($row_all);         
  }  
  elseif(!$statement->rowCount())
  {
    echo "no rows";
   }

it show "????".when retrieve from thai alphabet.where i have to fix code in the linecode? thank you so much

[UTF-8 all the way through](http://stackoverflow.com/questions/279170/utf-8-all-the-way-through) — simon, Dec 21 '16 at 07:54
By the way, to easily handle the output on the front-end / receiving end, you should also send back json in case no rows were found. — jeroen, Dec 21 '16 at 07:57

score 0 · Answer 1 · edited Dec 21 '16 at 09:27

0

Try to add this code in the first line in your php file

header('Content-type: text/plain; charset=utf-8');

edited Dec 21 '16 at 09:27

Nikolay K

3,770
3
25
37

answered Dec 21 '16 at 07:52

Vijaya Vignesh Kumar

444
3
14

score 0 · Answer 2 · answered Dec 21 '16 at 07:53

0

Run the following queries before your query.

$connection->query("SET NAMES 'utf8'");
$connection->query('SET CHARACTER SET utf8');

answered Dec 21 '16 at 07:53

Muhammad Hassaan

7,296
6
30
50

Thank you so much,It's work. – ManaRuT Dec 21 '16 at 08:54
@ManaRuT please mark tick my answer if you found it helpful to you :) – Muhammad Hassaan Dec 21 '16 at 09:25

score 0 · Answer 3 · answered Dec 21 '16 at 07:55

0

you can update your table column collation type to "utf8_general_ci" if you want to insert any Thai symbol on it

answered Dec 21 '16 at 07:55

Amit Kumar Sahu

495
6
15

Why My PHP code is not working to show UTF-8 from mysql?

3 Answers3