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.
Wyszukiwarka
Podobne podstrony:
les09 create? logic tmles09 create? conn prop tmles09 run php app smapp createdbles09 hr phpapp createuserphp 2create?tor report^E0EC2Ccreate branchsql createtableles09 page handling tmBiblioteka PHP Wysyłanie pliku na serwerk phpDelphi i PHPphp 2php 3PHP i Oracle Tworzenie aplikacji webowych od przetwarzania danych po Ajaksawięcej podobnych podstron