MySQL Database Access Using PHP!
Create an xhtml form that allows you to make SQL queries to the MySQL database you created in assignment #3.
The xhtml form must include in input field for entering your SQL queries. Pressing a button on your xhtml form with send the query and make an AJAX request to run a PHP program. This PHP program will connect to the database, make the SQL query and return the query results to be displayed in the existing xhtml form.
Grading: This program is worth 75 pts.
You will be graded on the visual quality of both the input form and the query results, so make them look nice.
60pts. - fulfills assignment requirements.
15pts. - style/elegance/visual appearance
:Place your HTML file in a file named assign04.html and your PHP program in a file named assign04.php. Both
should be placed in your public_html directory.
Test your PHP script by accessing your assign04.html file located in your public_html directory as follows:
Note: DO NOT include the standard first line of a xhtml document <?xml version = "1.0 encoding = "utf-8"?> in your php program. Our php processor gets a parse error when trying to parse your php.
Warning: Once this assignment is complete be sure to activate the assignment #4 link in your home page.