How to use JSON with Jquery?

Question

I'm working at an app which would make a POST ajax request to a PHP script on my server. The script would query the database and return a row of records, as an array. (One array for each row, containing elements such as id, title, etc). I then want to use json_encode() to encode this array, and pass it back to the javascript which will use it to display the records.

1) How can I return the JSON encoded string to the javascript? 2) How will the javascript loop through the rows and access their fields?

Mkkt Bkkt · Accepted Answer · 2009-02-05 12:27:29Z

12

To get JSON with jQuery, just use jQuery.getJSON(). Alternatively, you can use any other AJAX tool and then just eval() the json to get a javascript object.

To loop through an array, I usually use jQuery.each():

var recordList = yourMethodToGetRecordListWithAjax();

jQuery.each(recordList, function()
{
    alert(this.Name); // For example
});

answered Feb 5, 2009 at 12:27

Mkkt Bkkt

122k40 gold badges154 silver badges177 bronze badges

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

7 Comments

Ali Over a year ago

There's a small typo in your answer, jquery.each should be $.each. Other than that it works good :)

Ali Over a year ago

Here's my code: $.getJSON("getData.php",data,myFunctionToLoopThroughResults);

Mkkt Bkkt Over a year ago

$ is a shortcut for jQuery - I prefer to write jQuery for "static" things like each() and use $ for "non-static" things like queries as I believe it enhances readability.

Mkkt Bkkt Over a year ago

But it's really up to you and your personal taste.

Ali Over a year ago

I tried using jquery but it gave me an error in firebug, so I dunno

|

Mickael Lherminez · Accepted Answer · 2019-12-20 11:50:36Z

4

1) in the php script:

$return["foo"]  = "bar";
$return["blah"] = "bleg";
print json_encode($return);

2) in the javascript:

$.ajax({
  type: "POST",
  url: URL,
  cache: false,
  data: values,
  dataType: 'json',
  success: function(json) {
    var foo = json.foo;
    if (json.blah == "bleg") {
      // do stuff 
    }
  } // end success function
}); // end ajax call

edited Dec 20, 2019 at 11:50

Mickael Lherminez

6951 gold badge11 silver badges30 bronze badges

answered Feb 6, 2009 at 19:41

Lance Kidwell

9051 gold badge15 silver badges18 bronze badges

Comments

kylebrooks · Accepted Answer · 2009-02-05 12:29:18Z

0

You can return the JSON encoded string to the JS by echoing it with a Content-Type of application/json.

See above answer for the rest.

answered Feb 5, 2009 at 12:29

kylebrooks

4432 silver badges5 bronze badges

Collectives™ on Stack Overflow

How to use JSON with Jquery?

3 Answers 3

7 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

7 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related