Oracle B25-317-01 Instrukcja Użytkownika Strona 1

Oracle Database Express Edition®2 Day Plus PHP Developer Guide 10g Release 2 (10.2) B25317-01September 2005

Resources1-4 Oracle Database Express Edition 2 Day Plus PHP Developer Guide Beta Draft

Beta Draft Getting Started 2-12Getting StartedThis chapter explains how to install and test

Testing the Oracle Database XE Installation2-2 Oracle Database Express Edition 2 Day Plus PHP Developer Guide Beta Drafthttp://www

Testing the Apache InstallationBeta Draft Getting Started 2-3Testing the Apache Installation1. Start your web brow

Setting Up Zend Core for Oracle2-4 Oracle Database Express Edition 2 Day Plus PHP Developer Guide Beta Draft # the following li

Setting Up Zend Core for OracleBeta Draft Getting Started 2-5Installing Zend Core for Oracle on Linux1. To extract

Setting Up Zend Core for Oracle2-6 Oracle Database Express Edition 2 Day Plus PHP Developer Guide Beta Draft8.When prompted to &qu

Testing the Zend Core for Oracle InstallationBeta Draft Getting Started 2-74.In the PHP tab page, which is selecte

Testing the Zend Core for Oracle Installation2-8 Oracle Database Express Edition 2 Day Plus PHP Developer Guide Beta Draft

Beta Draft Getting Connected 3-13Getting ConnectedIn this chapter you create HR application

Oracle Database Express Edition 2 Day Plus PHP Developer Guide, 10g Release 2 (10.2) B25317-01Copyright © 2005 Oracle. All rights reserved.Contribut

Building the Departments Page3-2 Oracle Database Express Edition 2 Day Plus PHP Developer Guide Beta Draft $title = htmlentities(

Building the Departments PageBeta Draft Getting Connected 3-3{ border-bottom: solid #334B66 4px; font-size: 160%;

Connecting to the Database3-4 Oracle Database Express Edition 2 Day Plus PHP Developer Guide Beta DraftConnecting to the Database1

Connecting to the DatabaseBeta Draft Getting Connected 3-5The oci_parse() function prepares the query for executio

Disconnecting from the Database3-6 Oracle Database Express Edition 2 Day Plus PHP Developer Guide Beta Draftopen simultaneously. T

Beta Draft Querying Data 4-14Querying DataIn this chapter you extend the Anyco HR applicati

Centralizing the Database Application Logic4-2 Oracle Database Express Edition 2 Day Plus PHP Developer Guide Beta Draftfunction d

Centralizing the Database Application LogicBeta Draft Querying Data 4-3Q The null in the fourth parameter for the

Writing Queries with Bind Variables4-4 Oracle Database Express Edition 2 Day Plus PHP Developer Guide Beta Draft }}Remember the E

Writing Queries with Bind VariablesBeta Draft Querying Data 4-5 FROM departments WHERE department_id =

Beta Draft iii Contents Preface...

