From: [EMAIL PROTECTED]
Operating system: Linux RedHat 7.3
PHP version: 4.2.3
PHP Bug Type: *Database Functions
Bug description: tableInfo() method apparently closes result set
My test skeleton of PEAR DB commands :
$conn =DB::connect("pgsql://... etc
$stmt= $conn->query($_POST[query]);
$cols= $stmt->tableInfo();
for ($i=0; $i< $ncols; $i++){
$col_name[$i]= $cols[$i][name];
$type[$i]= $cols[$i][type];
$len[$i]= $cols[$i][len];
$flags[$i]= $cols[$i][flags];
while( ($r= $stmt->fetchRow())){
. . . etc
THE PROBLEM: fetchRow() returns Null. If you interchange the order of
fetchRow() with tableInfo() no problem arises.
This is unacceptable if you want to format a query result
using information obtained from tableInfo(): you would have
to re-submit the same (possibly large) query again!
MY PHP config.nice file:
'./configure' \
'--with-apxs=/usr/local/apache/bin/apxs' \
'--with-mysql=/usr' \
'--with-pgsql=/usr/local/pgsql' \
'--with-interbase=/opt/interbase' \
'--with-db3' \
"$@"
Celio Guimaraes
[EMAIL PROTECTED]
Dec 9, 2002
--
Edit bug report at http://bugs.php.net/?id=20912&edit=1
--
Try a CVS snapshot: http://bugs.php.net/fix.php?id=20912&r=trysnapshot
Fixed in CVS: http://bugs.php.net/fix.php?id=20912&r=fixedcvs
Fixed in release: http://bugs.php.net/fix.php?id=20912&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=20912&r=needtrace
Try newer version: http://bugs.php.net/fix.php?id=20912&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=20912&r=support
Expected behavior: http://bugs.php.net/fix.php?id=20912&r=notwrong
Not enough info: http://bugs.php.net/fix.php?id=20912&r=notenoughinfo
Submitted twice: http://bugs.php.net/fix.php?id=20912&r=submittedtwice
register_globals: http://bugs.php.net/fix.php?id=20912&r=globals
PHP 3 support discontinued: http://bugs.php.net/fix.php?id=20912&r=php3
Daylight Savings: http://bugs.php.net/fix.php?id=20912&r=dst
IIS Stability: http://bugs.php.net/fix.php?id=20912&r=isapi
