How to echo json array of particular rows in the SQL database?

Question

How do I fix the following code to echo the JSON encoded array of particular rows in the SQL database table? Because all I get right now is: { "mailbox":[] }

Here is my code:

$query = "SELECT * FROM messages WHERE touser='$from'";

$result = mysql_query($query)
    or die("\n\ndatabase error!\n". mysql_error());

$mailbox = array();

while($row = mysql_fetch_assoc($result)){
$mailbox[] = $row;
}

echo "{ \"mailbox\":".json_encode($mailbox)." }";

Martin Wickman · Accepted Answer · 2013-04-13 07:42:05Z

1

Are you sure $mailbox array contains anything? My bet is that your mysql query returns an empty resultset.

Insert a echo "Got a row: \n"; print_r($row); inside the while loop to check this.

If that gives nothing then your SQL is wrong or your tables contains no data. To see the actual query, insert echo "Query: '$query'\n". Now run the query manually without involving php.

edited Apr 13, 2013 at 7:42

answered Apr 13, 2013 at 7:28

Martin Wickman

20k13 gold badges85 silver badges111 bronze badges

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

2 Comments

Keegs Over a year ago

Thanks, I got the echo $query to display something, and then it was easy to display the $mailbox.

Keegs Over a year ago

But one question though (it is related), in my testing I made the LogCat act as a backup display, so that I should be seeing the same thing coming back to the emulator and on the php page. But only the LogCat displays the mailbox's contents, and the php page still says mailbox array is empty?

Collectives™ on Stack Overflow

How to echo json array of particular rows in the SQL database?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related