Oracle Consulting Oracle Training Oracle Support Development
Home
Catalog
Oracle Books
SQL Server Books
IT Books
Job Interview Books
eBooks
Rampant Horse Books
911 Series
Pedagogue Books

Oracle Software
image
Write for Rampant
Publish with Rampant
Rampant News
Rampant Authors
Rampant Staff
 Phone
 800-766-1884
Oracle News
Oracle Forum
Oracle Tips
Articles by our Authors
Press Releases
SQL Server Books
image
image

Oracle 11g Books

Oracle tuning

Oracle training

Oracle support

Remote Oracle

STATSPACK Viewer

Privacy Policy

  

 

ISBN: 
0-9761573-0-6 
ISBN 13
978-0976157304
Library of Congress Number: 2005928018
230 pages
Perfect bind - 9x7
PD 206
Shelving:  Databases/Oracle Easy Oracle Series
# 6

  Easy Oracle PHP
Create Dynamic Web Pages with Oracle Data

Mladen Gogala               Retail Price $27.95 /  £18.95

Order now at 30% off and get access to the code depot! Only $19.95
(30% off)
     
Key Features About the Author Table of Contents
Index Reader Comments Errata
     
Get the Oracle Developer Pack
Six for $79.95 - A $145.00 value
Easy Oracle Application Express (HTML-DB) $39.95
Oracle 10g Reference Poster $8.95
Oracle Backup & Recovery Scripts download $16.95
Oracle PHP: Create web pages with Oracle $27.95
Oracle PL/SQL Programming $16.95
Oracle PL/SQL Tuning $34.95

 

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.

 
Key Features

* See ready-to-use examples for connecting to Oracle with PHP

* Learn templates for extracting Oracle data in PHP

* Create dynamic web content with PHP and Oracle

* See real-world techniques for writing parameterized PHP Oracle queries

* Understand how to update Oracle from PHP

* Learn the best PHP Oracle coding styles

 

About the Author:


Mladen Gogala

Mladen Gogala is a highly-respected Oracle certified DBA with more than 15 years of IT experience and a BA degree in mathematics. Gogala has extensive experience in UNIX scripting, Oracle tuning and UNIX system administration, using every popular dialect of UNIX and Linux. Gogala is also a respected member of the popular Oracle-l list, where he assists in solving complex Oracle questions.

Mladen is active in his community promotion and he enjoys a variety of sports and outdoor activities, but he spends his leisure time working as proud father of a teenager.

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

Index Topics:
$_COOKIE
$_ENV
$_FILES
$_FILES array
$_GET
$_POST
$_REQUEST
$_SERVER
$_SESSION
$ADODB_CACHE_DIR
$ADODB_FETCH_MODE
$b
$bind_array
$count
$database
$err
$GLOBALS
$greeting
$this
_
__destruct
_autoload
A
abstract
ADOdb
alignment specifier
Apache
Arithmetic Operators
array explode
array range
Arrays
Autocommit
autocommit()
B
BeginTrans()
Boolean Values
break
C
CacheExecute
CHAR
class exception
CommitTrans()
Comparison Operators
Current($a)
CurrentRow()
D
DB_Common
DB_PORTABILITY_LOWERCASE
DB_PORTABILITY_NONE
DB_PORTABILITY_NULL_TO_EMPTY
DB_PORTABILITY_NUMROWS
DB_PORTABILITY_RTRIM
DBA_EXTENTS
DBA_Helper
dba_role_privs
dba_sys_privs
dba_triggers
dba_users
dba_views
DBMS_APPLICATION_INFO
dbms_metadata
dbms_metadataq.get_ddl
DBMS_MONITOR
dbms_output
displayQueryAsTable()
E
Each($a)
End($a)
Exceptions
ExecuteCursor
EXPLAIN PLAN
EXTR_IF_EXISTS
EXTR_OVERWRITE
EXTR_PREFIX_ALL
EXTR_PREFIX_IF_EXISTS
EXTR_PREFIX_INVALID
EXTR_PREFIX_SAME
EXTR_REFS
EXTR_SKIP
Extract
F
FetchField()
fetchRow()
FieldCount()
final
For Statement
Foreach Statement
Functions
G
getCode()
getDebugInfo()
getMessage()
getUserInfo()
global
GLOBAL_NAMES
GV$LOCK
H
HTML_Table Module
I
If Statement
import_request_variables
include
Includes
InParameter()
Interfaces
Interpolation
iterator functions
K
Key($a)
L
Logical Operators
Loops
M
max_execution_time
Move()
MoveFirst()
MoveLast()
MoveNext()
N
Next($a)
NULL
O
oci_bind_by_name()
oci_error()
oci_execute()
oci_new_connect()
oci_parse()
OCI Module
Operator Precedence
Oracle Editor
Oracle RDBMS
OutParameter()
P
padding specifier
Parameter()
PEAR
PEAR DB
PEAR_Error
PHP
PHP variables
PHP
phpinfo
precision specifier
preg_grep
preg_match
preg_quote
preg_replace
preg_replace_callback
PrepareSP
Previous($a)
printf()
R
Reset($a)
RollbackTrans()
S
session_register
session_start()
set_time_limit
SetFetchMode
setHeaderContents
show_emp()
sign specifier
sort function
sprintf()
SQL command
sql_plan.php
Statements
static
string implode
Strings
switch
Switch Statement
T
tableInfo()
type specifier
V
V$ACCESS
V$LOCK
V$PARAMETER
v$resource_limit
V$SESSION
V$SESSION_EVENT
V$SESSTAT
v$sgastat
V$SQL_PLAN
V$SQLTEXT
v$sysstat
v$system_event
var_dump()
VARCHAR
W
While Statement
width specifier
Z
Zend Core

