returning a db query unto a readable assoc array for json_encode?

Question

I am using ajax to pull some data from a PHP script I created. The PHP script queries the database for user information and comment information. There will be a lot of comments and I am trying to figure out how to return 3 records (LIMIT 3) - this is what I have:

foreach($results->fetch_assoc() as $key => $db_value) {
    //$array[$key] = $db_value;
    print_r($results->fetch_assoc());
}

$results->fetch_assoc() returns a single record set. I was messing around and couldn't figure it out.

What I am trying to do is have 3 arrays returned to the HTML doc via json_encode so that I can read it and display it. Can anyone help?

Marc B · Accepted Answer · 2011-07-22 16:38:45Z

2

$data = array();

while ($row = $results->fetch_assoc()) {
   $data[] = $row; // stuff new row onto end of array
}

echo json_encode($data);

answered Jul 22, 2011 at 16:38

Marc B

362k44 gold badges433 silver badges508 bronze badges

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

Collectives™ on Stack Overflow

returning a db query unto a readable assoc array for json_encode?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related