User's Manual

Beta Draft Introducing PHP with Oracle Database XE 1-1

Introducing PHP with Oracle Database XE

Oracle® Database Express Edition (Oracle Database XE) is a relational database that

you can use to store, use, and modify data. Zend Core for Oracle enables application

development using PHP.

This chapter has the following topics:

Q Zend Core for Oracle

Q Purpose

Q Overview of the Sample Application

Q Resources

Zend Core for Oracle

Zend Core for Oracle, developed in partnership with Zend Technologies provides a

seamless out-of-the-box experience delivering a stable, high performance,

easy-to-install and supported PHP development and production environment fully

integrated with Oracle Database Express Edition.

Purpose

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.

Overview of the Sample Application

This document guides you through the development of a simple Human Resources

(HR) application for a fictitious company ""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.

The complete sample application:

1. Establishes a connection to the database using PHP's OCI8 extension

2. Queries the database for department and employee data

3. Displays and navigates through the data

4. Shows how to insert, update, anddelete employee records

5. Handles data exceptions