Navigating Through Database Records4-6 Oracle Database Express Edition 2 Day Plus PHP Developer Guide Beta Draft if (!$stid) {

Navigating Through Database RecordsBeta Draft Querying Data 4-7Q Detecting if the HTTP request for the page was po

Navigating Through Database Records4-8 Oracle Database Express Edition 2 Day Plus PHP Developer Guide Beta Draft isset($_POST

Navigating Through Database RecordsBeta Draft Querying Data 4-9$posturl parameter to set the HTML form's acti

Extending the Basic Departments Form4-10 Oracle Database Express Edition 2 Day Plus PHP Developer Guide Beta Draft5.To navigate to

Extending the Basic Departments FormBeta Draft Querying Data 4-11The additional information is obtained by modifyi

Building the Basic Employee Form4-12 Oracle Database Express Edition 2 Day Plus PHP Developer Guide Beta Draft AND l.country_id

Building the Basic Employee FormBeta Draft Querying Data 4-13require('anyco_ui.inc');session_start();con

Building the Basic Employee Form4-14 Oracle Database Express Edition 2 Day Plus PHP Developer Guide Beta Draft

Beta Draft Updating Data 5-15Updating DataIn this chapter you extend the Anyco HR applicati

iv Beta DraftExtending the Basic Departments Form...

Extending the Basic Employee Form5-2 Oracle Database Express Edition 2 Day Plus PHP Developer Guide Beta Draftelse { construct_em

Extending the Basic Employee FormBeta Draft Updating Data 5-3function construct_employees(){ $query = "SELE

Extending the Basic Employee Form5-4 Oracle Database Express Edition 2 Day Plus PHP Developer Guide Beta Draft FROM employee

Extending the Basic Employee FormBeta Draft Updating Data 5-5OCI_FETCHSTATEMENT_BY_ROW, in the oci_fetch_all() cal

Extending the Basic Employee Form5-6 Oracle Database Express Edition 2 Day Plus PHP Developer Guide Beta Draft echo '<p

Extending the Basic Employee FormBeta Draft Updating Data 5-7 <td>Department ID</td> <td&

Extending the Basic Employee Form5-8 Oracle Database Express Edition 2 Day Plus PHP Developer Guide Beta Draft $lnm = htmlentit

Extending the Basic Employee FormBeta Draft Updating Data 5-9Scroll to the bottom of the Employees page to view th

Extending the Basic Employee Form5-10 Oracle Database Express Edition 2 Day Plus PHP Developer Guide Beta DraftClick Save.18. When

Combining Departments and EmployeesBeta Draft Updating Data 5-1121.Successfully updating the employee causes the E

Beta Draft v PrefaceThe Oracle Database Express Edition 2 Day Plus PHP Dev

Combining Departments and Employees5-12 Oracle Database Express Edition 2 Day Plus PHP Developer Guide Beta Draft subst

Combining Departments and EmployeesBeta Draft Updating Data 5-13 function construct_insert_emp() { $deptid

Adding Error Recovery5-14 Oracle Database Express Edition 2 Day Plus PHP Developer Guide Beta Draft <input type="submit

Adding Error RecoveryBeta Draft Updating Data 5-15Most production systems would display_errors configuration optio

Adding Error Recovery5-16 Oracle Database Express Edition 2 Day Plus PHP Developer Guide Beta Draft $bind

Adding Error RecoveryBeta Draft Updating Data 5-17 AND l.country_id = c.country_id GROUP BY

Adding Error Recovery5-18 Oracle Database Express Edition 2 Day Plus PHP Developer Guide Beta Draft array_push($bindargs, a

Adding Error RecoveryBeta Draft Updating Data 5-19 handle_error('Connect Error', $err); }

Adding Error Recovery5-20 Oracle Database Express Edition 2 Day Plus PHP Developer Guide Beta Draft } } }13. Edit a

Adding Error RecoveryBeta Draft Updating Data 5-21 handle_error("Error deleting employee $empid&qu

vi Beta DraftAccessibility of Links to External Web Sites in DocumentationThis documen

Further Error Handling5-22 Oracle Database Express Edition 2 Day Plus PHP Developer Guide Beta Draft18.Click Next> to navigate

Further Error HandlingBeta Draft Updating Data 5-234.In the Employees page, click Insert new employee.5. In the In

Further Error Handling5-24 Oracle Database Express Edition 2 Day Plus PHP Developer Guide Beta Draft

Beta Draft Executing Stored Procedures and Functions 6-16Executing Stored Procedures and Fu

Using PL/SQL to Capture Business Logic6-2 Oracle Database Express Edition 2 Day Plus PHP Developer Guide Beta Draft4.In the SQL Co

Using PL/SQL to Capture Business LogicBeta Draft Executing Stored Procedures and Functions 6-37.In the Oracle Data

Using PL/SQL to Capture Business Logic6-4 Oracle Database Express Edition 2 Day Plus PHP Developer Guide Beta DraftIn the results

Using PL/SQL Ref Cursors to Return Result SetsBeta Draft Executing Stored Procedures and Functions 6-5 </tr&g

Using PL/SQL Ref Cursors to Return Result Sets6-6 Oracle Database Express Edition 2 Day Plus PHP Developer Guide Beta Draft1.In th

Using PL/SQL Ref Cursors to Return Result SetsBeta Draft Executing Stored Procedures and Functions 6-7In the Resul

Beta Draft Introducing PHP with Oracle Database XE 1-11Introducing PHP with Oracle Database

Using PL/SQL Ref Cursors to Return Result Sets6-8 Oracle Database Express Edition 2 Day Plus PHP Developer Guide Beta Draft i

Using PL/SQL Ref Cursors to Return Result SetsBeta Draft Executing Stored Procedures and Functions 6-97.In the Mar

Using PL/SQL Ref Cursors to Return Result Sets6-10 Oracle Database Express Edition 2 Day Plus PHP Developer Guide Beta Draft

Beta Draft Loading Images 7-17Loading ImagesThis chapter shows you how to change the applic

Using Oracle LOBs to Store and Load Employee Images7-2 Oracle Database Express Edition 2 Day Plus PHP Developer Guide Beta Draft5.

Using Oracle LOBs to Store and Load Employee ImagesBeta Draft Loading Images 7-3 <th>Commission<br>

Using Oracle LOBs to Store and Load Employee Images7-4 Oracle Database Express Edition 2 Day Plus PHP Developer Guide Beta Draft

Using Oracle LOBs to Store and Load Employee ImagesBeta Draft Loading Images 7-5 if (!$r) { $e = db_er

Using Oracle LOBs to Store and Load Employee Images7-6 Oracle Database Express Edition 2 Day Plus PHP Developer Guide Beta Draft14

Using Oracle LOBs to Store and Load Employee ImagesBeta Draft Loading Images 7-719.In the File Upload window, brow

Overview of the Sample Application1-2 Oracle Database Express Edition 2 Day Plus PHP Developer Guide Beta Draft6.Uploads and displ

Resizing Images7-8 Oracle Database Express Edition 2 Day Plus PHP Developer Guide Beta DraftOn success, the Employees page is disp

Resizing ImagesBeta Draft Loading Images 7-95.In the Extension sub-tab page, expand the Zend Core Extensions tree

Resizing Images7-10 Oracle Database Express Edition 2 Day Plus PHP Developer Guide Beta Draft12.In the Employees page, to insert a

Resizing ImagesBeta Draft Loading Images 7-1115.In the Insert New Image page, click Save:The Employees page shows

Resizing Images7-12 Oracle Database Express Edition 2 Day Plus PHP Developer Guide Beta Draft

Beta Draft Building Global Applications 8-18Building Global ApplicationsThis chapter discus

String Manipulation8-2 Oracle Database Express Edition 2 Day Plus PHP Developer Guide Beta DraftThe language and territory setting

Developing Locale AwarenessBeta Draft Building Global Applications 8-3Determining User's LocaleIn a global en

Encoding HTML Pages8-4 Oracle Database Express Edition 2 Day Plus PHP Developer Guide Beta DraftEncoding HTML PagesThe encoding of

Presenting Data following User's Locale ConventionBeta Draft Building Global Applications 8-5This setting doe

ResourcesBeta Draft Introducing PHP with Oracle Database XE 1-3The code for each chapter builds on the files compl

Presenting Data following User's Locale Convention8-6 Oracle Database Express Edition 2 Day Plus PHP Developer Guide Beta Dra

Presenting Data following User's Locale ConventionBeta Draft Building Global Applications 8-7 EMPID EmpNa

Presenting Data following User's Locale Convention8-8 Oracle Database Express Edition 2 Day Plus PHP Developer Guide Beta Dra

Beta Draft Index-1 IndexSymbols$HOME/public_html, 1-3AAnyCo Corptutorial application,

Index-2 Beta Draftprerequisites, 2-1testing availability, 2-2PPHP, 1-1creating fil