ID: 46981
Updated by: [email protected]
Reported By: flylink at 126 dot com
-Status: Open
+Status: Verified
Bug Type: PDO related
Operating System: Windows
PHP Version: 5.2.8
New Comment:
I can reproduce it on 5.2.9-CVS.
Previous Comments:
------------------------------------------------------------------------
[2009-01-03 11:10:49] flylink at 126 dot com
Maybe it is not clear from my last description, please read the
following:
In PHP script, when access Firbird database with PDO drive and get
the data from a reslut set by executing SQL qury sentence when there is
a result set, the first row data is null.
------------------------------------------------------------------------
[2009-01-01 01:59:15] [email protected]
Not enough information was provided for us to be able
to handle this bug. Please re-read the instructions at
http://bugs.php.net/how-to-report.php
If you can provide more information, feel free to add it
to this bug and change the status back to "Open".
Thank you for your interest in PHP.
------------------------------------------------------------------------
[2008-12-31 03:16:01] flylink at 126 dot com
Description:
------------
I use PDO driver to access Firebird DBMS,
find a bug,I couldn't get first row's data
Reproduce code:
---------------
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd";>
<html xmlns="http://www.w3.org/1999/xhtml";>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>PDO for Firebird</title>
</head>
<body>
<?php
$host='localhost';
$dbname='newsite';
$user='SYSDBA';
$pass='masterkey';
$dsn="firebird:dbname=$dbname;host=$host;charset=NONE";
$dbConn= new PDO($dsn, $user, $pass);
print "<br />PDO BUG for Firebird:<br />";
$sql='SELECT * from link';
$rs=$dbConn->query($sql);
foreach ($rs as $row) { print "1==>".$row[1]."
2==>".$row['SITELINK']."<br />"; }
$dbConn=NULL;
?>
</body>
</html>
Expected result:
----------------
PDO BUG for Firebird:
1==>Firebird 2==>http://www.firebirdsql.org
1==>?Ìò±SDN 2==>http://www.csdn.net
1==>???í¼¾ 2==>http://firebird.dearinfo.com/
1==>IBPhoenix 2==>http://www.ibphoenix.com
1==>??Ô½PHP 2==>http://www.phpe.net
1==>Fracle-Janus Soft 2==>http://www.janus-software.com
1==>FirebirdÖÎɧǸ 2==>http://www.firebird.net.cn
1==>?ãÊ?Í?Ð×Ѷ 2==>http://www.it136.net
1==>DelphiÔ°?Ø 2==>http://www.delphifans.com
1==>Delphi K.TopÓÕ?^ 2==>http://delphi.ktop.com.tw
1==>DotNetFirebird 2==>http://www.dotnetfirebird.org/
1==>Firebird?ٷ?͸վ 2==>http://www.firebirdsql.org/
1==>Î?IJ??Í 2==>http://blog.csdn.net/jianlei/
1==>DelphiÒ¤?? 2==>http://www.51delphi.com
1==>Delphi?ÐÓ 2==>http://www.2ccc.com
1==>??͸ҳ 2==>http://www.destructor.de/firebird/index.htm
1==>???UÅ 2==>http://jianlei.ys168.com
Actual result:
--------------
PDO BUG for Firebird:
1==> 2==>
1==>?Ìò±SDN 2==>http://www.csdn.net
1==>???í¼¾ 2==>http://firebird.dearinfo.com/
1==>IBPhoenix 2==>http://www.ibphoenix.com
1==>??Ô½PHP 2==>http://www.phpe.net
1==>Fracle-Janus Soft 2==>http://www.janus-software.com
1==>FirebirdÖÎɧǸ 2==>http://www.firebird.net.cn
1==>?ãÊ?Í?Ð×Ѷ 2==>http://www.it136.net
1==>DelphiÔ°?Ø 2==>http://www.delphifans.com
1==>Delphi K.TopÓÕ?^ 2==>http://delphi.ktop.com.tw
1==>DotNetFirebird 2==>http://www.dotnetfirebird.org/
1==>Firebird?ٷ?͸վ 2==>http://www.firebirdsql.org/
1==>Î?IJ??Í 2==>http://blog.csdn.net/jianlei/
1==>DelphiÒ¤?? 2==>http://www.51delphi.com
1==>Delphi?ÐÓ 2==>http://www.2ccc.com
1==>??͸ҳ 2==>http://www.destructor.de/firebird/index.htm
1==>???UÅ 2==>http://jianlei.ys168.com
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=46981&edit=1
