Databases Reference
In-Depth Information
PDO_ODBC
PDO (PHP Data Objects) is an object-oriented, standards-based data access
method in PHP, where you can use the same methodology to query the
database and fetch data from the supported databases. PDO_ODBC extension
is the implementation of the PDO specification. When compiled with DB2
libraries, you can use it to access DB2, Cloudscape™, and Apache Derby
databases. This extension provides a mechanism to connect to both local
cataloged and non-local (remote) cataloged databases. For a local cataloged
database, PDO_ODBC obtains the database server details from the client
machine. For a non-local cataloged database, the full details of the remote
database are specified in the connection URL. PDO_ODBC also provides
access to advanced features of DB2, such as persistent connections, prepared
SQL statements, large objects, and stored procedures. It provides better
performance compared to Unified ODBC functions.
Unified ODBC
Unified ODBC was the only method for PHP to talk with DB2, Cloudscape, and
Apache Derby databases before ibm_db2 or PDO_ODBC was released. Like
ibm_db2 and PDO_ODBC, this extension also interacts with DB2 using native
CLI calls. It uses the same PHP methods to interact with different databases
even if the underlying mechanism is different. But you cannot use this API to call
a stored procedure in DB2. Unified ODBC does not use the Object-Oriented
methodology.
The source code for all the extensions is available for free download in the PECL
Web site:
http://pecl.php.net/
3.3 Setting up Eclipse with PHP
Eclipse is an open source application development tool that you can download at
no charge from the following Web site:
This tool is ready to use once you download and unzip it in a folder of your
choice. There is no setup required. We advise you to make a desktop shortcut of
eclipse.exe to make the launch easy. After launching Eclipse from the desktop, it
takes you to the Welcome window where you can navigate the built-in help and
samples. The core Eclipse tool does not come with a PHP plug-in.
Search WWH ::
Custom Search