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.