How to load data using JSON/PHP using jQuery
I have seen a good amount of people wanting to see learn how to load data on their website using jQuery, JSON, and PHP. I thought I would show a simple example that should give you a jump start to your project.
We are going to use $.getJSON() function, you have something like:
$.getJSON("readJSON.php",function(data){
$.each(data.posts, function(i,post){
content = '
\n';
content += '
' + post.author + '
\n';
content += '+ post.date_added + '\n';
content += '' + post.post_content + ';
content += ''
';
$("#contents").append(content).fadeIn("slow");
});
});
And example of JSON from the PHP page could look like:
{ posts: [{"id":"151","date_added":"2009-05-05 13:40:34","post_content":"This is a test post. jQuery!","author":"Ryan"},
{"id":"152","date_added":"2009-05-05 13:40:55","post_content":"Hey, you got to love Ajax","author":"John"}] }
That JSON above loads two records that will be displayed on to the page.
The results are being pulled from a MySQL database with tables: id, author, post_content, date_added, and author.
I am going to wrap up and article on the jQuery/PHP/JSON comment form with the results loaded on to the page after form submission, stay tuned for a much more in depth explanation of using JSON with PHP and jQuery.
other related posts...
- Use jQuery To Submit Form To PHP/MySQL
- How to use jQuery to Serialize Ajax Forms
- Time for another iGoogle theme?
- Create a jQuery Accordion – remain open after page load
- jQuery Search And Highlight
Take a peak at some more?

Could you please post a simple full example? that would be very helpful to all who are all new to JSON
Where is the PHP code?
what about example php code ?
Check out the code here: http://pastie.org/575889
Hey Alan, you can find it here: http://pastie.org/575889 – I have been really busy and am going to write some updates to this post along with validation and other functions.