php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

Bug #46981 PDO get Data Bug for Firebird DBMS
Submitted: 2008-12-31 03:16 UTC Modified: 2010-06-13 18:42 UTC
Votes:3
Avg. Score:4.3 ± 0.5
Reproduced:2 of 2 (100.0%)
Same Version:0 (0.0%)
Same OS:0 (0.0%)
From: flylink at 126 dot com Assigned: felipe (profile)
Status: Closed Package: PDO related
PHP Version: 5.2.9 OS: Windows
Private report: No CVE-ID: None
View Add Comment Developer Edit
 [2008-12-31 03:16 UTC] 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

Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2009-01-01 01:59 UTC] kalle@php.net 
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.
 [2009-01-03 11:10 UTC] 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-02-09 13:26 UTC] felipe@php.net 
I can reproduce it on 5.2.9-CVS.
 [2010-06-13 18:42 UTC] felipe@php.net
-Status: Assigned +Status: Closed -Assigned To: abies +Assigned To: felipe
 [2010-06-13 18:42 UTC] felipe@php.net 
It was already fixed in 5.2.10. (see bug #47845)

Thanks.
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved. 		Last updated: Fri May 17 20:01:35 2024 UTC