Search:     Advanced search
Browse by category:
Glossary | Contact Us

Database Knowledge Base / IBM DB2 / IBM DB2 Connections to PHP under linux.

IBM DB2 Connections to PHP under linux.

Add comment
Views: 215
Votes: 2
Comments: 0
To connect IBM DB2 to PHP under linux (UNIX in general) is quite simple.

First you must install the DB2 including the software develooper kit.
(Is on teh default instalation for Linix.)

Compile PHP with the --with-ibm-db2 =/your/path/to/the/db2inst1/sqllib
option (for example: "./configure --with-pgsql --with-ibm-
db2 =/disks/8gig/home/db2ins71/sqllib --without-gd --enable-ftp --with-
apache=../apache_1.3.12  --enable-track-vars" then compile the Apache Server
like usual.

In PHP use the odbc_* function calls to do the rest.

Example:
$Link_ID=odbc_pconnect("databasename","user","Password");
$Query_ID = odbc_do($Link_ID,"SELECT a,b FROM some_sheame.some_table");
$i=1;
$res=odbc_fetch_row($Query_ID,$i);
while($res)
{
  print("A:".odbc_result($Query_ID,"a")." B:".odbc_result
($Query_ID,"b")."<BR>");
  $res=odbc_fetch_row($Query_ID,$i);
}
odbc_free_result($Query_ID );
odbc_Close($Link_ID);

PHP also instals a DB class hirachy whitch I recommend. It's default
locatet at:/usr/local/lib/php/DB.php
Reference: http://www.faqts.com/knowledge_base/view.phtml/aid/6283/fid/14
Others in this Category
document What is Data Mapping
document What is an Ad Hoc Query?



RSS