PHP Oracle Web Development: Data processing, Security, Caching, XML, Web Services, and Ajax: A practical guide to combining the power, performance, scalability, ... time, and high performance of PHP (Paperback)

~ Yuli Vasiliev (Author)

Editorial Reviews

Product Description

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

• Program your own PHP/Oracle application
• Move data processing inside the database
• Distribute data processing between the web/PHP and Oracle database servers
• Create reusable building blocks for PHP/Oracle solutions
• Use up-to-date technologies, such as Ajax and web services, in PHP Oracle development

In Detail

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.

What you will learn from this book?

• 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

Approach

Through numerous examples, this book shows you how to build simple and efficient PHP applications on top of Oracle, efficiently distributing data processing between the Web/PHP server and Oracle Database server.

Who this book is written for?

Although this book covers only the most popular and up-to-date topic areas on the use of PHP in conjunction with Oracle, the author does not make any assumption about the skill level of the reader. Packed with information in an easy-to-read format, the book is ideal for any PHP developer who deals with Oracle.

About the Author

Yuli Vasiliev

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.

Product Details

• Paperback: 396 pages
• Publisher: Packt Publishing (July 30, 2007)
• Language: English
• ISBN-10: 1847193633
• ISBN-13: 978-1847193636
• Product Dimensions: 9.1 x 7.5 x 1 inches
• Shipping Weight: 1.5 pounds (View shipping rates and policies)
• Average Customer Review: 4.8 out of 5 stars  See all reviews (4 customer reviews)
• Amazon.com Sales Rank: #626,360 in Books (See Bestsellers in Books)

  Popular in this category: (What's this?)

  #78 in

  Books > Computers & Internet > Programming > Languages & Tools > Ajax

Customer Reviews

Most Helpful Customer Reviews

2 of 2 people found the following review helpful:

5.0 out of 5 stars Clear and concise, October 2, 2007

By	I. Laskey "ilaskey" (UK) - See all my reviews (REAL NAME)

PHP Oracle Web Development by Yuli Vasiliev, to quote the front, covers data processing, security, caching, XML, Web Services and Ajax. Quite a lot for a mere 360 or so pages.

The book starts off with notes on both PHP and Oracle and describes how to obtain them both and how to get everything up and running using the PHP OCI8 extensions from Oracle. Whilst Oracle is a market leader in the big database arena, many developers will be surprised to learn that the full and unrestricted product is freely downloadable for development purposes - you only need to buy a licence for a production system. Even then, a free cut down version is available if you don't need the full bells and whistles.

So, with everything up and running, the book launches in to the subject at hand. I was immedietely impressed with the author's clear and easily read prose. Every subject is presented with just the right balance of detail with lots of additional notes and background information to help fill in any gaps. The author's real world experience shines through with sections on locking issues and coding for reusability. The section on object-orienation was particularly welcome.

I also liked the fact that the book didn't just cover the core subject of using Oracle with PHP but also covered vital related material such as various security models and a sizeable section on caching techniques. The sections on XML, Web Services via SOAP and Ajax ensure all the current must-have skills are represented. Ajax was presented via an example application which featured all the aspects you'd need including both code and style sheets but I'd have liked a bit more general advice and description here.

The bulk of the book though is the coverage of the OCI8 extentions and here you can find out how to issue a wide variety of SQL statements including using stored procedures, making use of triggers and a good section on transaction handling that didn't just show how to use them but also had useful advice on structuring your code to make best use of them. I would have liked some notes on avoiding things like SQL Injection attacks but that apart, the security section had some interesting nuggets.

The section on object-orientation warrents close inspection if you want to really leverage the power of the tools available in this development environment. It didn't have much on the 'big picture' of how you'd structure applications this way but it does describe how it all works and how to extend existing objects as well as create your own.

I feel I can safely say that if you need to get to grips with PHP in an Oracle environment, you'll find everything you'll need here to get up and running very quickly. The pace, content and structure of the book are all excellent with my only reserve being the assumption that everything works as it is supposed to with not much in the way of troubleshooting advice. That apart, this is a fine book.

1 of 1 people found the following review helpful:

4.0 out of 5 stars A great introduction to PHP and Oracle and how they play together, November 25, 2007

By	Lorenzo Alberton (Cambiano, Torino Italy) - See all my reviews (REAL NAME)

This book consists in almost 400 pages of solid content, and is targeted at beginners-to-intermediate PHP and Oracle developers who want to learn or have a deeper understanding of the interaction of the two technologies.

The first chapters highlight the capabilities and advantages of Oracle, cover the installation and connecting procedures, and present some of the alternatives to use Oracle with PHP: using the PHP OCI8 extension directly, and with some popular database abstraction libraries like PEAR::DB, ADOdb, or PDO. A capital sin is it never mentions PEAR::MDB2 ;-)
The central chapters are dedicated to data processing, transaction handling, OO programming, security and caching (also using PEAR::Cache_Lite).
The last chapters are dedicated to XML, XSLT, SOAP and AJAX, and are packed with examples which are more than enough to get you started with those features. All the code examples are laid in a plain and very easy to understand way, yet consistently suggesting some best practices from the very beginning.

