php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #32239 ibase_fetch_* can?t work with ibase_execute() result resource
Submitted: 2005-03-09 00:13 UTC Modified: 2005-03-09 14:33 UTC
From: j-pieper at web dot de Assigned:
Status: Closed Package: InterBase related
PHP Version: 5.0.3 OS: Windows XP Prof.
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: j-pieper at web dot de
New email:
PHP Version: OS:

 

 [2005-03-09 00:13 UTC] j-pieper at web dot de
Description:
------------
When I am using ibase_execute to execute an query i can?t use one of the ibase_fetch_* functions. I always get the same error.

-- php.ini: --
extension=php_interbase.dll

-- Database: --

table: FOOBAR
------
| ID |
------
|  1 |
------

Reproduce code:
---------------
<?php

    $link = ibase_connect('...', '...', '...');

    $sql = "SELECT * FROM FOOBAR";
    $query = ibase_prepare($sql);
    $result = ibase_execute($query);

    // Variant 1
    $foo = ibase_fetch_assoc($result);

    // Variant 2
    $foo = ibase_fetch_object($result);

    // Variant 3
    $foo = ibase_fetch_row($result);

?>

Expected result:
----------------
Array
(
    [0] => 1
)

Actual result:
--------------
Variant 1:
Warning:  ibase_fetch_assoc(): 5 is not a valid Firebird/InterBase result resource

Variant 2:
Warning:  ibase_fetch_object(): 5 is not a valid Firebird/InterBase result resource in

Variant 3:
Warning:  ibase_fetch_row(): 5 is not a valid Firebird/InterBase result resource

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2005-03-09 00:37 UTC] sniper@php.net
Please try using this CVS snapshot:

  http://snaps.php.net/php5-latest.tar.gz
 
For Windows:
 
  http://snaps.php.net/win32/php5-win32-latest.zip


 [2005-03-09 14:34 UTC] j-pieper at web dot de
I found the problem. I have to use ibase_prepare() [$query] for the ibase_fetch_* functions and not ibase_execute() [$result].

By the way:
http://de2.php.net/manual/de/function.ibase-execute.php

In one of the comments the result resource of ibase_execute() is be used for ibase_fetch_row().
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Thu Dec 26 12:01:30 2024 UTC