Re: PHP and DB2
| From: | Scott Fletcher | Date: | Fri, 10 Jan 2003 15:45:23 +0000 |
| Subject: | Re: PHP and DB2 | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-131122@lists.php.net to get a copy of this message | ||
Be care of the PHP bug on one of hte php function, odbc_fetch_row(). This
function does not very well start at 0 when the odbc_fetch_row() start
automatically, so you'll have to at the counter inside the function. Why is
that, I do not know. Here's the example of the workaround I did.
--clip--
$cid = odbc_connect('blah blah blah');
$ask7 = "SELECT * FROM INQUIRIES WHERE USER_ID = '38SCK3'";
$R7 = odbc_exec($cid,$ask7);
$result = odbc_result($R7,1);
echo "Result or No Result??? --> ".odbc_fetch_row($R7);
$bug_workaround=0;
while (odbc_fetch_row($R7,++$bug_workaround))
{
odbc_fetch_into($R7,$inquiry,$inq_c);
echo $inquiry[0], $inquiry[1];
}
--clip--
"Jack Schroeder" <jack.schroeder@bnsf.com> wrote in message
news:3E1EE24F.1DA998E4@bnsf.com...
> Can PHP connect to IMB DB2 dbms running on an AIX Unix server?
>
> Jack
>