AJAX Database

AJAX can be used for interactive communication with a database. The following example will demonstrate how a web page can fetch information from a database with AJAX:
Book information will be listed here...
The MySQL Database
The database table creation and population are given as follows: 

CREATE TABLE bookList (
  ISBN      CHAR(16) PRIMARY KEY,
  title     VARCHAR(64) NOT NULL,
  authors   VARCHAR(64),
  price     REAL,
  quantity  INTEGER );

INSERT INTO bookList VALUES ( 
  '0596005601', 'Learning PHP 5', 'David Sklar', 19.77, 32 );
INSERT INTO bookList VALUES (
  '0596003064', 'High Performance MySQL', 'Jeremy D. Zawodny', 26.37, 221 );
   ...

The HTML Form
This AJAX contains an HTML form and a link to a JavaScript file. When a user selects a book in the dropdown list above, a function called showBook is executed. The function is triggered by the onChange event: 

<html>
 <head><script src="ShowBook.js"></script></head>
 <body><form action="">
  <select name="books" onChange="showBook(this.value)">
   <option value="">Select a book:</option>
   <option value="0596528388">AJAX</option>
   <option value="1118008189">HTML</option>
   ...
  </select></form>
  <div id="txtHint">Book information will be listed here...</div>
 </body>
</html>




      Before you marry a person you should first make them use    
      a computer with slow internet to see who they really are.    
      — Will Ferrell