ID: 46981 Updated by: [email protected] Reported By: flylink at 126 dot com -Status: Verified +Status: Assigned Bug Type: PDO related Operating System: Windows PHP Version: 5.2.8 -Assigned To: +Assigned To: abies
Previous Comments: ------------------------------------------------------------------------ [2009-02-09 13:26:10] [email protected] I can reproduce it on 5.2.9-CVS. ------------------------------------------------------------------------ [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
