Intelligentedu Best New Free Computer IT Training Tutorial Resources

The free Underground PHP and Oracle Manual is hot off the press and now freely available for download.. The OTN team describes it: "Just starting out with PHP database development, or unsure how to install PHP and Oracle? This full-length guide includes everything you need to know (and more)." This PHP / Oracle guide is 124 pages and in pdf format.

The Underground PHP and Oracle Manual


Here is the Table of Contents:

Chapter 1

• Introduction
• Who Should Read This Book?
• Introduction to Oracle
• Oracle Database Terminology
• Introduction to PHP
• Choosing a PHP Oracle Extension
  

Chapter 2

• PHP Oracle Extensions
•    Oracle Extension
•    OCI8 Extension
•    PDO Extension
• PHP Database Abstraction Libraries
•    ADOdb
•    PEAR DB
•    PEAR MDB2
• Getting the OCI8 Extension
• PHP and Oracle Installation Options
• Zend Core for Oracle
• PHP Version Numbering
• OCI8 Function Names in PHP 5
  

Chapter 3

• 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 Oracle Listener
• Starting and Stopping the Database
• Enabling Remote Client Connection
  

Chapter 4

• Using Oracle Database 10g Express Edition
• Oracle Application Express
• Logging In To Oracle Application Express
• Creating Database Object
• Working with SQL Scripts
• Creating a PL/SQL Procedure
• Creating a Database User
• Monitoring Database Sessions
• Database Backup and Recovery
• Backing Up The Database
• Restoring The Database
• Oracle Security
• Security Mechanisms
  

Chapter 5

• Installing Apache HTTP Server
• Installing Apache HTTP Server on Linux.
• Starting and Stopping Apache HTTP Server
• Installing Apache HTTP Server on Windows
• Starting and Stopping Apache HTTP Server
  

Chapter 6

• Installing Zend Core for Oracle
• Zend Core for Oracle
• Installing Zend Core for Oracle
• Configuring Zend Core for Oracle
• Testing the Zend Core for Oracle Installation
  

Chapter 7

• Installing PHP
• Installing PHP on Linux
• Restart the Apache HTTP Server
• Installing PHP on Windows
• Restart the Apache HTTP Server
  

Chapter 8

• Installing PHP With Oracle Instant Client 
• Installing Oracle Instant Client on Linux
• Installing Oracle Instant Client on Windows
  

Chapter 9

• Connecting to Oracle Using OCI8
• Oracle Connection Types
• Standard Connections
• Unique Connections
• Persistent Connections
• Oracle Database Name Connection Strings
• Easy Connect String.
• Full Database Connection String
• Database Alias
• Oracle Environment Variables for Connections
• Closing Oracle Connections
• Connection Cleanliness with Persistent Connections
• Optional Connection Parameters
• Connection Character Set 
• Connection Privilege Level
• The Transactional Behavior of Connections
• Tuning Oracle Connections in PHP
• Tuning Oracle Net
• Other Oracle Net Optimizations
• Tracing Oracle Net.
• Tuning Persistent Connections
• Connection Management in Scalable Systems
  

Chapter 10

• Executing SQL Statements With OCI8
• SQL Statement Execution Steps
• Query Example
• Oracle Datatypes
• Fetch Functions
• Insert, Update, Delete, Create and Drop
• Transactions
• Autonomous Transactions
• Handling Errors
• Limiting Rows and Creating Paged Datasets
• Auto-Increment Columns
• Tuning SQL Statements in PHP Applications
• Default Prefetch Size
• Default Statement Cache Size
• Using Bind Variables
• Exploring SQL
• Regular Expressions in SQL
• Analytic Functions in SQL
  

Chapter 11

• Using PL/SQL
• PL/SQL Overview
• Blocks, Procedures, Packages and Triggers
• Anonymous Block
• Stored or Standalone Procedure and Function
• Package
• Trigger
• Calling PL/SQL Procedures and Functions
• Getting output from PL/SQL with DBMS_OUTPUT
• Oracle Collections in PHP
• Using PL/SQL Types in PHP
• New Array Binding Function in PHP 5.1.2
• Using REF CURSORS for Result Sets
  

Chapter 12

• Using Large Objects in OCI8
• Working with LOBs
• Other LOB Methods
• Working with BFILEs
  

Chapter 13

• Using XML with Oracle and PHP
• Fetching Relational Rows as XML
• Using DBMS_XMLGEN
• Accessing Data from Oracle over HTTP
• XQuery XML Query Language

Chapter 14

• Globalization
• Establishing the Environment Between Oracle and PHP
• Manipulating Strings
• Determining the Locale of the User
• Developing Locale Awareness
• 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 Date Formats
• Oracle Number Formats
• Oracle Linguistic Sorts
• Oracle Error Messages
  

Chapter 15

• Resources
• General Information and Forums
• Documentation
• Articles and Other References
• Source and Binaries
• PHP Bugs
• Utilities
  

Glossary

Popularity: 6% [?]

Related Posts:

Oracle 10g 2 Day DBA Course

Free Books for MySQL, Oracle 10g Database, PL/SQL and SQL

Free Books on Linux, Web Development, Perl, Java, Oracle, PL-SQL, TCP-IP

Free PC Intro book

Free Training for Oracle Applications 11i