Go to main content
1/12
Contents
Title and Copyright Information
Preface
Audience
Documentation Accessibility
Related Documents
Conventions
1
Introducing PHP with Oracle Database
Purpose
Overview of the Sample Application
Resources
2
Getting Started
What You Need
Installing Oracle Database
Unlocking the HR User
Installing Apache HTTP Server
Installing Apache on Windows
Starting and Stopping Apache on Windows
Testing the Apache Installation on Windows
Installing Apache on Linux
Starting and Stopping Apache on Linux
Testing the Apache Installation on Linux
Installing PHP
Installing PHP on Windows
Installing PHP on Linux
Testing the PHP Installation
3
Getting Connected
Building the Departments Page
Connecting to the Database
If You Have Connection Problems
Other Ways to Connect
Disconnecting from the Database
4
Querying Data
Centralizing the Database Application Logic
Writing Queries with Bind Variables
Navigating Through Database Records
ROWNUM vs ROW_NUMBER()
Extending the Basic Departments Page
5
Updating Data
Building the Basic Employees page
Extending the Basic Employees Page
Combining Departments and Employees
Adding Error Recovery
Further Error Handling
6
Executing Stored Procedures and Functions
Using PL/SQL to Capture Business Logic
Using PL/SQL Ref Cursors to Return Result Sets
7
Loading Images
Using BLOBs to Store and Load Employee Images
Resizing Images
8
Building Global Applications
Establishing the Environment Between Oracle and PHP
Manipulating Strings
Determining the Locale of the User
Developing Locale Awareness
Encoding HTML Pages
Specifying the Page Encoding for HTML Pages
Specifying the Page Encoding in PHP
Organizing the Content of HTML Pages for Translation
Strings in PHP
Static Files
Data from the Database
Presenting Data Using Conventions Expected by the User
Oracle Date Formats
Oracle Number Formats
Oracle Linguistic Sorts
Oracle Error Messages
Index
Scripting on this page enhances content navigation, but does not change the content in any way.