#18292 [Com]: mysql_close($link) close all connections
| From: | php at netsector dot net | Date: | Mon, 08 Mar 2004 09:47:36 +0000 |
| Subject: | #18292 [Com]: mysql_close($link) close all connections | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-56083@lists.php.net to get a copy of this message | ||
ID: 18292
Comment by: php at netsector dot net
Reported By: Beater at orgalan dot de
Status: Closed
Bug Type: MySQL related
Operating System: Windows 2000
PHP Version: 4.2.1
New Comment:
This bug appear again in PHP4.3.3 on W2k!
Previous Comments:
------------------------------------------------------------------------
[2002-07-12 01:59:02] mfischer@php.net
This bug has been fixed in CVS. You can grab a snapshot of the
CVS version at http://snaps.php.net/. In case this was a
documentation
problem, the fix will show up soon at http://www.php.net/manual/.
In case this was a PHP.net website problem, the change will show
up on the PHP.net site and on the mirror sites.
Thank you for the report, and for helping us make PHP better.
See the $new_link parameter at php.net/mysql_connect
------------------------------------------------------------------------
[2002-07-12 01:53:09] Beater at orgalan dot de
<?php
function test()
{
$link2 = mysql_connect('localhost', 'phpde', 'phpde');
var_dump($link2);
echo mysql_error();
mysql_select_db('ratbytes', $link2);
echo mysql_error();
$result = mysql_query('SELECT * FROM rb_user', $link2);
echo mysql_error();
mysql_fetch_array($result);
echo mysql_error();
mysql_close($link2);
echo mysql_error();
}
$link = mysql_connect('localhost', 'phpde', 'phpde');
var_dump($link);
echo mysql_error();
mysql_select_db('ratbytes', $link);
echo mysql_error();
test();
$result = mysql_query('SELECT * FROM rb_user', $link);
echo mysql_error();
mysql_fetch_array($result);
echo mysql_error();
mysql_close($link);
echo mysql_error();
?>
produced following output:
resource(1) of type (mysql link)
resource(1) of type (mysql link)
Warning: mysql_query(): 1 is not a valid MySQL-Link resource in
....test.php on line 25
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL
result resource in ....test.php on line 27
Warning: mysql_close(): 1 is not a valid MySQL-Link resource in
....test.php on line 29
... works fine if no link_identifier is specified (mysql_close)
<?php
$link = mysql_connect('localhost', 'phpde', 'phpde');
var_dump($link);
echo mysql_error();
mysql_select_db('ratbytes', $link);
echo mysql_error();
// start inline
$link2 = mysql_connect('localhost', 'phpde', 'phpde');
var_dump($link2);
echo mysql_error();
mysql_select_db('ratbytes', $link2);
echo mysql_error();
$result = mysql_query('SELECT * FROM rb_user', $link2);
echo mysql_error();
mysql_fetch_array($result);
echo mysql_error();
mysql_close($link2);
echo mysql_error();
// end inline
$result = mysql_query('SELECT * FROM rb_user', $link);
echo mysql_error();
mysql_fetch_array($result);
echo mysql_error();
mysql_close($link);
echo mysql_error();
?>
produced following output:
resource(1) of type (mysql link)
resource(1) of type (mysql link)
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=18292&edit=1