Oracle Database Express Edition 2 Day Plus PHP Developer Guide

Introducing PHP with Oracle Database Zend Core for Oracle, Getting Connected, Querying Dat, Updating Data Building the Basic Employees page, Executing Stored Procedures and Functions, Loading Images

More PDF Content

Oracle Database Express Edition 2 Day Plus PHP Developer Guide
1 Introducing PHP with Oracle Database Zend Core for Oracle … 1-1
Purpose … 1-1
Overview of the Sample Application … 1-1
Resources … 1-3
2 Getting Started
What You Need … 2-1
Installing Oracle Database … 2-1
Unlocking the HR User … 2-2
Installing Apache HTTP Server … 2-2
Testing the Apache Installation on Windows… 2-2
Testing the Apache Installation on Linux… 2-3
Installing Zend Core for Oracle … 2-5
Installing Zend Core for Oracle on Windows… 2-5
Installing Zend Core for Oracle on Linux … 2-11
Configuring Zend Core for Oracle … 2-20
Testing the Zend Core for Oracle Installation … 2-21
3 Getting Connected
Building the Departments Page … 3-1
Connecting to the Database … 3-4
If You Have Connection Problems … 3-6
Other Ways to Connect … 3-6
Disconnecting from the Database … 3-7
4 Querying Data
Centralizing the Database Application Logic … 4-1
iv Writing Queries with Bind Variables … 4-5
Navigating Through Database Records … 4-7
ROWNUM vs ROW_NUMBER() … 4-11
Extending the Basic Departments Page … 4-11
5 Updating Data Building the Basic Employees page … 5-1
Extending the Basic Employees Page … 5-3
Combining Departments and Employees … 5-13
Adding Error Recovery … 5-17
Further Error Handling … 5-25
6 Executing Stored Procedures and Functions
Using PL/SQL to Capture Business Logic … 6-1
Using PL/SQL Ref Cursors to Return Result Sets … 6-4
7 Loading Images
Using BLOBs to Store and Load Employee Images … 7-1
Resizing Images … 7-8 8
Building Global Applications Establishing the Environment Between Oracle and PHP … 8-1
Manipulating Strings … 8-2
Determining the Locale of the User … 8-2
Developing Locale Awareness … 8-3
Encoding HTML Pages … 8-4
Specifying the Page Encoding for HTML Pages … 8-4
Specifying the Page Encoding in PHP … 8-4
Organizing the Content of HTML Pages for Translation … 8-5
Strings in PHP … 8-5
Static Files … 8-5
Data from the Database … 8-5
Presenting Data Using Conventions Expected by the User … 8-5
Oracle Date Formats … 8-6
Oracle Number Formats… 8-6
Oracle Linguistic Sorts… 8-7
Oracle Error Messages… 8-8

Download Oracle Database Express Edition 2 Day Plus PHP Developer Guide pdf from download.oracle.com, 116 pages, 2484.19KB.