Description

This unique book focuses on removing the guesswork from creating dynamic web pages with Oracle content. 

Packed with working code examples, this book shows working examples of connecting to Oracle and delivering data into an HTML page.

This indispensable reference shows working examples of complex Oracle queries in PHP, updating Oracle from PHP, and passing parameters to a PHP program.

 

Table of Contents

All examples are elaborated in detail and compared with the other techniques and tools introduced in the book.

Chapter 1 - Overview of PHP

Introduction to PHP

Data Types

Statements

Functions

Using HTML tidy for formatting purposes.
 

Chapter 2 PHP5 Object Model

Classes, members and methods

Inheritance and interfaces

Exceptions

 

Chapter 3 - Using PHP OCI8 library for accessing Oracle Databases 

Connecting to Oracle database.

Executing SQL statements

Using  prepare and bind

Using  LOB and REF cursors with OCI8 module.
 

Chapter 4 - Accessing Oracle with PEAR
Connecting to Oracle database using PEAR

Executing SQL statements with PEAR

Using  prepare and bind

 

Chapter 5 -   Accessing Oracle with ADOdb

Connecting to Oracle database.

Executing SQL statements

Using  prepare and bind

Using  LOB and  REF cursors with ADOdb
 

Chapter 6 – Open Source Software using Oracle and PHP

This chapter describes Tim Strehle's  OracleEditor  PHP script.

 

Chapter 7 -  DBA Little Helper

This  chapter describes an open source DBA utility, written by the author using PHP and Oracle.
 

Chapter 8 – Installing PHP, PEAR and ADOdb

Installing on Linux
Installing on Windows