Unable to retrieve json data using jquery

Question

i am a newbie and am stuck at retrieving json data.

following is my index.php :

<script type="text/javascript" src="jquery-1.3.2.min_2.js"> 
$("document").ready(function() {

    $.getJSON("data.php",function(jsondata){
    $("#content").html(jsondata[0].content);    

    });
});
</script>
</head>
<body>
<div id="content"></div>
<div class="lg"></div>
</body>

in my data.php i am using the standard way of encoding and sending the data:

// execute query 
        $result = mysql_query($query) or die ("Error in query: $query. ".mysql_error()); 
         $row = mysql_fetch_row($result);
         $jsonserver[$i] = $row;
    }
    echo json_encode($jsonserver); 
    header('Content-type: application/json');
    mysql_free_result($result); 
    // close connection 
    mysql_close($con);

i am using mysql database. when i open localhost/data.php the json data is shown on the browser. but in case if i open localhost/index.php i donot get any desired output. Please explain. Thanks!

Is that the full code of index.php? Do you have an element with id="content"? — Xint0
– Xint0, Commented Mar 9, 2011 at 23:36
Uncaught ReferenceError: manifest is not defined this is the error i get in chrome on pressing ctrl+shift+i when i execute data.php, however firebug doesnot show anything of this sort in firefox. — whatf
– whatf, Commented Mar 9, 2011 at 23:50
You should send the response headers before the content. Also make sure PHP file doesn't have any characters or spaces before the <?php opening tag, because this will cause PHP to send the default headers most common would be: Content-type: text/html. — Xint0
– Xint0, Commented Mar 10, 2011 at 0:19

Naftali · Accepted Answer · 2011-03-10 00:51:17Z

1

you need to put all headers before any 'echo's on the page

so:

header('Content-type: application/json');
echo json_encode($jsonserver);

answered Mar 10, 2011 at 0:51

Naftali

147k41 gold badges247 silver badges304 bronze badges

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

1 Comment

whatf Over a year ago

thanks for your effort, doesnt your suggestion doesn't seem to work.

xkeshav · Accepted Answer · 2011-03-10 05:05:29Z

0

Hey, u didn't close script tag properly

try

<script type="text/javascript" src="jquery-1.3.2.min_2.js"></script>
<script type="text/javascript">
$("document").ready(function() {
  $.getJSON("data.php",function(jsondata){
        $("#content").html(jsondata[0].content);
    });
});
</script>

answered Mar 10, 2011 at 5:05

xkeshav

54.2k47 gold badges183 silver badges255 bronze badges

2 Comments

xkeshav Over a year ago

also use console.log(jsondata) to debug

whatf Over a year ago

great observation, still what i feel the problem lies in data.php as well. chrome inspector gives the follwoing error:Uncaught ReferenceError: manifest is not defined

Collectives™ on Stack Overflow

Unable to retrieve json data using jquery

2 Answers 2

1 Comment

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related