How do I send a bunch of json objects in an ajax response with jquery

Question

I'm playing with jQuery's $.ajax and I'm not sure how I should be doing the following:

Here's my javascript (right now its just embedded in the html page)

$.ajax({
    type: 'GET',
    url: 'DBConnect.php',
    data: '',
    dataType: 'json', 
    success: function(data) {

        console.dir(data);
    },
    error:function (xhr, ajaxOptions, thrownError) {
        dir(thrownError);
        dir(xhr);
        dir(ajaxOptions);
    }
});

Here is what DBConnect.php looks like:

$username = "root";
$pass = "pass";
$host = "127.0.0.1";
$dbname = "test";

//queries
$table = "events";
$fetchAll = "SELECT * FROM $table";

try {
    $DB = new PDO("mysql:host=$host;dbname=$dbname", $username, $pass);
    //_WARNING uncommented when debugging
    $DB->setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING );
    //$DB->setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION );
    $query = $DB->query($fetchAll);
    $query->setFetchMode(PDO::FETCH_OBJ);

    while($row = $query->fetch()) {
        echo json_encode($row);
    }

} catch(PDOException $e) {
    echo $e->getMessage();
}

$DB = null;

Doing this I get a syntax error. I thought I could get away with returning every row as a json object, but clearly that doesn't work. I could just add all the row objects to one array and convert that to json, but I wanted to know if there was a better\more efficient way to do this.

This will just return the first row of your result...

Leonardo
– Leonardo

2014-05-14 20:13:02 +00:00
Commented May 14, 2014 at 20:13 — Leonardo
– Leonardo, Commented May 14, 2014 at 20:13
Concat the rows first, then json_encode().

Jay Blanchard
– Jay Blanchard

2014-05-14 20:13:46 +00:00
Commented May 14, 2014 at 20:13 — Jay Blanchard
– Jay Blanchard, Commented May 14, 2014 at 20:13

Brian Anderson · Accepted Answer · 2014-05-14 20:15:39Z

1

Change the while loop:

$temp = array();
while($row = $query->fetch()) {
    $temp[] = $row;
}
echo json_encode($temp);

Try this, and let me know if that helps!

answered May 14, 2014 at 20:15

Brian Anderson

6217 silver badges22 bronze badges

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

2 Comments

red888 Over a year ago

I figured I would have to do that. But is this an appropriate way to pass json data back to the browser? I guess I'm really asking if my general approach is flawed -should have made that clearer in my question.

Brian Anderson Over a year ago

Your original approach is indeed flawed. You cannot continue to echo results in a while loop. The output would not be a valid json object (it would be a string of concatenated json objects).

Collectives™ on Stack Overflow

How do I send a bunch of json objects in an ajax response with jquery

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