PHP Oracle Examples:

Web-Powered Databases
by David Taniar (Editor), Johanna Wenny Rahayu (Editor)
Oracle PHP example on page 161

Reviews:

From the series Editor:

As the series editor for this book I was involved in Gogala’s book, from initial inception to finished product, and I’m impressed.  Oracle offers a wealth of different tools to create dynamic web pages (Apex (HTML-DB), Jdeveloper, Ruby on Rail on Oracle, etc.) and PHP is an excellent choice because it is powerful, mature and has well-tested Oracle interfaces.

It’s very difficult to take a complex topic such as Oracle with PHP and condense it into an understandable and concise framework, but Gogala has met this challenge.

PHP is, by its very nature, a flexible and robust language, and I was happy to see that Gogala resisted the temptation to go into all of the advanced PHP features.

This is not an advanced PHP Oracle book.  Rather, it is a get-started guide with lots of simple, easy to understand examples, and working Oracle PHP code snippets in the code download to allow beginners to get started fast.  Mladen spent hundreds of hours refining his text and working with Steve Karam, his technical editor, and I hope that you will agree that this is a great way to get started with Oracle databases on the web.


Review: Easy Oracle PHP

Before my move absorbed my time, I promised to review the first Oracle PHP book published this year, "Easy Oracle PHP: Create Dynamic Web Pages with Oracle Data" by Mladen Gogala.  Now I'm once again at a permanent address I was able to order a copy of the book.  There is always a delightful pleasure in having a parcel delivered to my office.

Mladen "is a long term DBA" and has been actively helping on various Oracle-related mailing lists. I had the pleasure of meeting him at the New York PHP conference where he made a special trip into NY to meet
me.

The writing style of Easy Oracle PHP is very clear.  The book is relatively short at 264 pages but it focuses directly on PHP-Oracle interaction and does not need to be longer (though everyone will always wish for more).

The chapters are:

  •     Introduction to PHP
  •     PHP Object Model
  •     OCI8 Model
  •     Using PEAR
  •     Using ADOdb
  •     Open Source Software
  •     DBA Little Helper
  •     Installing PHP5, Apache and PEAR


The introduction to PHP is concise and readable.  It nicely summarizes important aspects of the PHP language without spending time on detail that is anyway best read from a dedicated PHP language book or the online PHP manual.  The discussion of OO is necessarily brief but it is to the point.

The OCI8, PEAR, and ADOdb chapters form the core third of the book. Connecting, fetching, committing, binding BLOBS, PL/SQL and handling errors are all covered with clear examples.  Comparisons between interfaces are made.  Gotchas and the occasional bug are mentioned so you know exactly where you stand.  Code examples are informative.

Open Source Software is a short chapter that speaks about the Oracle Editor.  This is an example program that provides a web interface to an Oracle DB.  It was available from OTN's PHP Developer Center and is still online at various places.

The next chapter, DBA Little Helper, is much longer.  It covers the author's tool for managing Oracle databases.  The tool itself is available from the
author's website where new versions are posted as features are added.  To appreciate this chapter some familiarity with Oracle terminology is useful but the source code is a good example of a large application.

The final chapter discusses installation.  This is perhaps the chapter which will date quickest as the PHP community improves (or changes) regularly.  Again gotchas are clearly explained so it is a valuable reference for everyone.

The clear writing, use of solid examples, and deep understanding of the Oracle database by the author make this a good book.  The focus of the book on the interaction of the database with PHP gives the reader the ability to focus on the core of applications. This book will have most benefit for Oracle users who are new to PHP but will also give insight for PHP users with less Oracle familiarity.



Errata:
 

Hit Counter

   

 Copyright © 1996 -2016 by Burleson. All rights reserved.


Oracle® is the registered trademark of Oracle Corporation. SQL Server® is the registered trademark of Microsoft Corporation. 
Many of the designations used by computer vendors to distinguish their products are claimed as Trademarks