JSON encoded data from PHP, doesn't display right when callback from jQuery

Question

My HTML/jQuery Code

<div id="divResult"></div>

function doSearch(str){
var jsonString = str;//$.parseJSON//JSON.stringify(str);
$.ajax({
    type:'GET',
    url:'search.php',
    data:{data:jsonString},
    success:function(data){
        for( var key in data ) {
      alert(key);
    }       
});
}

My problem is that when I tried to parse the JSON (display it) I'm not getting the expected result, The data gets displyed in a manner of per text per line eg.

The JSON data was [{"userid:1,name:paul"},{"userid:5,name:jackson"}]

The display on the browser is like this,

[
{
"
u
s
e
r
i
d
:
1

and so on so forth...

I can't understand? is there something wrong?

I tried my js code with jsFiddle and it looks good,

I expect something like these;

1 Paul
5 Jackson

PHP Code is;

if ($stmt->execute(array("%$_GET[data]%"))) {
  while ($row = $stmt->fetch()) {    
    $aResult[] = array(
        'userid'    => $row['ui_userid'],
        'category'  => $row['ui_jocategory']
        );
        //print_r($aResult);
  }  
  echo json_encode($aResult);
}

Thanks in advance..

I think the problem is in the quotes, can you please post the var as prepared from server, and the dump of the array you are encoding? — kappa
– kappa, Commented Mar 13, 2012 at 7:47

Alex Pliutau · Accepted Answer · 2012-03-13 07:46:06Z

4

Add dataType: 'json' to your ajax options.

answered Mar 13, 2012 at 7:46

Alex Pliutau

22k28 gold badges115 silver badges144 bronze badges

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

2 Comments

vpbot Over a year ago

i think this did the trick, however, just to fix myself, i've been trying that before but (well maybe got jumbled somewhere), why do i need the dataType option for the $.ajax?

Alex Pliutau Over a year ago

Because your php script returns JSON data.

Community · Accepted Answer · 2017-05-23 12:29:09Z

2

The better solution might be to add a

header('Content-Type: application/json');

at the PHP side, specifying the data type of the response. This way jQuery will automatically know to parse the response into an object without need to specify dataType: "json" from the client side.

edited May 23, 2017 at 12:29

CommunityBot

11 silver badge

answered Mar 13, 2012 at 7:50

Jon

439k85 gold badges756 silver badges820 bronze badges

Collectives™ on Stack Overflow

JSON encoded data from PHP, doesn't display right when callback from jQuery

2 Answers 2

2 Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Linked

Related