PacktLib: PHP Oracle Web Development: Data processing, Security, Caching, XML, Web Services, and Ajax

PHP Oracle Web Development

Credits

About the Author

About the Reviewer

Preface

Getting Started with PHP and Oracle

Why PHP and Oracle?

Exploring PHP and Oracle Alternatives

What You Need to Start

Creating Your First PHP/Oracle Application

Summary

PHP and Oracle Connection

Introducing the PHP OCI8 Extension

Connecting to Oracle with OCI8

Parsing and Executing SQL Statements with OCI8

Fetching Results with OCI8

Alternatives to PHP OCI8 Extension

Summary

Data Processing

Implementing the Business Logic of a PHP/Oracle Application

Using Complex SQL Statements

Using Stored Subprograms

Using Triggers

Summary

Transactions

Overview of Transactions

Developing Transactional Code

Transaction Isolation Considerations

Summary

Object-Oriented Approach

Implementing PHP Classes to Interact with Oracle

Extending Existing Classes

Interactions between Objects

Event-Driven Communication

Using Oracle Object-Relational Features

Summary

Security

Securing PHP/Oracle Applications

Hashing

Setting Up Fine-Grained Access with Database Views

Using VPD to Implement Row-Level Security

Summary

Caching

Caching Data with Oracle and PHP

Implementing Notification-Based Caching

Summary

XML-Enabled Applications

Processing XML in PHP/Oracle Applications

Building PHP Applications on Oracle XML DB

Querying Data with Oracle XQuery

Summary

Web Services

Exposing a PHP/Oracle Application as a Web Service Using PHP SOAP Extension

Adding Security

Summary

AJAX-Based Applications

Building AJAX-Based PHP/Oracle Applications

Implementing Master/Detail Solutions with AJAX

Summary

Installing PHP and Oracle Software

Installing PHP and Oracle Software

Installing PHP and Oracle Software

Installing PHP and Oracle Software

Installing PHP and Oracle Software