Task:
Our main focus for this project is to establish communication between your PHP program and the Oracle database. Following the class notes, we are modifying the OracleStandardConnection.php to define the connection parameters in a separate file (oracle_parameters.php).
Your tasks are to modify/write the above two (2) PHP files and to demonstrate a successful connection between PHP program and Oracle database.
PHP Program Requirements:
You are required to develop two (2) PHP files as follows:
- oracle_parameters.php (30 points)
The file should be named as specified above. Exact spelling is required.
In the above file, you are required to define the following parameters according to your own Oracel settings in your computer:
$schema //The user name should be "php".
$password //The password will be "php".
$database //The $database will be defined based upon your computer system.
- OracleStandardConnectionFL.php (20 points)
The file should be named as specified above, where F is your the initial of your first name and L is your last initial. Exact spelling is required.
You are required to modify the OracleStandardConnection.php file that comes with the CD in your textbook. You are going to use the above oracle_parameters.php file, in order to define the three Oracle connection parameters in the PHP script. In other words, whenever Oracle connection is needed in the future, you could just use the same file to define those parameter.
No Oracle connection parameters will be defined directly in OracleStandardConnection.php file.
- Test OracleStandardConnectionFL
.php and make sure to establish the connection successfully. (50 points)
Submission Requirements:
You are required to submit the following files:
- oracle_parameters.php (30 points)
- OracleStandardConnectionFL.php (20 points)
- A Microsoft Word file that provides proof (screen shots) that you have successfully established connection between PHP and Oracle database using the above two files. (50 points)
Standard for File Name: The file naming only applies to the Microsoft Word file. Please name your file as firstname_lastname_project6.doc, where firstname and lastname are your first and last name, respectively, and "_" is underscore. Five (5) points will be taken off if the file is not named according to the convention.
The two PHP files will be named exactly as they are specified above.
Please submit your project on D2L according to the deadline established on the course schedule. |