User's Manual

iv Beta Draft
Extending the Basic Departments Form............................................................................................ 4-10
Building the Basic Employee Form.................................................................................................... 4-12
5 Updating Data
Extending the Basic Employee Form .................................................................................................... 5-1
Combining Departments and Employees ........................................................................................ 5-11
Adding Error Recovery......................................................................................................................... 5-14
Further Error Handling ........................................................................................................................ 5-22
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-5
7 Loading Images
Using Oracle LOBs 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
String Manipulation ................................................................................................................................ 8-2
Determining User's Locale ..................................................................................................................... 8-3
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 following User's Locale Convention ...................................................................... 8-5
Oracle Date Formats .......................................................................................................................... 8-6
Oracle Number Formats.................................................................................................................... 8-6
Oracle Linguistic Sorts....................................................................................................................... 8-7
Oracle Error Messages....................................................................................................................... 8-8
Index