JSON array always empty

Question

I am returning a JSON array from PHP and this is always empty. Is there something obvious I am missing?

<?php
    require("config.inc.php");
    $return_arr = array();

    $fetch = mysql_query("SELECT startingBool, endingBool FROM vote_count");

    while ($row = mysql_fetch_array($fetch, MYSQL_ASSOC)) {
        $row_array['startingBool'] = $row['startingBool'];
        $row_array['endingBool'] = $row['endingBool'];
        array_push($return_arr,$row_array);
    }

    echo json_encode($return_arr);

?>

Yes I am positive, I'm able to go into PHP myadmin and run that query and return the results I expect. — user0928377383
– user0928377383, Commented Sep 22, 2014 at 21:44
Have you tried simply while (...) { $return_arr[] = $row; } ? — Kleskowy
– Kleskowy, Commented Sep 22, 2014 at 21:45
what happens if you go var_dump($row); in that while block. What's the output? — Weltschmerz
– Weltschmerz, Commented Sep 22, 2014 at 21:45
what's the point of assigning values to $row_array rather than using $row directly. This just wastes memory. Have you verified that you enter into your while loop (i.e. have you done any basic debugging)? — Mike Brant
– Mike Brant, Commented Sep 22, 2014 at 21:47

meda · Accepted Answer · 2014-09-22 21:53:24Z

3

I see absolutely no point in $row_array, and before you mess with json, check your dump:

<?php
require("config.inc.php");

$fetch = mysql_query("SELECT startingBool, endingBool FROM vote_count");

$return_arr = array();
while ($row = mysql_fetch_array($fetch, MYSQL_ASSOC)){
    $return_arr[] = $row; 
}
var_dump($return_arr);
//echo json_encode($return_arr);
?>

answered Sep 22, 2014 at 21:53

meda

45.5k14 gold badges96 silver badges123 bronze badges

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

1 Comment

user0928377383 Over a year ago

Var dump returns array(0) {}

Weltschmerz · Accepted Answer · 2014-09-22 22:07:51Z

0

Since you say using the phpmyadmin you can see that the vote_count table has data in it. The problem is probably in your config.inc.php (or where ever you setup the db connection)

Check if it's pointing to a different database or a server than the one you're viewing through phpmyadmin.

answered Sep 22, 2014 at 22:07

Weltschmerz

2,1861 gold badge15 silver badges19 bronze badges

5 Comments

user0928377383 Over a year ago

I'm using the same config.inc.php script for other queries but they are all updates to the database of the same table but those other queries work fine.

user0928377383 Over a year ago

I'm using this generic script: pastebin.com/eM3VT4V6 with my information filled in at the top.

user0928377383 Over a year ago

Weltschmerz Over a year ago

Your code should work. Smells like some configuration problem. I still doubt that code is using the same db as the phpmyadmin where you can see data in the vote_count

user0928377383 Over a year ago

I directly included the connection in the page and im getting results now

Brandon Garcia-Acain · Accepted Answer · 2014-09-22 22:27:21Z

0

Looks like the script is using PDO so it would be something like this:

$query = $db->query("SELECT startingBool, endingBool FROM vote_count");

$return_arr = array();
while ($row = $query->fetch(PDO::FETCH_ASSOC)) {
    $return_arr[] = $row; 
}
echo json_encode($return_arr);
?>

edited Sep 22, 2014 at 22:27

answered Sep 22, 2014 at 22:20

Brandon Garcia-Acain

865 bronze badges

Collectives™ on Stack Overflow

JSON array always empty

3 Answers 3

1 Comment

5 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

5 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related