Null php json while econde a query from mySQL with accents [duplicate]

Question

When I try to encode on a JSON a query from MySQL database that gives me a null JSON when the words have accents eg. " olá " , " à " etc

my php code:

$sql = "SELECT `name`
          FROM `login`
         WHERE `id`='1';";

$result = mysqli_query($conn, $sql);
     
$emparray = array();
while($row = mysqli_fetch_assoc($result)){
    $emparray[] = $row;
}
echo json_encode($emparray,JSON_UNESCAPED_UNICODE);

my database:

id  |  name | 
1   |  Olá  |

What version php are you using? The JSON_UNESCAPED_UNICODE constant was added in php 5.4 meaning if you are on an older version json_encode would return null and throw a notice (undefined constant) and warning (invalid argument) errors. Outside of that, I don't see an issue with the code (3v4l.org/HqIvU) so I would start with the usual, check the error logs. — Jonathan Kuhn
– Jonathan Kuhn, Commented Aug 30, 2016 at 18:36
Which encoding and collation are you using for table "login"? Did you try to fill $emparray manually from PHP? — Ondřej Šotek
– Ondřej Šotek, Commented Aug 30, 2016 at 18:46
step one: ensure you are utf-8 all the way down. Don't expect encoding compatibiliy to work without explicitly telling everything exactly what you need. — Mike 'Pomax' Kamermans
– Mike 'Pomax' Kamermans, Commented Aug 30, 2016 at 19:30
@JonathanKuhn: terminology: json doesn't "throw" anything. it issues a notice. none of PHP's procedural functions will ever throw anything. — Marc B
– Marc B, Commented Aug 30, 2016 at 19:55

Community · Accepted Answer · 2020-06-20 09:12:55Z

1

json_encode assumes that the result is encoded in UTF-8, if it is not returned null

first verify that your database server is configured with UTF_8

or add the set_charset before the consultation

mysqli_set_charset($conn,"utf8");

Use header to modify the HTTP header, UTF-8 all the way through

header('Content-Type: text/html; charset=utf-8');

edited Jun 20, 2020 at 9:12

CommunityBot

11 silver badge

answered Aug 30, 2016 at 19:53

Dev. Joel

1,1471 gold badge9 silver badges14 bronze badges

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

Comments

Abhijit Jagtap · Accepted Answer · 2016-08-30 19:28:47Z

-1

Its working fine check Click Here

<?php
 echo json_encode("Olá ",JSON_UNESCAPED_UNICODE);
?>

answered Aug 30, 2016 at 19:28

Abhijit Jagtap

2,7322 gold badges32 silver badges45 bronze badges

Collectives™ on Stack Overflow

Null php json while econde a query from mySQL with accents [duplicate]

2 Answers 2

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Linked

Related