Trouble getting array back from JSON call to SQL

Question

Just trying to grab everything from a table "guesses" sorted by "cnt" and turn it into a javascript array. Can't get it to give me anything I can work with, though.

PHP file:

<?php 
$dbhost = 'localhost'; 
$dbuser = 'root'; 
$dbpass = 'root'; 
$dbname = 'words'; 
$dbtable = 'guesses'; 

//------ DATABASE CONNECTION --------// 
mysql_connect($dbhost,$dbuser,$dbpass) 
or die ("Unable to connect to database"); 

mysql_select_db($dbname) 
or die ("Unable to select database"); 

$sql = "SELECT * FROM $dbtable ORDER BY cnt ASC";
$result = mysql_query($sql);

while($array = mysql_fetch_assoc($result)) {
    echo json_encode($array);
}

?>

JavaScript:

    $.getJSON('grab.php', function(response) {
    // response is a JSON object that contains all the info from sql query
    // tried so much stuff here... no avail.
        console.log(response);
})

The console doesn't say anything. "SELECT * FROM guesses ORDER BY cnt ASC" in the phpmyadmin console DOES return the correct entries and order.

EDIT: I've also tried

<?php 
$dbhost = 'localhost'; 
$dbuser = 'root'; 
$dbpass = 'root'; 
$dbname = 'words'; 
$dbtable = 'guesses'; 

//------ DATABASE CONNECTION --------// 
mysql_connect($dbhost,$dbuser,$dbpass) 
or die ("Unable to connect to database"); 

mysql_select_db($dbname) 
or die ("Unable to select database"); 

$sql = "SELECT * FROM $dbtable ORDER BY cnt ASC";
$result = mysql_query($sql);

while($array = mysql_fetch_assoc($result));
echo json_encode($array);

?>

Which might be syntactically better(???) but it returns "false" to console, and nothing else.

can only send one json string to client, you are sending for every pass of loop — charlietfl
– charlietfl, Commented Nov 28, 2013 at 2:03

Vicky Gonsalves · Accepted Answer · 2013-11-28 02:04:27Z

1

You are encoding json at wrong place.

$arr=array();
while($array = mysql_fetch_assoc($result)) {
    array_push($arr,$array);
}
echo json_encode($arr);

Try this

answered Nov 28, 2013 at 2:04

Vicky Gonsalves

11.8k3 gold badges39 silver badges58 bronze badges

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

6 Comments

prismspecs Over a year ago

Hmm still returning false :/

prismspecs Over a year ago

when I console.log response, it just says false.

prismspecs Over a year ago

EUREKA! Well done. Now to figure out how to parse this so my front-end brain can make use of it. Ideas? ;-)

Sico Over a year ago

$.each over the response

Vicky Gonsalves Over a year ago

Its better u try it first...:))

|

Collectives™ on Stack Overflow

Trouble getting array back from JSON call to SQL

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related