PHP 4.0 Bug #6421 Updated: PEAR - error emulating prepare/execute with PostgreSQL
| From: | sniper@php.net | Date: | Wed, 29 Nov 2000 11:51:54 +0000 |
| Subject: | PHP 4.0 Bug #6421 Updated: PEAR - error emulating prepare/execute with PostgreSQL | ||
| Groups: | php.dev | ||
| Request: | Send a blank email to php-dev+get-39529@lists.php.net to get a copy of this message | ||
ID: 6421
Updated by: sniper
Reported By: heino@bigfoot.com
Status: Open
Bug Type: Unknown/Other Function
Assigned To:
Comments:
Previous Comments:
---------------------------------------------------------------------------
[2000-08-29 14:51:55] heino@bigfoot.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>';
}
?>
---------------------------------------------------------------------------
Full Bug description available at: http://bugs.php.net/?id=6421