Retrieving database information with AJAX, PHP and MySQL
Tag it:
Furl it!

Retrieving database information with AJAX, PHP and MySQL - By somecoders

With the recent popularization of AJAX (Asynchronus Javascript And XML), it is now unnessecary to reload a page with the same basic layout, just to get new content. You can use AJAX to retrieve just the content without reloading the page, then change the value of a content area.

First of all, to use AJAX you must understand how it works. AJAX is JavaScript that can run through the "AJAX Engine" and by doing so, retrieve data from a remote page through HTTP, without having a page reload. It is similar to PHP's file_get_contents(), however it can be done through JavaScript as a client-side script.

The first thing we need, is a php file that we will call with AJAX. It doesn't have to be PHP, but since it is the most popular server-side language, that is what we'll use. If you have decent knowledge of another language you would like to use instead, I'm sure you could translate the code. In this file, we will use a GET variable to determine the MySQL query we need to perform. We are using GET because it is accessible by AJAX. The great thing about it is that the file you are calling can be incredibly simple, and just be straight textual information