PHP returns JSON object to jQuery ajax call.. what now?

Question

I have been reading over a lot of questions, but cant seem to find my particular problem I have a PHP script that returns a fetch array and I encode that to JSON. I have no headers in my PHP script (I read something about that but haven't got a clue)

The PHP

if (mysql_num_rows($pquery) == 1) {
   $result = mysql_fetch_assoc($pquery);
   echo json_encode($result);

}

The jQuery

$('#c_search').submit(function(){
       data = ($(this).serialize());

  $.ajax({
      url: 'actions/get_company.php',
      type: 'POST',
      data: data,
      cache: false,
      success: function(text){
          alert (text);
          alert(text[1]); // not right!
          alert(text.company[0]);// not right!
      }

}).error(function(){
    alert('error');
})
return false;

})

The text I get back:

{"id":"167","company":"ZEN","street":"1 S Congress Ave","email":"[email protected]","state":"TX","zip":"78704","phone":"512-555-1212"}

How do I handle this properly so I can place each individual piece into its own variable.

Got it pegged! Thank you all... will check in 6 minutes when stack allows. — Daniel Hunter
– Daniel Hunter, Commented Jan 25, 2012 at 18:30

James M · Accepted Answer · 2012-01-25 18:22:54Z

3

You can use dataType to have jQuery parse the response as JSON:

$.ajax({
    url: 'actions/get_company.php',
    dataType: 'json',

    [..]

data will then be a normal Javascript Object, so you can access the fields as normal:

 alert (data.street);

answered Jan 25, 2012 at 18:22

James M

16.7k3 gold badges50 silver badges57 bronze badges

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

Comments

Darin Dimitrov · Accepted Answer · 2012-01-25 18:24:11Z

2

data: data,
cache: false,
dataType: 'json', // <!-- indicate that the response type is JSON => not necessary if your PHP script correctly sets the Content-Type: application/json response header
success: function(text) {
    alert(text.id);
    alert(text.company);
    alert(text.street);
    alert(text.email);
    ...      
}

answered Jan 25, 2012 at 18:24

Darin Dimitrov

1.0m275 gold badges3.3k silver badges3k bronze badges

1 Comment

Daniel Hunter Over a year ago

all of these answers pointed me in the right direction, as i went down the line this is the one the made simple sense and worked first. Thanks all.. up votes.

mowwwalker · Accepted Answer · 2012-01-25 18:24:48Z

2

You can use JSON.parse()

$('#c_search').submit(function(){
       data = ($(this).serialize());

  $.ajax({
      url: 'actions/get_company.php',
      type: 'POST',
      data: data,
      cache: false,
      success: function(text){
          var obj = JSON.parse(text);
          alert (text);
          alert(text[1]); // not right!
          alert(text.company[0]);// not right!
      }

}).error(function(){
    alert('error');
})
return false;

})

answered Jan 25, 2012 at 18:24

mowwwalker

17.5k30 gold badges109 silver badges166 bronze badges

Comments

JS Mitrah · Accepted Answer · 2012-01-25 18:25:48Z

2

Try with datatype : JSON or Use $.getJSON instead of $.ajax.

answered Jan 25, 2012 at 18:25

JS Mitrah

6866 silver badges12 bronze badges

Comments

Rafay · Accepted Answer · 2012-01-25 18:30:43Z

1

set the dataType to json so that the json is parsed for you like

$.ajax({
dataType:'json',
});

or you can parse the json manualy by

$.ajax({
dataType:'json',
success:function(json){
     var parsedJSON = $.parseJSON(json);
 },
});

DEMO

edited Jan 25, 2012 at 18:30

answered Jan 25, 2012 at 18:25

Rafay

31.1k5 gold badges71 silver badges106 bronze badges

Collectives™ on Stack Overflow

PHP returns JSON object to jQuery ajax call.. what now?

5 Answers 5

Comments

1 Comment

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

1 Comment

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related