The first merit of this book is it shows how you can process data with the DBMS and not just to treat the DBMS like a dumb storage system. For instance, there's a whole chapter explaining how to store, query and transform XML documents with PHP and with Oracle's internal XSLT functions, and there are many examples of STORED PROCEDUREs, TRIGGERs, transaction handling, etc.
A good part of the examples have a strong focus on security too. I found particularly interesting the explanation of alternative techniques to secure your tables, and to mask rows and columns for fine-grained access, using not only VIEWs, but also SPs, multiple schemas, PL/SQL packages, table functions and Virtual Private Database policies. On the PHP side, it goes all the way to create a custom PEAR::Auth container.

One of the most interesting paragraphs of the book describes the usage of Change Notification and notification handlers (a new feature of Oracle Database 10g Rel 2) for caching purposes.

While some of the described techniques aren't Oracle-specific and could be used with any other DBMS and it would have been nice to dive deeper into some other unique Oracle characteristics, that was probably out of scope for an introduction to PHP and Oracle, and it doesn't detract from the merits of this excellent book.

The writing style is clear, even if IMHO it could have been more concise sometimes. For instance, reading continue anticipations and wrap-ups that stress the same concept can get a bit annoying after a while: "In the next chapter we're going to see...", "This chapter covers...", "Now that you have an idea on how...", "In this chapter we've learnt how to...".
Anyway, I guess that it's in the spirit of the old adagio "repetita iuvant", and it may make sense in a technical book. My overall impression is very positive.

1 of 1 people found the following review helpful:

5.0 out of 5 stars Clear and useful book, October 19, 2007

By	Alexander Baranov - See all my reviews (REAL NAME)

It's rather small, but gives a good overview of PHP, Oracle and AJAX, coupled together. There is only one project example Throughout the whole book, which is enhanced from various aspects. To be precise, they are:

Performance Optimization - views, stored subprograms, triggers, binding variables (Oracle);
caching mechanisms (PHP,Oracle) - intended to reduce amount of data transferred between database and web servers; AJAX - browser-side optimization,

Security - special database schemas coding/decoding algorithms usage(sha1, md5),
Virtual Private Database (VPD) - Oracle

Scalability/Complexity Control - object-oriented approach (PHP5 features, Oracle Object Types)

Unified Data - XML-processing data inside database/PHP server
using XML DB to implement web-service (SOAP, WSDL).

Many of these ideas are rather universal and can be applied to other database servers, web servers and script languages

I would like to emphasize that author is an expert in Oracle, he tries to move almost all business-logic to database server, use native Oracle features (some of them are implemented only in latest Oracle versions). There are also chapters devoted to general database principles (transaction features (ACID), views, stored subprograms, concurrency, views, triggers, stored subprograms) which can be very useful for novice developers.