Passing multidimensional array to Javascript

Question

Trying to pass multidimensional php array to Javascript using JSON. The code refuses to enter the success state of JSON, why is this?

This is javascript file:

array = [];

function callback(arr)
{
 console.log(array);
 //simpleText.setText = array[0]
};
$(document).ready(function() {
 $.getJSON('database.php', function(phpdata){
    console.log("po");
    console.log(phpdata);
    callback(phpdata);
  });

});

And php file:

header("Content-type: application/json");
mysql_connect("localhost", "root", "") or die(mysql_error()); 
mysql_select_db("atlas") or die(mysql_error()); 

$data = mysql_query("SELECT * FROM questions") 
or die(mysql_error()); 

$i = 0;
$result_array = array();
 while ($Row = mysql_fetch_array($data)) 
{ 
$user[] = array( 
'id'=>$Row['id'], 
'q'=>$Row['q'],
'a'=>$Row['a'],
'coordx'=>$Row['coordx'],
'coordy'=>$Row['coordy'],
    ); 
} 


var_dump($user);

$json = json_encode($user[0]);


echo $json;

You're not passing a multidimensional array. You're just passing $user[0], which is one row, which is a one-dimensional array. — Barmar
– Barmar, Commented Nov 23, 2013 at 0:45
You need to take var_dump() out of the script. It will be read by $.getJSON, but it's not valid JSON. — Barmar
– Barmar, Commented Nov 23, 2013 at 0:46
As a total side-note, you should use mysql_fetch_assoc and then $user[] = $Row;, save yourself some time and energy by letting the mysql driver do the work for you (us2.php.net/mysql_fetch_assoc) — Rob M.
– Rob M., Commented Nov 27, 2013 at 8:49

Barmar · Accepted Answer · 2013-11-23 00:47:23Z

2

Remove the

var_dump($user);

line. It's making the result invalid JSON.

answered Nov 23, 2013 at 0:47

Barmar

789k57 gold badges554 silver badges669 bronze badges

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

Comments

Nikolai Samteladze · Accepted Answer · 2013-11-23 00:12:02Z

1

getJSON jQuery function does not return errors. Use ajax function below and check your error message and returned JSON (inside jqXHR object):

$.ajax({
    url: 'database.php',
    dataType: 'json',
    success: function(data, textStatus, jqXHR) {
        // success
    },
    error: function(jqXHR, textStatus, errorThrown) {
        // error
    }
});

answered Nov 23, 2013 at 0:12

Nikolai Samteladze

7,8076 gold badges46 silver badges71 bronze badges

1 Comment

Bobbie Over a year ago

It seems like i'm getting a SyntaxError{} from the errorThrown, any idea why?

Collectives™ on Stack Overflow

Passing multidimensional array to Javascript

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related