php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
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
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: flylink at 126 dot com
New email:
PHP Version: OS:

 

 [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

Pull Requests

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-2025 The PHP Group
All rights reserved.
Last updated: Wed Jul 09 23:01:33 2025 UTC