ID: 9107
Updated by: jmoore
Reported By: [EMAIL PROTECTED]
Status: Analyzed
Old-Bug Type: *Function Specific
Bug Type: MySQL related
Assigned To:
Comments:
This one is MySQL Related =)
Previous Comments:
---------------------------------------------------------------------------
[2001-02-24 12:56:28] [EMAIL PROTECTED]
This is due to the fact in this case PHP doesnt make two connections to MySQL but
reuses the first one which you then close. Not sure if this should be fixed or is an
acceptable side affect to an otherwise useful piece of behaviour (stops people opening
silly amounts of connections to the same database if one is reuseable.)
James
---------------------------------------------------------------------------
[2001-02-05 04:08:49] [EMAIL PROTECTED]
Sorry the PL4 was meant to be PHP4.04Pl1 :)
---------------------------------------------------------------------------
[2001-02-05 04:06:36] [EMAIL PROTECTED]
Please Also Refer to Bug Report 9049 :
I believe I am having the same problem. I think I have worked out why tho.
I have two files.
One has a function in it.
Both files require a connection to mysql database.
Both connections use the $conn as their pointer.
If you mysql_close($conn) within the function in the second file
then it closes the $conn in the script calling the function.
So you have to remove the mysql_close from your function
and even the $conn=mysql_connect from it and just pass the
$conn as a variable to the function :
eg
function foo($conn){
$result=mysql_db_query("test","select ...",$conn);
}
called from say test.html
$conn=mysql_connect("localhost","rootme","noway");
foo($conn);
was like this :
function foo()
{
$conn=mysql_connect("localhost","rootme","noway");
## query work etc..
mysql_close($conn);
return;
}
main script :
$conn=mysql_connect("localhost","rootme","noway");
#anything in here
#call function
$wotever=foo();
$result=mysql_db_query("database","query",$conn);
the last line brings up the error about the mysql link resource being wrong as the
$conn was closed in the function but somehow closed it globally too. Which is a bit of
a pain as this was ok before upgrading to Pl4
I didnt see anything in the change file about this :L So I can only assume
this is a bug.
If you need more info from me please let me know.. Thanks for all the good work guys
:)
---------------------------------------------------------------------------
ATTENTION! Do NOT reply to this email!
To reply, use the web interface found at http://bugs.php.net/?id=9107&edit=2
--
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
