PHP and AJAX MySQL Database Example

AJAX can be used for interactive communication with a database. In the AJAX example below we will demonstrate how a web page can fetch information from a MySQL database using AJAX technology.This example consists of four elements:

1. a MySQL database

2. a simple HTML form

3. a JavaScript

4. a PHP page

The Detail Could be like this below:

Ajax Introduction

PHP and AJAX
There is no such thing as an AJAX server. AJAX is a technology that runs in your browser. It uses asynchronous data transfer (HTTP requests) between the browser and the web server, allowing web pages to request small bits of information from the server instead of whole pages. AJAX is a web browser technology independent of web server software. However, in this tutorial we will focus more on actual examples running on a PHP server, and less on how AJAX works.

AJAX XMLHttpRequest
The XMLHttpRequest object makes AJAX possible.The XMLHttpRequest
The XMLHttpRequest object is the key to AJAX. It has been available ever since Internet Explorer 5.5 was released in July 2000, but not fully discovered before people started to talk about AJAX and Web 2.0 in 2005.