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
:-)



Sobre o Autor:
Guilherme Oliveira
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.