PHP json_encode doesn't print anything

Question

I'm running PHP and MySQL and have the following code:

$data = array();
$result = mysql_query($search_query);
if ($result){
    while($row = mysql_fetch_assoc($result)) {
        $data[] = $row;
    }
    if (sizeof($data) > 0) {
        //var_dump($data);
        echo json_encode($data);
    } else {
      echo 'empty';
    }
}

If my query has no rows I do get empty returned. But if there's any records I get a Resource has no content in Safari.

But if I uncomment my //var_dump($data); then I do get a nice array of values.

Take a look at your out of date mysql_ functions: stackoverflow.com/questions/12859942/… — JustBaron
– JustBaron, Commented Jun 25, 2018 at 10:47
What does json_last_error() say? php.net/manual/en/function.json-last-error-msg.php — Mr Glass
– Mr Glass, Commented Jun 25, 2018 at 10:48
` $res = array_map('utf8_encode', $res); ` sovled it. Thank you. — Alfred Balle
– Alfred Balle, Commented Jun 25, 2018 at 10:52

Vincenzo · Accepted Answer · 2018-06-25 11:02:08Z

0

Try this:

// Database connection.
$mysqli = new mysqli('localhost', 'user', 'password', 'db_name');

// Your query.
$search_query = "SELECT * FROM yuor_table";

$data = array();
$result = $mysqli->query($search_query);
if ($result){
    while($row = $result->fetch_assoc()) {
        $data[] = $row;
    }
    if (sizeof($data) > 0) {
        //var_dump($data);
        echo json_encode($data);
    } else {
      echo 'empty';
    }
}

This is very simple solution. I would suggest to use "mysqli".

answered Jun 25, 2018 at 11:02

Vincenzo

193 bronze badges

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

3 Comments

Progrock Over a year ago

Why will this fix the problem? Seems the OP has no problem fetching rows.

Vincenzo Over a year ago

@Progrock I suppose that the real problem is not procedural style but wrong use of "mysql" function during connection or database selection. Anyway, "mysqli" extension is much more indicated than deprecated "mysql".

Progrock Over a year ago

But the issue here looks to be the json encoding. Not necessarily their database connection.

Collectives™ on Stack Overflow

PHP json_encode doesn't print anything

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related