ID: 46981 Updated by: [email protected] Reported By: flylink at 126 dot com -Status: Open +Status: Feedback Bug Type: PDO related Operating System: Windows PHP Version: 5.2.8 New Comment:
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. Previous Comments: ------------------------------------------------------------------------ [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
