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

A practical book and eBook 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

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

Yuli Vasiliev

1 customer reviews
A practical book and eBook 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
Mapt Subscription
FREE
$29.99/m after trial
eBook
$21.00
RRP $29.99
Save 29%
Print + eBook
$49.99
RRP $49.99
What do I get with a Mapt Pro subscription?
  • Unlimited access to all Packt’s 5,000+ eBooks and Videos
  • Early Access content, Progress Tracking, and Assessments
  • 1 Free eBook or Video to download and keep every month after trial
What do I get with an eBook?
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with Print & eBook?
  • Get a paperback copy of the book delivered to you
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with a Video?
  • Download this Video course in MP4 format
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
$0.00
$21.00
$49.99
$29.99p/m after trial
RRP $29.99
RRP $49.99
Subscription
eBook
Print + eBook
Start 30 Day Trial
Subscribe and access every Packt eBook & Video.
 
  • 5,000+ eBooks & Videos
  • 50+ New titles a month
  • 1 Free eBook/Video to keep every month
Start Free Trial
 
Preview in Mapt

Book Details

ISBN 139781847193636
Paperback396 pages

Book Description

Oracle Database gets high marks for performance, reliability, and scalability. Building and deploying your PHP applications on Oracle Database enables you to combine the power and robustness of Oracle and the ease of use, short development time, and high performance of PHP. When used in a complementary way, PHP and Oracle allow you to build high-performance, scalable, and reliable data-driven Web applications with a minimum of effort.

When building a PHP/Oracle application, you have two general options. The first is to use an Oracle database just to store data, performing all the operations on that data on the client side; the other is to use the database not only to store data, but also to process it, thus moving data processing to the data. While building the key business logic of a database-driven PHP application inside the database is always a good idea, you should bear in mind that not all of the databases available today allow you to do. The Oracle database, which offers record-breaking performance, scalability, and reliability, does. The partnership of Oracle and the open-source scripting language PHP is an excellent solution for building high-performance, scalable, and reliable data-driven web applications.

This 100% practical book is crammed full of easy-to-follow examples. It provides all the tools a PHP/Oracle developer needs to take advantage of the winning combination. It addresses the needs of a wide spectrum of PHP/Oracle developers, placing the emphasis on the most up-to-date topics, such as new PHP and Oracle Database features, stored procedure programming, handling transactions, security, caching, web services, and Ajax.

Table of Contents

Chapter 1: 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
Chapter 2: 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
Chapter 3: Data Processing
Implementing the Business Logic of a PHP/Oracle Application
Using Complex SQL Statements
Using Stored Subprograms
Using Triggers
Summary
Chapter 4: Transactions
Overview of Transactions
Developing Transactional Code
Transaction Isolation Considerations
Summary
Chapter 5: 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
Chapter 6: Security
Securing PHP/Oracle Applications
Hashing
Setting Up Fine-Grained Access with Database Views
Using VPD to Implement Row-Level Security
Summary
Chapter 7: Caching
Caching Data with Oracle and PHP
Implementing Notification-Based Caching
Summary
Chapter 8: XML-Enabled Applications
Processing XML in PHP/Oracle Applications
Building PHP Applications on Oracle XML DB
Querying Data with Oracle XQuery
Summary
Chapter 9: Web Services
Exposing a PHP/Oracle Application as a Web Service Using PHP SOAP Extension
Adding Security
Summary
Chapter 10: AJAX-Based Applications
Building AJAX-Based PHP/Oracle Applications
Implementing Master/Detail Solutions with AJAX
Summary

What You Will Learn

  • Install and configure PHP and Oracle software
  • Connect PHP with Oracle
  • Move key application business logic into the database
  • Build transactional PHP/Oracle applications
  • Use security features of PHP and Oracle
  • Improve performance with caching
  • Employ XML features of PHP and Oracle
  • Implement SOAP Web services with PHP and Oracle
  • Build Ajax-driven PHP/Oracle solutions

Chapter 1 gives an overview of the PHP and Oracle technologies, explaining why you might want to use PHP in conjunction with Oracle.

Chapter 2 covers the basics of using the PHP OCI8 extension to interact with an Oracle database from PHP. It also briefly discusses some popular alternatives to the OCI8 extension to connect to Oracle from within PHP.

Chapter 3
discusses how you can move data processing performed by your PHP/Oracle application into the database by using sophisticated SQL queries, stored PL/SQL procedures, and database triggers.

Chapter 4 discusses the various mechanisms that can be used to perform transactions with PHP and Oracle.

Chapter 5 examines the object-oriented approach to developing PHP/Oracle applications, as an efficient means to reduce the development time and complexity, and increase the maintainability and flexibility of your applications.

Chapter 6 discusses how to effectively use the security features of both PHP and Oracle together, examining the fundamental aspects of building a secure PHP/Oracle application.

Chapter 7 discusses how to effectively use caching mechanisms available in PHP and Oracle and provides several examples of caching in action.

Chapter 8 explains how to effectively use XML techniques and technologies available in PHP and Oracle when building XML-enabled PHP/Oracle applications.

In Chapter 9 you learn how to build a SOAP Web service exposing the functionality of a PHP/Oracle application, using the PHP SOAP extension and Oracle XML technologies.

Chapter 10 explains how Ajax and some other client-side (browser-side) JavaScript technologies can be used along with Oracle Database technologies as well as PHP features to improve the responsiveness of PHP/Oracle applications.

An Appendix covers installation of PHP and Oracle software.

Authors

Table of Contents

Chapter 1: 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
Chapter 2: 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
Chapter 3: Data Processing
Implementing the Business Logic of a PHP/Oracle Application
Using Complex SQL Statements
Using Stored Subprograms
Using Triggers
Summary
Chapter 4: Transactions
Overview of Transactions
Developing Transactional Code
Transaction Isolation Considerations
Summary
Chapter 5: 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
Chapter 6: Security
Securing PHP/Oracle Applications
Hashing
Setting Up Fine-Grained Access with Database Views
Using VPD to Implement Row-Level Security
Summary
Chapter 7: Caching
Caching Data with Oracle and PHP
Implementing Notification-Based Caching
Summary
Chapter 8: XML-Enabled Applications
Processing XML in PHP/Oracle Applications
Building PHP Applications on Oracle XML DB
Querying Data with Oracle XQuery
Summary
Chapter 9: Web Services
Exposing a PHP/Oracle Application as a Web Service Using PHP SOAP Extension
Adding Security
Summary
Chapter 10: AJAX-Based Applications
Building AJAX-Based PHP/Oracle Applications
Implementing Master/Detail Solutions with AJAX
Summary

Book Details

ISBN 139781847193636
Paperback396 pages
Read More
From 1 reviews

Read More Reviews

Recommended for You

Responsive Web Design with HTML5 and CSS3 Book Cover
Responsive Web Design with HTML5 and CSS3
$ 23.99
$ 4.80
Web Services Testing with soapUI Book Cover
Web Services Testing with soapUI
$ 29.99
$ 21.00
Oracle Service Bus 11g Development Cookbook Book Cover
Oracle Service Bus 11g Development Cookbook
$ 35.99
$ 25.20
JasperReports 3.5 for Java Developers Book Cover
JasperReports 3.5 for Java Developers
$ 26.99
$ 18.90
Do more with SOA Integration: Best of Packt Book Cover
Do more with SOA Integration: Best of Packt
$ 19.99
$ 14.00
Getting Started With Oracle SOA Suite 11g R1 - A Hands-On Tutorial Book Cover
Getting Started With Oracle SOA Suite 11g R1 - A Hands-On Tutorial
$ 35.99
$ 25.20