To build an HTML query form, pick up user information, based on this user information pick up information from a MySQL database table and display the information retrieved on the HTML query form webpage without re-loading the webpage.
Information is retrieved up from a MySQL database table named ajaxmysql on click of MySQL Query as shown in diagram 1.
Let’s build a simple HTML query form, based user interface that will capture the Age, Gender and Academics of an individual as displayed in diagram 1.
The codespec that does this is available in phpmysqlinteract.html.Download the codespec of phpmysqlinteract.html.
The codespec that does this is available in ajaxmysql.php. Download the codespec of ajaxmysql.php.
ajaxmysql.php in turn makes a call to the MySQL table ajaxmysql and retrieves appropriate records from within the table based on the data captured by the form.
After the user clicks MySQL Query, the data displayed on the same web page carrying the HTML form is based on the following SQL Select query:
Query: SELECT * FROM ajaxmysql WHERE ae_age <= ‘27’ && ae_gender = ‘male’ && ae_acads = ‘MCOM’
This query is deliberately chosen so that multiple records are returned from the MySQL table ajaxmysql.
When the query result set is written in to the webpage that currently displays the HTML form, it will immediately catch the attention of the viewer.
This web page is not refreshed. This is AJAX at work. The output is as shown in diagram 2.
The codespec that does this is available in ajax.js. Download the codespec of ajax.js.
What keeps you awake at night?
Do let us know.
We will try our best to deliver tutorials that will help you sleep much better.