04

MySQL Database Access Using PHP!
75 points
 Purpose:  Create a 3-tier web application using your web brower, PHP, and MYSQL database. 

 

Description:

 

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.