php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #6421 PEAR - error emulating prepare/execute with PostgreSQL
Submitted: 2000-08-29 14:51 UTC Modified: 2001-06-01 15:30 UTC
From: heino at bigfoot dot com Assigned:
Status: Closed Package: Unknown/Other Function
PHP Version: 4.0 Latest CVS (29/08/2000) OS: Debian 2.2
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: heino at bigfoot dot com
New email:
PHP Version: OS:

 

 [2000-08-29 14:51 UTC] heino at bigfoot dot com
What does the following line in DB/common.php do ?

(line 182:) $stmt = (int)$this->prepare_maxstmt++;

I have to outcomment the line when I recall execute() on the same prepared query! 

In the original code $realquery, in execute(), is set to the following string when calling it again with the same prepared query...

[db_error: message="DB Error: invalid" code=-8 mode=return level=notice prefix="" prepend="" append=""]



--------------------------------
example:


<?php

include("/usr/lib/php4/DB/pgsql.php");

$dsn = 'pgsql://127.0.0.1/web';

$db = new DB_pgsql();
$db->connect($dsn);

$stm = $db->prepare('SELECT * FROM pg_type WHERE typname = ? ORDER BY typname;');

$r1 = $db->execute($stm, array('_point'));
$r2 = $db->execute($stm, array('_bit'));

while($b = $db->fetchrow($r1)) {
    echo $b[0].' - '.$b[1].'<br>';
}

while($b = $db->fetchrow($r2)) {
    echo $b[0].' - '.$b[1].'<br>';
}

?>

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2001-05-07 13:08 UTC] sbergmann@php.net
Have you tried a newer version of PEAR/DB, for instance the one that ships with PHP 4.0.5?
 [2001-06-01 15:30 UTC] sniper@php.net
No feedback, assumed fixed in recent versions.

 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Thu Oct 10 11:01:27 2024 UTC