Re: oracle problem in php-3.0.11 (fwd)
| From: | Thies C. Arntzen | Date: | Mon, 09 Aug 1999 13:33:58 +0000 |
| Subject: | Re: oracle problem in php-3.0.11 (fwd) | ||
| References: | 1 | Groups: | php.dev |
| Request: | Send a blank email to php-dev+get-9676@lists.php.net to get a copy of this message | ||
hi,
i cannot reproduce - please check against php-3.0.12.
regards,
tc
On Mon, 9 Aug 1999, Stig Bakken wrote:
>
>
> ---------- 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
>
>
>
> --
> PHP Development Mailing List <http://www.php.net/>
> To unsubscribe, e-mail: php-dev-unsubscribe@lists.php.net
> For additional commands, e-mail: php-dev-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net
>
>
Thies C. Arntzen "One Big-Mac, Small Fries and a Coke!"
Digital Collections Phone +49 40 235350 Fax +49 40 23535180
Hammerbrookstr. 93 20097 Hamburg / Germany