Book Image

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

By : Yuli Vasiliev
Book Image

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

By: Yuli Vasiliev

Overview of this book

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 (16 chapters)
PHP Oracle Web Development
Credits
About the Author
About the Reviewer
Preface

Fetching Results with OCI8


If the oci_execute call returns true, you can then move on to fetching the results. Of course, this makes sense only if you are dealing with a query operation. This section provides a practical description of the fetch functions available in OCI8 as well as code samples showing a few different ways to fetch the retrieved data.

OCI8 Functions for Fetching

The PHP OCI8 extension offers several functions that can be used to fetch the result data. These functions are listed in the following table:

OCI8 fetching function

Description

oci_fetch_assoc

Returns the next row from the result data as an associative array, thus allowing for the fields to be referenced by name. If there are no more rows to be fetched, it returns false.

oci_fetch_row

Returns the next row from the result data as a numeric array. If there are no more rows to be fetched, it returns false.

oci_fetch_array

Returns the next row from the result data as an array. An optional second parameter...