Join 5700+ of your peers
Get enriched. Access 1270+ quality tutorials right away on:
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.
The tutorials at have been written by by passionate teachers who have been using open source tools and technologies for years.
Real time images of their development screens are generously used throughout each tutorial.
Download the tutorials to your desktop as PDFs for ready reference whenever you need
Give us your comments or feedback on any of our tutorials.
Your comments help us deliver the best possible training modules.
Is there a specific tutorial you want written? Just Ask.