Oracle® Database Express Edition 2 Day Plus PHP Developer Guide 10g Release 2 (10.2) Part Number B25317-01 |
|
|
View PDF |
PHP is a popular scripting language that can be embedded in HTML, which makes it particularly useful for Web development. Zend Core for Oracle enables application development using PHP.
Oracle Database Express Edition (Oracle Database XE) is a free relational database that you can use to store, use, and modify data.
This chapter has the following topics:
Zend Core for Oracle, developed in partnership with Zend Technologies, provides a stable, high performance, easy-to-install, and supported PHP development and production environment that is fully integrated with Oracle Database Express Edition.
This guide is a tutorial that shows you how to use Zend Core for Oracle to connect to Oracle Database XE, and demonstrates how to use PHP to access and modify data.
This document guides you through the development of a simple Human Resources (HR) application for a fictitious company called AnyCo Corp.
The application manages departmental and employee information stored in the DEPARTMENTS
and EMPLOYEES
tables in the HR schema provided with Oracle Database XE. See Oracle Database Sample Schemas for information about this schema.
The complete sample application:
Establishes a connection to the database using the PHP OCI8 extension
Queries the database for department and employee data
Displays and navigates through the data
Shows how to insert, update, and delete employee records
Handles data exceptions
Uploads and displays employee photographs
Figure 1-1 shows the relationship between the files developed for this application.
Figure 1-1 Functionality in the Sample PHP Application
The sample application files are:
anyco_cn.inc
, anyco_db.inc
, and anyco_ui.inc
is used by it.Files with the suffix .inc
are PHP code files included in other PHP files.
Files with the suffix .php
can be loaded in a browser.
You can create and edit the PHP application source files in a text editor or any tool that supports PHP development.
The code for each chapter builds on the files completed in the previous chapter.
The following Oracle Technology Network Web sites provide additional information you may find useful.
PHP Developer Center at
Zend Core for Oracle Developer Center at
http://www.oracle.com/technology/tech/php/zendcore/index.html
Oracle Database Express Edition documentation at
The Oracle Database Documentation Library at