Creating an Application Using PHP

















The interactions in this eCourse require Javascript to be enabled.






 

Creating an Application Using PHP


previous|next





Sheila's team is requested to create a Web application for the human resources (HR) information in the database tables. The company HR representatives would like to query departmental and employee information.
Sheila's team decides to provide this functionality by using PHP running on a Web server. The PHP application needs to access Oracle Database 10g Release 2 Express Edition to obtain the data.
You learn how to help Sheila install and configure the environment for PHP applications by performing the following tasks:




Test if the default Apache Web Server is running, and start it if required.



Configure the Apache Web server to enable user directories.



Install Zend Core for Oracle, which provides a PHP engine to execute PHP code.



Configure Zend Core for Oracle to enable verbose display of error messages during development of the PHP application.



You learn to create a PHP application that:




Connects to an Oracle database



Queries the DEPARMENTS and EMPLOYEES tables



Displays the queried database data in HTML table format



 
The PHP application comprises the following files:




hr.php, which contains the PHP application control logic



hr_cn.inc, an include file that defines database connection properties



hr_ui.inc, an include file containing user interface functions



hr_db.inc, an include file containing database access logic



Note: The PHP files can be accessed by a browser. The include (.inc) files are needed by the PHP file and are not intended to be accessed from a browser.
Note: The .php files can be accessed by a browser. The include (.inc) files are needed by the PHP file and not intended to be accessed from a browser.
If you are using Oracle JDeveloper 10g (10.1.2, or 9.0.5.2), you can download the PHP extension from Extensions Exchange on the Oracle Technology Network (OTN) to enable development of PHP applications in Oracle JDeveloper.