Bug #12038 Updated: problem with closing database handles

ID: 12038 Updated by: derick@php.net Reported By: kirill@mns.ru -Status: +Status: Open Bug Type: InterBase related Operating System: RedHat 7.1 PHP Version: 4.0.6 New Comment: Thank you for taking the time to report a problem with PHP. Unfortunately your version of PHP is too old -- the problem might already be fixed. Please download a new PHP version from http://www.php.net/downloads.php If you are able to reproduce the bug with one of the latest versions of PHP, please change the PHP version on this bug report to the version you tested and change the status back to "Open". Again, thank you for your continued support of PHP. Previous Comments: ------------------------------------------------------------------------ [2001-07-11 04:26:56] kirill@mns.ru Here is warning for sample code: Warning: InterBase: invalid statement handle in /var/www/users/kirill/bug.php on line 2 ------------------------------------------------------------------------ [2001-07-11 04:25:14] kirill@mns.ru PHP reports warning about invalid statement handle after I use ibase_close() to close opened with ipbase_connect() database connection. If I comment ibase_close that removes this warning (all this code must be in function to get warning,in plain use - there are no warnings in any case). I think that it's a bug in cleanup code at shutdown. <? first_connect(); function first_connect(){ $dbh = ibase_connect("localhost:/usr/interbase/data/db.gdb", "login","password", none, 100, 3, "role"); if (!$dbh) { echo "An error occured while connecting!!!\n"; exit; } else { $username = "KIRILL"; $qry = "SELECT * FROM GETUSERROLE('$username')"; $sth = ibase_query ($dbh, $qry); while ($row = ibase_fetch_object ($sth)){} ibase_close($dbh); } } ?> './configure' '--prefix=/usr' '--with-config-file-path=/etc' '--disable-debug' '--enable-pic' '--enable-shared' '--enable-inline-optimization' '--with-apxs=/usr/sbin/apxs' '--with-exec-dir=/usr/bin' '--with-regex=system' '--with-gettext' '--with-gd' '--with-jpeg-dir=/usr' '--with-png' '--with-zlib' '--with-db2' '--with-gdbm' '--enable-debugger' '--enable-magic-quotes' '--enable-safe-mode' '--enable-sockets' '--enable-sysvsem' '--enable-sysvshm' '--enable-track-vars' '--enable-yp' '--enable-ftp' '--enable-wddx' '--without-mysql' '--without-oracle' '--without-oci8' '--with-xml' '--with-mod_charset' '--without-pgsql' '--without-interbase' '--without-recode' '--without-mhash' '--without-sablot' ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=12038&edit=1