oracle problem in php-3.0.11 (fwd)
| From: | Stig Bakken | Date: | Mon, 09 Aug 1999 13:17:31 +0000 |
| Subject: | oracle problem in php-3.0.11 (fwd) | ||
| Groups: | php.dev | ||
| Request: | Send a blank email to php-dev+get-9674@lists.php.net to get a copy of this message | ||
---------- Forwarded message ----------
Date: Tue, 3 Aug 1999 14:8:47 +0800
From: wangjp <wangjp@yidong.net.cn>
To: "ssb@guardian.no" <ssb@guardian.no>
Subject: oracle problem in php-3.0.11
Hi,
sorry to bother you.
Below is the php scripts that get some rows from emp table in oracle8.0.4 database.
<?
$user="scott";
$password="tiger";
putenv("ORACLE_SID=ora8");
putenv("ORACLE_HOME=/u01/app/oracle/product/8.0.4");
$connection =OCILogon($user,$password);
$query = "select * from emp";
$statement = OCIParse($connection,$query);
$ret = OCIExecute($statement);
$col = OCIFetchinto($statement,&$row);
while ($col)
{
echo " User name:".$row[1];
echo "<br>";
$col = OCIFetchinto($statement,&$row);
}
?>
this works fine under php-3.0.7,below is the result:
User name: Jacky
User name: Mike
User name: Lily
User name: Scott
User name: Bill
User name: John
User name: Alice
but if it was parsed by php-3.0.11,the result like this:
User name:
User name: Mike
User name:
User name: Scott
User name:
User name: John
User name:
it is so strange that some odd row's name disappeared .
anyone encounter this situation before?Is it a bug in php3.0.11 with OCI function?
any advice will be appreciate.
Wang at: wangjp@yidong.net.cn