ID: 33613
Updated by: [EMAIL PROTECTED]
Reported By: kushmit at gmail dot com
Status: Bogus
Bug Type: MySQL related
Operating System: redhat
PHP Version: 4.3.10
New Comment:
Wow, have you actually read the code you are flaming us about?
mysql_close() does a zend_list_delete() on the connection. The handler
for a list deletion is this function:
static void _close_mysql_link(zend_rsrc_list_entry *rsrc TSRMLS_DC)
{
php_mysql_conn *link = (php_mysql_conn *)rsrc->ptr;
void (*handler) (int);
handler = signal(SIGPIPE, SIG_IGN);
mysql_close(&link->conn);
signal(SIGPIPE, handler);
efree(link);
MySG(num_links)--;
}
This calls the libmysql mysql_close() function which closes the
connection.
I guess what you are referring to is the _close_mysql_plink() function,
but that is specifically for dealing with a persistent connection which
you have to explicitly define to me persistent by calling
mysql_pconnect(). If you want full control over when you open and
close your connection you obviously shouldn't open the connection as
persistent. Use the regular mysql_connect() call and you are in
control.
Previous Comments:
------------------------------------------------------------------------
[2005-07-08 01:24:41] [EMAIL PROTECTED]
Sorry, but your problem does not imply a bug in PHP itself. For a
list of more appropriate places to ask for help using PHP, please
visit http://www.php.net/support.php as this bug system is not the
appropriate forum for asking support questions. Due to the volume
of reports we can not explain in detail here why your report is not
a bug. The support channels will be able to provide an explanation
for you.
Thank you for your interest in PHP.
RTFM. The 4th param to mysql_connect()..
------------------------------------------------------------------------
[2005-07-08 01:17:38] kushmit at gmail dot com
Description:
------------
Currently the way that mysql handles multiple DB connections on a
single server is not ready for prime time. It appears that mysql shares
all connections wth the same (or even different) parameters. Either way,
it is impossible to use PHP and mysql for serious DB apps without a way
to explicitly:
1. open a connection to a specific DB
2. use the connection PRIVATELY
3. close the connection to the specific DB
Currently, PHP and mysql do not allow this. There is a certain level of
connection sharing that ALWAYS occurs. This is extremely bad design. If
connections are implicitly shared and there is no way to establish a
private connection, then in a multiuser environment, where there are
many pieces of shared code making modifications to several databases,
it is impossible to predict what connections are "active" at a given
point in time. Relying upon a "reference count", which is essentially a
2-dimensional representation of connection status, in an environment
where multiple programs are opening and closing multiple connections to
multiple DBs results in unpredictable behavior. The whole idea that all
the Db connections on a given server should be managed by incrementing
and decrementing a counter is beyond belief IMHO - it will not work for
nay but the simplest of scripts.
In addition, the current mysql_close function DOES NOT perform the
typical housecleaning operations that would be expected of a "close"
function (all it does is decrement a DB reference count; no resources
are freed; no DB connection is actually closed). Several people have
reported this as a bug, but it keeps getting closed (?!?). IT IS A BUG.
Not being able to explicitly open and close DB connections is a HUGE
HOLE IN FUNCTIONALITY. If no one wants to fix mysql_close, the
function's name should at least be changed to
"mysql_decrease_reference_count" so people are not misled into thinking
that they can actually programmatically control DB connections...
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=33613&edit=1
