|
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) |
 |
Get the Oracle
Developer Pack
Six for $79.95 - A $145.00 value |
|
|
|
|
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.
|
|
* 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.
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:
|
