Can't View data retrieved from MYSQL which is converted into JSON using PHP

Question

I am like to view the data retrieved by the SQL statement but when doing it only json_response display the data but what I want to see is echo json_encode($json_response) format of data.
I follow this tutorial but did not get the same result.
json_encode($json_response) shows no data AKA plain screen
http://www.webslesson.info/2016/05/convert-data-from-mysql-to-json-formate-using-php.html

$query = "SELECT * from LibraryEvents";

  $result = mysqli_query($connDB,$query);

  $json_response = array();
  while($row = mysqli_fetch_assoc($result)) {
        $json_response[] = $row;
        //array_push($json_response,$row_array);
  }

  echo '<pre>';
  print_r($json_response);
  echo '<pre>';
  echo json_encode($json_response);

print_r($json_response) show all data but echo json_encode($json_response) show no data — Theo Frank, Jan 28 '18 at 17:13
There is data since I did say print_r display data but json_encode does not display anything — Theo Frank, Jan 28 '18 at 17:17
$connDB = mysqli_connect("localhost","user","pass","database"); its your $connDB is right ? — Ganesh Kandu, Jan 28 '18 at 17:28
Yes. I have tested the database which should not be the problem since **print_r display data** but **json_encode does not display anything**. https://i.imgur.com/NQiJkgv.jpg — Theo Frank, Jan 28 '18 at 17:33
The problem currently is json_encode does not show any anything — Theo Frank, Jan 28 '18 at 17:34

score 1 · Accepted Answer · answered Jan 28 '18 at 17:36

1

Frequenty, this is due to your response having accents: if your response has accents (é, à, etc.), json_encode will not work properly.

This might help you: How to json_encode array with french accents?

answered Jan 28 '18 at 17:36

Bernz

171
3

Thanks. Your answer solve the problem. After changing word with accent, it solved everything. – Theo Frank Jan 28 '18 at 17:44

Can't View data retrieved from MYSQL which is converted into JSON using PHP

1 Answers1