Retrieving JSON data with .getJSON from a php file

Question

I've got a problem with sending json data.

Here's my php file:

<?php
session_start();
$con = mysql_connect("localhost","root","");
if (!$con) {
die('Could not connect: ' . mysql_error());
}
mysql_select_db("db", $con);
$result_array = array();
$result = mysql_query("SELECT Reg FROM bool");

while ($row = mysql_fetch_array($result)) 
$result_array[] = $row;


echo json_encode($result_array);
mysql_close($con);
?>

And here's my js script:

$(function () {
    $(document).ready(function() {
    $.getJSON("sql_bool.php", function(data) {
    alert(data[1]);     
    });    
});    
});

I've got some bool data stored in my database, and when i try to check with an alert() function if it made it through, all i get is an alert window with

[object Object]

Any idea what's wrong?

Can you do console.log(data) instead? alert is too crude. (Make sure to open the debug console; F12 in most browsers). — Halcyon
– Halcyon, Commented Nov 28, 2014 at 0:04
Do what Halcyon suggests, and also add header("Content-Type: application/json"); in your php script. — Darren
– Darren, Commented Nov 28, 2014 at 0:05

Touch Cat Digital Inc. · Accepted Answer · 2014-11-28 00:10:07Z

1

It sounds like it went through fine. When you alert in JavaScript it turns whatever you alert into a string. In this case your object as a string would be [ object object].

You could try:

for(var k in data[1]){ alert(k); alert(data[1][k]); }

answered Nov 28, 2014 at 0:10

Touch Cat Digital Inc.

1431 silver badge10 bronze badges

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

Comments

ILOABN · Accepted Answer · 2014-11-28 00:14:40Z

0

What you get back is a JSON encoded object. If you give that to javascript using getJSON it will handle it like an object. If you want to see the actual string you got back from the server, you could try this:

alert(JSON.stringify(data));

That should output everything you got back from the PHP script in a readable manner :)

answered Nov 28, 2014 at 0:14

ILOABN

6207 silver badges21 bronze badges

Collectives™ on Stack Overflow

Retrieving JSON data with .getJSON from a php file

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related