 | Level: Introductory Clara Liu (claraliu@ca.ibm.com), Database Consultant
23 Jan 2003
This article shares the author's experience in developing a PHP application that accesses data in IBM DB2 Universal Database Version 8 on Linux. This sample application, called EFORM, is an online training evaluation tool. The article reviews the application framework and the development environment, then discusses some of the things the author learned when developing the application, including the use of the DB2 CLI tracing facility to identify problems.
If you're a regular reader of the DB2® Developer Domain, you've read about PHP: Hypertext Processor (PHP). It's an open source server-side scripting language for creating Web content, and a powerful choice for creating Web applications to access DB2 data. This article shares the author's experience in developing a PHP application that accesses data in IBM DB2 Universal Database Version 8 on Linux. This sample application, called EFORM, is an online training evaluation tool. The article reviews the application framework and the development environment, then discusses some of the things the author learned when developing the application, including the use of the DB2 CLI tracing facility to identify problems.
Highlights include:
- Application overview
- Setting up the database
- Setting up the PHP environment
- Configuring Apache to use PHP 4.0
- Handling database connections with PHP
- Using DB2 trace for problem determination
- Special considerations when updating, inserting, and retrieving large objects (LOBs)
- Unified ODBC function
Downloads | Description | Name | Size | Download method |
|---|
| Article in PDF format | 0301liu.pdf | 166 KB | FTP|HTTP |
|---|
| Code sample | eform.tar | 184 KB | FTP|HTTP |
|---|
Resources
- developerWorks DB2 zone: Learn more about DB2. You'll find technical documentation, how-to articles, education, downloads, product information, and more.
- developerWorks blogs: Get involved in the developerWorks community.
About the author | | | Clara Liu works as a DB2 UDB consultant at the IBM Toronto Laboratory. As a member of the Data Management Channel Development Team, she works closely with IBM business partners. Clara specializes in database application development and integration of new technologies with DB2. She teaches DB2 UDB certification courses to IBM business partners and at conferences. She co-authored the book DB2 SQL Procedural Language for Linux, UNIX, and Windows. You can reach Clara at claraliu@ca.ibm.com. |
Rate this content
| | | |
