PHP Oracle web development : data processing, security, caching, XML, web services, and AJAX : a practical guide to combining the power, performance, scalability, and reliability of Oracle database with the ease of use, short development time, and high performance of PHP / Yuli Vasiliev.

Format:

Book

Author/Creator:

Vasiliev, Yuli.

Series:

From technologies to solutions.

From technologies to solutions

Language:

English

Subjects (All):

Oracle (Computer file).

PHP (Computer program language).

Physical Description:

1 online resource (397 p.)

Place of Publication:

Birmingham, U.K. : Packt Pub., 2007.

Language Note:

English

Biography/History:

Vasiliev Yuli: Yuli Vasiliev is a software developer, freelance author, and consultant currently specializing in open-source development, Oracle technologies, and service-oriented architecture (SOA). He has over 10 years of software development experience as well as several years of technical writing experience. He wrote a series of technical articles for Oracle Technology Network (OTN) and Oracle Magazine. Contact Yuli Vasiliev

Summary:

A practical guide to combining the power, performance, scalability, and reliability of the Oracle Database with the ease of use, short development time, and high performance of PHP

Contents:

Cover; Table of Contents; Preface; Chapter 1: Getting Started with PHP and Oracle; Why PHP and Oracle?; Simplicity and Flexibility; Performance; Robustness; Exploring PHP and Oracle Alternatives; PHP and MySQL; JSF and Oracle; What You Need to Start; Pieces of Software Required; Oracle Database Considerations; Understanding the Oracle Database; Choosing Between Oracle Database Editions; Obtaining Oracle Database Software; PHP Considerations; Apache HTTP Server; Why PHP 5; Obtaining PHP; Making PHP and Oracle Work Together; Oracle Instant Client; Zend Core for Oracle; Using Oracle SQL*Plus

Why Use SQL*Plus in PHP/Oracle Development?Connecting to a Database with SQL*Plus; Running Scripts in SQL*Plus; Putting It All Together; Creating Your First PHP/Oracle Application; Connecting to a Database; Using the Local Naming Method; Using the Easy Connect Method; Issuing an SQL Statement Against the Database; Fetching and Displaying Results; Summary; Chapter 2: PHP and Oracle Connection; Introducing the PHP OCI8 Extension; Why Use OCI8 Extension; Processing SQL Statements with OCI8; Connecting to Oracle with OCI8; Defining a Connection String; OCI8 Functions for Connecting to Oracle

Parsing and Executing SQL Statements with OCI8Preparing SQL Statements for Execution; Using Bind Variables; Executing SQL Statements; Handling Errors; Using the oci_error Function; Using the trigger_error Function; Using Exceptions; Fetching Results with OCI8; OCI8 Functions for Fetching; Fetching the Next Row; Fetching All the Rows; Alternatives to PHP OCI8 Extension; Using PEAR DB; Using ADOdb; Using PDO; Creating Your Own Library on Top of OCI8; Summary; Chapter 3: Data Processing; Implementing the Business Logic of a PHP/Oracle Application; When to Move the Data to the Processing

Advantages of Moving the Processing to the DataWays of Implementing Business Logic Inside the Database; Interaction between Components Implementing Business Logic; Using Complex SQL Statements; Employing Oracle SQL Functions in Queries; Oracle SQL Functions versus PHP Data Processing; Aggregate Functions; The GROUP BY Clause; Using Join Queries; Taking Advantage of Views; The Key Benefits of Using Views; Hiding Data Complexity with Views; Using the WHERE Clause; Using Stored Subprograms; What are Stored Subprograms?; Advantages of Stored Subprograms

An Example of When to Use a Stored SubprogramCreating Stored Subprograms; Calling Stored Subprograms from PHP; Using Triggers; Creating Triggers; Firing Triggers; Calling Stored Procedures from a Trigger; Summary; Chapter 4: Transactions; Overview of Transactions; What is a Transaction?; What are ACID Rules?; How Transactions Work in Oracle; Using Transactions in PHP/Oracle Applications; Structuring a PHP/Oracle Application to Control Transactions; Developing Transactional Code; Controlling Transactions from PHP; Moving Transactional Code to the Database; Using Triggers

Dealing with Statement-Level Rollbacks

Notes:

Includes index.

ISBN:

9786611252663

9781281252661

1281252662

9781847193643

1847193641

OCLC:

809771184