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