Christopher Jones, Alison Holloway, and many
contributors
Format
PDF
Pages
362
The Underground PHP and Oracle Manual is written for PHP
programmers developing applications for the Oracle Database. It shows
programmers how to use PHP with Oracle, and provides the fundamental
building blocks needed to create high-performance PHP Oracle Web
applications.
Topics covered:
Getting Started With PHP - provides a very brief
overview of the PHP language
PHP Oracle Extensions - covers OCI8 (PHP's main
Oracle extension) and PDO_OCI driver for the PHP Data Object extension
Installing Oracle Database 11g Express Edition -
contains an overview of, and installation instructions for, Oracle
Database 11g Express Edition for Linux and Windows
SQL with Oracle Database - contains an overview of
some SQL*Plus, Oracle Application Express and Oracle SQL Developer
features you can use to perform database development
Netbeans IDE for PHP - gives a high level overview of
the NetBeans IDE - this provides tools to make PHP development
productive and effective
Installing Apache HTTP Server - gives you the steps
needed to install and configure the Apache HTTP Server for use with PHP
Installing and Configuring PHP - discusses the main
ways of installing PHP on Linux and Windows
Installing PHP and Apache on Oracle Solaris 11.1
Connecting to Oracle Using OCI8 - covers connecting
to an Oracle database from your PHP application, showing the forms of
Oracle connection and how to tune them
Executing SQL Statements With OCI8 - discusses using
SQL statements with the PHP OCI8 extension. It covers statement
execution, the OCI8 functions available, handling transactions, tuning
queries, and some useful tips and tricks
Using PL/SQL with OCI8 - PL/SQL is Oracle’s
procedural language extension to SQL
Using Large Objects in OCI8 - Oracle Character Large
Object (CLOB) and Binary Large Object (BLOB) types can be used for very
large amounts of data. They can be used for table columns and as PL/SQL
variables
Using XML with Oracle and PHP - covers the basics of
using XML data with Oracle and PHP. It also shows how to access data
over HTTP directly from the database
PHP Connection Pooling and High Availability -
discusses connection pooling and how it applies to connection management
PHP and TimesTen In-Memory Database - TimesTen is an
in-memory database that can be used standalone or as a cache to Oracle
database
PHP and Oracle Tuxedo - shows using Oracle Tuxedo
11.1 with PHP applications running under Apache. HTTP requests are
forwarded from Apache to mod_tuxedo which then invokes the PHP script
engine. Oracle Tuxedo is a transaction oriented application server
which can be used for developing and deploying applications written in
PHP, Python and Ruby, as well as in the traditional languages C, C++,
and COBOL
Globalization - discusses global application
development in a PHP and Oracle Database environment. It addresses the
basic tasks associated with developing and deploying global
Internet applications, including developing locale awareness,
constructing HTML content in the user-preferred language, and
presenting data following the cultural conventions of the locale of the
user
Testing PHP and the OCI8 Extension - discusses
running the PHP test suite on Linux. The PHP source code includes
command-line tests for all the core functionality and extensions
The book has been updated for Oracle Database Express
Edition 11g Release 2. It is not a complete PHP syntax or Oracle SQL
guide.
Symfony is a web application framework written in PHP
that follows the model–view–controller (MVC) paradigm.
Topics covered include:
Symfony2 and HTTP Fundamentals
Symfony2 versus Flat PHP
Installing and Configuring Symfony
Creating Pages in Symfony2 - create a route, create a
controller
Controller - a PHP function you create that
takes information from the HTTP request and constructs and returns an
HTTP response
Routing - the Symfony2 router lets you define
creative URLs that you map to different areas of your application
Creating and using Templates - learn how to write
powerful templates that can be used to return content to the user,
populate email bodies, and more
Databases and Doctrine - learn the
basic philosophy behind Doctrine and see how easy working with a
database can be. Doctrine is a library whose sole goal is to
give you powerful tools to make this easy
Databases and Propel - Propel is a free, open-source
(MIT) object-relational mapping toolkit written in PHP
Testing - integrates with an independent
library - called PHPUnit - to give a rich testing framework
Validation - Symfony2 ships with a Validator
component that makes this task easy and transparent. This component is
based on the JSR303 Bean Validation specification
Forms - build a complex form from the
ground-up, learning the most important features of the form library
along the way
Security - Symfony's security component
is available as a standalone PHP library for use inside any PHP project
HTTP Cache - The Symfony2 cache system relies on the
simplicity and power of the HTTP cache as defined in the HTTP
specification
Translations - learn how to prepare an application to
support multiple locales and then how to create translations for
multiple
locales
Service Container - this chapter is about a special
PHP object in Symfony2 that helps you instantiate, organize and
retrieve the many objects of your application
Performance - explore many of the most common and
powerful ways to make your Symfony application even faster
Internals - an in-depth explanation of the Symfony2
internals
The Symfony2 Stable API - a subset of all Symfony2
published public methods (components and core bundles)
This book is licensed under the Attribution-Share Alike
3.0 Unported license.
This online e-book covers all aspects of PHP
programming. It begins with a brief history of PHP, then gives an
overview of PHP, and why it is so useful to web programmers. Subsequent
chapters cover all areas of PHP in detail: the basics of the language,
file and filesystem handling, object oriented programming, MySQL and
SQLite
database access, handling of HTML forms, using cookies and PHP
sessions. All chapters are accompanied by real world examples.
Topics include:
The History of PHP
An Overview of PHP - a high level look at
PHP and provide a basic understanding of what it is, what is does and
how it does it
Creating a Simple PHP Script - construct the
most basic of PHP examples, and in so doing the author takes two
approaches to creating PHP powered web content: embedding PHP
into an HTML page, and embed the HTML into the PHP
Commenting PHP Code - involves writing notes
alongside the code to describe what the code does and how it works
An Introduction to PHP Variables - covers naming and
creating a variable in PHP, assigning a value to a PHP variable,
accessing PHP variable values, changing the type of a PHP variable, and
checking whether a variable is set
Understanding PHP Variable Types - looks at the PHP
integer, string, float and boolean variable types
PHP Constants - the opposite of a variable
in that once it has been defined it cannot be changed
PHP Operators - enable us to perform tasks
on variables and values such as assign, multiply, add, subtract and
concatenate them
PHP Flow Control and Looping - explores conditional
statements, looping statements, and switch statements and creates some
examples that show how to implement these mechanisms
PHP Functions
PHP Arrays - provides a way to group together
many variables such that they can be referenced and manipulated using a
single variable
Working with Strings and Text in PHP
- explores a number of the functions and techniques provided by PHP to
enable you, as a web developer, to perform tasks such as changing the
case of a string, replacing one part of a piece of text with another
piece of text, searching text and much more
PHP, Filesystems and File I/O - covers all
aspects of interacting with files and the filesystem
Working with Directories in PHP - work with
file system directories
An Overview of HTML Forms - provides a
basic grounding of HTML forms before moving on to the more PHP specific
areas of building a form
PHP and HTML Forms - create a simple HTML
form to gather information from the user and then create a PHP script
to process that data once it has been submitted to the server
PHP and Cookies - Creating, Reading and Writing
- looks at the use of cookies to maintain state,
and the use of PHP sessions as an alternative to the use of cookies. It
also provides an overview of the difference between cookies and PHP
sessions
Understanding PHP Sessions - explores the
concept of PHP sessions in more detail and provide some examples of how
to create and use sessions
PHP Object Oriented Programming - introduces
the basic concepts involved in object oriented programming and explains
the concept as it relates to PHP development
Using PHP with MySQL - how to access
information stored in a MySQL database from a PHP script and present
that data to a user's web browser
PHP and SQLite - SQLite is an embedded
database that is bundled with PHP starting with PHP 5 and implements a
large subset of the SQL 92 standard
