Entry
IBM DB2 Connections to PHP under linux.
Oct 8th, 2009 04:19
osama said, games games, Aslak Berby,
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
Good luck
http://www.r4r8.com/
http://www.r4r8.com/vb/
http://www.3rabstarz.com/vb/forumdisplay.php?f=5
http://www.3rabstarz.com/vb/forumdisplay.php?f=66
http://www.3rabstarz.com/vb/forumdisplay.php?f=78
http://www.3rabstarz.com/vb/forumdisplay.php?f=116
http://www.3rabstarz.com/vb/forumdisplay.php?f=147
http://www.3rabstarz.com/vb/forumdisplay.php?f=2
http://www.3rabstarz.com/vb/forumdisplay.php?f=136
http://www.3rabstarz.com/vb/forumdisplay.php?f=89
http://www.3rabstarz.com/vb/forumdisplay.php?f=162
http://www.3rabstarz.com/vb/forumdisplay.php?f=1
http://www.3rabstarz.com/vb/forumdisplay.php?f=154
http://www.3rabstarz.com/vb/forumdisplay.php?f=34
http://www.3rabstarz.com/vb/forumdisplay.php?f=36
http://www.3rabstarz.com/vb/forumdisplay.php?f=155
http://www.3rabstarz.com/vb/forumdisplay.php?f=156
http://www.3rabstarz.com/vb/forumdisplay.php?f=157
http://www.3rabstarz.com/vb/forumdisplay.php?f=88
http://www.3rabstarz.com/vb/forumdisplay.php?f=26
http://www.3rabstarz.com/vb/forumdisplay.php?f=163
http://www.3rabstarz.com/vb/forumdisplay.php?f=164
http://www.3rabstarz.com/vb/forumdisplay.php?f=172
http://www.3rabstarz.com/vb/forumdisplay.php?f=173
http://www.3rabstarz.com/vb/forumdisplay.php?f=175
http://www.3rabstarz.com/vb/forumdisplay.php?f=72
http://www.3rabstarz.com/vb/forumdisplay.php?f=73
http://www.3rabstarz.com/vb/forumdisplay.php?f=158
http://www.3rabstarz.com/vb/forumdisplay.php?f=174
http://www.3rabstarz.com/vb/forumdisplay.php?f=148
http://www.3rabstarz.com/vb/forumdisplay.php?f=149
http://www.3rabstarz.com/vb/forumdisplay.php?f=150
http://www.3rabstarz.com/vb/forumdisplay.php?f=151
http://www.3rabstarz.com/vb/forumdisplay.php?f=152
http://www.3rabstarz.com/vb/forumdisplay.php?f=67
http://www.3rabstarz.com/vb/forumdisplay.php?f=62
http://www.3rabstarz.com/vb/forumdisplay.php?f=3
http://www.3rabstarz.com/vb/forumdisplay.php?f=115
http://www.3rabstarz.com/vb/forumdisplay.php?f=76
http://www.3rabstarz.com/vb/forumdisplay.php?f=77
http://www.3rabstarz.com/vb/forumdisplay.php?f=37
http://www.3rabstarz.com/vb/forumdisplay.php?f=63
http://www.3rabstarz.com/vb/forumdisplay.php?f=153
http://www.3rabstarz.com/vb/forumdisplay.php?f=122
http://www.3rabstarz.com/vb/forumdisplay.php?f=118
http://www.3rabstarz.com/vb/forumdisplay.php?f=119
http://www.3rabstarz.com/vb/forumdisplay.php?f=120
http://www.3rabstarz.com/vb/forumdisplay.php?f=159
http://www.3rabstarz.com/vb/forumdisplay.php?f=64
http://www.3rabstarz.com/vb/forumdisplay.php?f=65
http://www.3rabstarz.com/vb/forumdisplay.php?f=6
http://www.3rabstarz.com/vb/forumdisplay.php?f=7
http://www.3rabstarz.com/vb/forumdisplay.php?f=9
http://www.3rabstarz.com/vb/forumdisplay.php?f=11
http://www.3rabstarz.com/vb/forumdisplay.php?f=142
http://www.3rabstarz.com/vb/forumdisplay.php?f=143
http://www.3rabstarz.com/vb/forumdisplay.php?f=140
http://www.3rabstarz.com/vb/forumdisplay.php?f=146
http://www.3rabstarz.com/vb/forumdisplay.php?f=145
http://www.3rabstarz.com/vb/forumdisplay.php?f=51
http://www.3rabstarz.com/vb/forumdisplay.php?f=137
http://www.3rabstarz.com/vb/forumdisplay.php?f=113
http://www.3rabstarz.com/vb/forumdisplay.php?f=114
http://www.3rabstarz.com/vb/forumdisplay.php?f=117
http://www.3rabstarz.com/vb/forumdisplay.php?f=160
http://www.3rabstarz.com/vb/forumdisplay.php?f=165
http://www.3rabstarz.com/vb/forumdisplay.php?f=166
http://www.3rabstarz.com/vb/forumdisplay.php?f=167
http://www.3rabstarz.com/vb/forumdisplay.php?f=168
http://www.3rabstarz.com/vb/forumdisplay.php?f=169
http://www.3rabstarz.com/vb/forumdisplay.php?f=170
http://www.3rabstarz.com/vb/forumdisplay.php?f=171
http://www.3rabstarz.com/vb/forumdisplay.php?f=84
http://www.3rabstarz.com/vb/forumdisplay.php?f=138
http://www.3rabstarz.com/vb/forumdisplay.php?f=139
http://www.3rabstarz.com/vb/forumdisplay.php?f=15
http://www.3rabstarz.com/vb/forumdisplay.php?f=59
http://www.3rabstarz.com/vb/forumdisplay.php?f=60
http://www.3rabstarz.com/vb/forumdisplay.php?f=176
http://www.3rabstarz.com/vb/forumdisplay.php?f=177
http://www.3rabstarz.com/vb/forumdisplay.php?f=130
http://www.3rabstarz.com/vb/forumdisplay.php?f=97
http://www.3rabstarz.com/vb/forumdisplay.php?f=102
http://www.3rabstarz.com/vb/forumdisplay.php?f=103
http://www.3rabstarz.com/vb/forumdisplay.php?f=101
http://www.3rabstarz.com/vb/forumdisplay.php?f=104
http://www.3rabstarz.com/vb/forumdisplay.php?f=131
http://www.3rabstarz.com/vb/forumdisplay.php?f=161
http://www.3rabstarz.com/vb/forumdisplay.php?f=99
http://www.3rabstarz.com/vb/forumdisplay.php?f=39
http://www.3rabstarz.com/vb/forumdisplay.php?f=40
http://www.3rabstarz.com/vb/forumdisplay.php?f=42
http://www.3rabstarz.com
http://www.dir.3rabstarz.com
http://www.up.3rabstarz.com
http://www.3rabstarz.com
http://www.f01h.com/
http://www.f01h.com/vb
http://www.f01h.com/chat
