Este free PDF book é destinado a programadores PHP que desenvolvem aplicações para banco de dados Oracle.
Este book é interessante para:
- Quem está começando a aprender PHP com Oracle;
- Quem é um programador PHP e deseja aprender Oracle;
- Quem está inseguro sobre como instalar o PHP, ou Oracle;
- Quem pretende apenas saber as boas práticas de PHP e Oracle.
Este livro dá-lhe a base fundamental e necessária para criar aplicações web de alta performance com PHP e Oracle.
Veja abaixo todo o conteúdo abordado no livro (conteúdo em inglês):
Chapter 1 Introduction
Who Should Read This Book?
Introduction to Oracle
Databases and Instances
Tablespaces
Schemas and Users
Introduction to PHP
Chapter 2 Getting Started With PHP
Creating and Editing PHP Scripts
PHP Syntax Overview
Running PHP Scripts
Running PHP Scripts in a Browser
Running Scripts with Command Line PHP
Debugging PHP Scripts
Chapter 3 PHP Oracle Extensions
PHP Oracle Extensions
Oracle Extension
OCI8 Extension
PDO Extension
PHP Database Abstraction Libraries
ADOdb
PEAR DB
PEAR MDB2
Getting the OCI8 Extension
OCI8 and Oracle Installation Options
Getting the PDO Extension
Zend Core for Oracle
The PHP Release Cycle
Chapter 4 Installing Oracle Database 10g Express Edition
Oracle Database Editions
Oracle Database XE
Installing Oracle Database XE on Linux
Installing Oracle Database XE on Debian, Ubuntu, and Kubuntu
Installing Oracle Database XE on Windows
Testing the Oracle Database XE Installation
Configuring Oracle Database XE
Setting the Oracle Database XE Environment Variables on Linux
Enabling Database Startup and Shutdown from Menus on Linux
Starting and Stopping the Listener and Database
Enabling Remote Client Connection
Chapter 5 Using Oracle Database
Oracle Application Express
Logging In To Oracle Application Express
Unlocking the HR User
Creating Database Objects
Working with SQL Scripts
Creating a PL/SQL Procedure
Creating a Database User
Monitoring Database Sessions
Database Backup and Recovery
Oracle SQL*Plus
Starting SQL*Plus
Executing SQL and PL/SQL Statements in SQL*Plus
Controlling Query Output in SQL*Plus
Running Scripts in SQL*Plus
Information On Tables in SQL*Plus
Accessing the Demonstration Tables in SQL*Plus
Oracle SQL Developer
Creating a Database Connection
Creating a Table
Executing a SQL Query
Editing, Compiling and Running PL/SQL
Running Reports
Creating Reports
Chapter 6 Installing Apache HTTP Server
Installing Apache HTTP Server on Linux
Starting and Stopping Apache HTTP Server
Configuring Apache HTTP Server on Linux
Installing Apache HTTP Server on Windows
Starting and Stopping Apache HTTP Server
Chapter 7 Installing PHP
Installing PHP with OCI8 on Linux
Installing OCI8 Using a Local Database
Installing OCI8 Using Oracle Instant Client
Upgrading PHP with PECL OCI8 on Linux
Upgrading OCI8 as a Static Library on Linux
Upgrading OCI8 on Linux Using the PECL Channel
Upgrading OCI8 as a Shared Library on Linux
Installing PHP With OCI8 on Windows
Installing OCI8 Using a Local Database on Windows
Installing OCI8 with Instant Client on Windows
Upgrading OCI8 on Windows
Installing OCI8 with Oracle Application Server on Linux
Installing PHP With PDO
Installing PDO on Linux
Installing PDO on Windows
Checking OCI8 and PDO_OCI Installation
Chapter 8 Installing Zend Core for Oracle
Installing Zend Core for Oracle
Installing Zend Core for Oracle on Linux
Testing the Zend Core for Oracle Installation on Linux
Installing Zend Core for Oracle on Windows
Testing the Zend Core for Oracle Installation on Windows
Configuring Zend Core for Oracle
Chapter 9 Connecting to Oracle Using OCI8
Oracle Connection Types
Standard Connections
Multiple Unique Connections
Persistent Connections
Oracle Database Name Connection Identifiers
Easy Connect String
Database Connect Descriptor String
Database Connect Name
Common Connection Errors
Setting Oracle Environment Variables for Apache
Closing Oracle Connections
Close Statement Resources Before Closing Connections
Transactions and Connections
Session State with Persistent Connections
Optional Connection Parameters
Connection Character Set
Connection Session Mode
Changing the Database Password
Changing Passwords On Demand
Changing Expired Passwords
Tuning Oracle Connections in PHP
Use the Best Connection Function
Pass the Character Set
Do Not Set the Date Format Unnecessarily
Managing Persistent Connections
Maximum Number of Persistent Connections Allowed
Timeout for Unused Persistent Connections
Pinging for Closed Persistent Connections
Apache Configuration Parameters
Reducing Database Server Memory Used By Persistent Connections
Oracle Net and PHP
Connection Rate Limiting
Setting Connection Timeouts
Configuring Authentication Methods
Detecting Dead PHP Apache Sessions
Other Oracle Net Optimizations
Tracing Oracle Net
Connection Management in Scalable Systems
Chapter 10 Executing SQL Statements With OCI8
SQL Statement Execution Steps
Query Example
Oracle Datatypes
Fetch Functions
Fetching as a Numeric Array
Fetching as an Associative Array
Fetching as an Object
Defining Output Variables
Fetching and Working with Numbers
Fetching and Working with Dates
Insert, Update, Delete, Create and Drop
Transactions
Autonomous Transactions
The Transactional Behavior of Connections
PHP Error Handling
Handling OCI8 Errors
Tuning SQL Statements in PHP Applications
Using Bind Variables
Tuning the Prefetch Size
Tuning the Statement Cache Size
Using the Server and Client Query Result Caches
Limiting Rows and Creating Paged Datasets
Auto-Increment Columns
Getting the Last Insert ID
Exploring Oracle
Case Insensitive Queries
Analytic Functions in SQL
Chapter 11 Using PL/SQL With OCI8
PL/SQL Overview
Blocks, Procedures, Packages and Triggers
Anonymous Blocks
Stored or Standalone Procedures and Functions
Packages
Triggers
Creating PL/SQL Stored Procedures in PHP
End of Line Terminators in PL/SQL with Windows PHP
Calling PL/SQL Code
Calling PL/SQL Procedures
Calling PL/SQL Functions
Binding Parameters to Procedures and Functions
Array Binding and PL/SQL Bulk Processing
PL/SQL Success With Information Warnings
Using REF CURSORS for Result Sets
Closing Cursors
Converting from REF CURSOR to PIPELINED Results
Oracle Collections in PHP
Using PL/SQL and SQL Object Types in PHP
Using OCI8 Collection Functions
Using a REF CURSOR
Binding an Array
Using a PIPELINED Function
Getting Output with DBMS_OUTPUT
PL/SQL Function Result Cache
Using Oracle Locator for Spatial Mapping
Inserting Locator Data
Queries Returning Scalar Values
Selecting Vertices Using SDO_UTIL.GETVERTICES
Using a Custom Function
Scheduling Background or Long Running Operations
Reusing Procedures Written for MOD_PLSQL
Chapter 12 Using Large Objects in OCI8
Working with LOBs
Inserting and Updating LOBs
Fetching LOBs
Temporary LOBs
LOBs and PL/SQL procedures
Other LOB Methods
Working with BFILEs
Chapter 13 Using XML with Oracle and PHP
Fetching Relational Rows as XML
Fetching Rows as Fully Formed XML
Using the SimpleXML Extension in PHP
Fetching XMLType Columns
Inserting into XMLType Columns
Fetching an XMLType from a PL/SQL Function
XQuery XML Query Language
Accessing Data over HTTP with XML DB
Chapter 14 PHP Scalability and High Availability
Database Resident Connection Pooling
How DRCP Works
PHP OCI8 Connections and DRCP
When to use DRCP
Sharing the Server Pool
Using DRCP in PHP
Configuring and Enabling the Pool
Configuring PHP for DRCP
Application Deployment for DRCP
Monitoring DRCP
V$PROCESS and V$SESSION Views
DBA_CPOOL_INFO View
V$CPOOL_STATS View
V$CPOOL_CC_STATS View
High Availability with FAN and RAC
Configuring FAN Events in the Database
Configuring PHP for FAN
Application Deployment for FAN
RAC Connection Load Balancing with PHP
Chapter 15 Globalization
Establishing the Environment Between Oracle and PHP
Manipulating Strings
Determining the Locale of the User
Encoding HTML Pages
Specifying the Page Encoding for HTML Pages
Specifying the Encoding in the HTTP Header
Specifying the Encoding in the HTML Page Header
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 Number Formats
Oracle Date Formats
Oracle Linguistic Sorts
Oracle Error Messages
Chapter 16 Testing PHP and the OCI8 Extension
Running OCI8 Tests
Running a Single Test
Tests that Fail
Creating OCI8 Tests
OCI8 Test Helper Scripts
Configuring the Database For Testing
Appendix A Tracing OCI8 Internals
Enabling OCI8 Debugging output
Appendix B OCI8 php.ini Parameters
Appendix C OCI8 Function Names in PHP 4 and PHP 5
Appendix D The Obsolete Oracle Extension
Oracle and OCI8 Comparison
Appendix E Resources
General Information and Forums
Oracle Documentation
Selected PHP and Oracle Books
Software and Source Code
PHP Links
Glossary
Baixe o Book Aqui: Download
Até a próxima
:-)
Este book é interessante para:
- Quem está começando a aprender PHP com Oracle;
- Quem é um programador PHP e deseja aprender Oracle;
- Quem está inseguro sobre como instalar o PHP, ou Oracle;
- Quem pretende apenas saber as boas práticas de PHP e Oracle.
Este livro dá-lhe a base fundamental e necessária para criar aplicações web de alta performance com PHP e Oracle.
Veja abaixo todo o conteúdo abordado no livro (conteúdo em inglês):
Chapter 1 Introduction
Who Should Read This Book?
Introduction to Oracle
Databases and Instances
Tablespaces
Schemas and Users
Introduction to PHP
Chapter 2 Getting Started With PHP
Creating and Editing PHP Scripts
PHP Syntax Overview
Running PHP Scripts
Running PHP Scripts in a Browser
Running Scripts with Command Line PHP
Debugging PHP Scripts
Chapter 3 PHP Oracle Extensions
PHP Oracle Extensions
Oracle Extension
OCI8 Extension
PDO Extension
PHP Database Abstraction Libraries
ADOdb
PEAR DB
PEAR MDB2
Getting the OCI8 Extension
OCI8 and Oracle Installation Options
Getting the PDO Extension
Zend Core for Oracle
The PHP Release Cycle
Chapter 4 Installing Oracle Database 10g Express Edition
Oracle Database Editions
Oracle Database XE
Installing Oracle Database XE on Linux
Installing Oracle Database XE on Debian, Ubuntu, and Kubuntu
Installing Oracle Database XE on Windows
Testing the Oracle Database XE Installation
Configuring Oracle Database XE
Setting the Oracle Database XE Environment Variables on Linux
Enabling Database Startup and Shutdown from Menus on Linux
Starting and Stopping the Listener and Database
Enabling Remote Client Connection
Chapter 5 Using Oracle Database
Oracle Application Express
Logging In To Oracle Application Express
Unlocking the HR User
Creating Database Objects
Working with SQL Scripts
Creating a PL/SQL Procedure
Creating a Database User
Monitoring Database Sessions
Database Backup and Recovery
Oracle SQL*Plus
Starting SQL*Plus
Executing SQL and PL/SQL Statements in SQL*Plus
Controlling Query Output in SQL*Plus
Running Scripts in SQL*Plus
Information On Tables in SQL*Plus
Accessing the Demonstration Tables in SQL*Plus
Oracle SQL Developer
Creating a Database Connection
Creating a Table
Executing a SQL Query
Editing, Compiling and Running PL/SQL
Running Reports
Creating Reports
Chapter 6 Installing Apache HTTP Server
Installing Apache HTTP Server on Linux
Starting and Stopping Apache HTTP Server
Configuring Apache HTTP Server on Linux
Installing Apache HTTP Server on Windows
Starting and Stopping Apache HTTP Server
Chapter 7 Installing PHP
Installing PHP with OCI8 on Linux
Installing OCI8 Using a Local Database
Installing OCI8 Using Oracle Instant Client
Upgrading PHP with PECL OCI8 on Linux
Upgrading OCI8 as a Static Library on Linux
Upgrading OCI8 on Linux Using the PECL Channel
Upgrading OCI8 as a Shared Library on Linux
Installing PHP With OCI8 on Windows
Installing OCI8 Using a Local Database on Windows
Installing OCI8 with Instant Client on Windows
Upgrading OCI8 on Windows
Installing OCI8 with Oracle Application Server on Linux
Installing PHP With PDO
Installing PDO on Linux
Installing PDO on Windows
Checking OCI8 and PDO_OCI Installation
Chapter 8 Installing Zend Core for Oracle
Installing Zend Core for Oracle
Installing Zend Core for Oracle on Linux
Testing the Zend Core for Oracle Installation on Linux
Installing Zend Core for Oracle on Windows
Testing the Zend Core for Oracle Installation on Windows
Configuring Zend Core for Oracle
Chapter 9 Connecting to Oracle Using OCI8
Oracle Connection Types
Standard Connections
Multiple Unique Connections
Persistent Connections
Oracle Database Name Connection Identifiers
Easy Connect String
Database Connect Descriptor String
Database Connect Name
Common Connection Errors
Setting Oracle Environment Variables for Apache
Closing Oracle Connections
Close Statement Resources Before Closing Connections
Transactions and Connections
Session State with Persistent Connections
Optional Connection Parameters
Connection Character Set
Connection Session Mode
Changing the Database Password
Changing Passwords On Demand
Changing Expired Passwords
Tuning Oracle Connections in PHP
Use the Best Connection Function
Pass the Character Set
Do Not Set the Date Format Unnecessarily
Managing Persistent Connections
Maximum Number of Persistent Connections Allowed
Timeout for Unused Persistent Connections
Pinging for Closed Persistent Connections
Apache Configuration Parameters
Reducing Database Server Memory Used By Persistent Connections
Oracle Net and PHP
Connection Rate Limiting
Setting Connection Timeouts
Configuring Authentication Methods
Detecting Dead PHP Apache Sessions
Other Oracle Net Optimizations
Tracing Oracle Net
Connection Management in Scalable Systems
Chapter 10 Executing SQL Statements With OCI8
SQL Statement Execution Steps
Query Example
Oracle Datatypes
Fetch Functions
Fetching as a Numeric Array
Fetching as an Associative Array
Fetching as an Object
Defining Output Variables
Fetching and Working with Numbers
Fetching and Working with Dates
Insert, Update, Delete, Create and Drop
Transactions
Autonomous Transactions
The Transactional Behavior of Connections
PHP Error Handling
Handling OCI8 Errors
Tuning SQL Statements in PHP Applications
Using Bind Variables
Tuning the Prefetch Size
Tuning the Statement Cache Size
Using the Server and Client Query Result Caches
Limiting Rows and Creating Paged Datasets
Auto-Increment Columns
Getting the Last Insert ID
Exploring Oracle
Case Insensitive Queries
Analytic Functions in SQL
Chapter 11 Using PL/SQL With OCI8
PL/SQL Overview
Blocks, Procedures, Packages and Triggers
Anonymous Blocks
Stored or Standalone Procedures and Functions
Packages
Triggers
Creating PL/SQL Stored Procedures in PHP
End of Line Terminators in PL/SQL with Windows PHP
Calling PL/SQL Code
Calling PL/SQL Procedures
Calling PL/SQL Functions
Binding Parameters to Procedures and Functions
Array Binding and PL/SQL Bulk Processing
PL/SQL Success With Information Warnings
Using REF CURSORS for Result Sets
Closing Cursors
Converting from REF CURSOR to PIPELINED Results
Oracle Collections in PHP
Using PL/SQL and SQL Object Types in PHP
Using OCI8 Collection Functions
Using a REF CURSOR
Binding an Array
Using a PIPELINED Function
Getting Output with DBMS_OUTPUT
PL/SQL Function Result Cache
Using Oracle Locator for Spatial Mapping
Inserting Locator Data
Queries Returning Scalar Values
Selecting Vertices Using SDO_UTIL.GETVERTICES
Using a Custom Function
Scheduling Background or Long Running Operations
Reusing Procedures Written for MOD_PLSQL
Chapter 12 Using Large Objects in OCI8
Working with LOBs
Inserting and Updating LOBs
Fetching LOBs
Temporary LOBs
LOBs and PL/SQL procedures
Other LOB Methods
Working with BFILEs
Chapter 13 Using XML with Oracle and PHP
Fetching Relational Rows as XML
Fetching Rows as Fully Formed XML
Using the SimpleXML Extension in PHP
Fetching XMLType Columns
Inserting into XMLType Columns
Fetching an XMLType from a PL/SQL Function
XQuery XML Query Language
Accessing Data over HTTP with XML DB
Chapter 14 PHP Scalability and High Availability
Database Resident Connection Pooling
How DRCP Works
PHP OCI8 Connections and DRCP
When to use DRCP
Sharing the Server Pool
Using DRCP in PHP
Configuring and Enabling the Pool
Configuring PHP for DRCP
Application Deployment for DRCP
Monitoring DRCP
V$PROCESS and V$SESSION Views
DBA_CPOOL_INFO View
V$CPOOL_STATS View
V$CPOOL_CC_STATS View
High Availability with FAN and RAC
Configuring FAN Events in the Database
Configuring PHP for FAN
Application Deployment for FAN
RAC Connection Load Balancing with PHP
Chapter 15 Globalization
Establishing the Environment Between Oracle and PHP
Manipulating Strings
Determining the Locale of the User
Encoding HTML Pages
Specifying the Page Encoding for HTML Pages
Specifying the Encoding in the HTTP Header
Specifying the Encoding in the HTML Page Header
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 Number Formats
Oracle Date Formats
Oracle Linguistic Sorts
Oracle Error Messages
Chapter 16 Testing PHP and the OCI8 Extension
Running OCI8 Tests
Running a Single Test
Tests that Fail
Creating OCI8 Tests
OCI8 Test Helper Scripts
Configuring the Database For Testing
Appendix A Tracing OCI8 Internals
Enabling OCI8 Debugging output
Appendix B OCI8 php.ini Parameters
Appendix C OCI8 Function Names in PHP 4 and PHP 5
Appendix D The Obsolete Oracle Extension
Oracle and OCI8 Comparison
Appendix E Resources
General Information and Forums
Oracle Documentation
Selected PHP and Oracle Books
Software and Source Code
PHP Links
Glossary
Baixe o Book Aqui: Download
Até a próxima
:-)
This entry was posted on quarta-feira, 6 de outubro de 2010 at 12:11 and is filed under Php. You can follow any responses to this entry through the RSS 2.0. You can leave a response.
Sobre o Autor:Guilherme Oliveira trabalha com desenvolvimento de software a mais de 10 anos. É técnico em informática, bacharel em ciência da computação, especialista em engenharia de software, além de ser Oracle Certified Java Programmer 6 (OCJP 6). Suas áreas preferidas são desenvolvimento web e games.
|
- No comments yet.