ID: 30592
Updated by: [EMAIL PROTECTED]
Reported By: v_shiray at ukr dot net
Status: Bogus
Bug Type: MySQL related
Operating System: Linux
PHP Version: 4.3.9
New Comment:
And this is NOT a bug. You're doing something wrong here, ask on
[EMAIL PROTECTED] about it. This bug system is not a forum.
Previous Comments:
------------------------------------------------------------------------
[2004-10-28 20:03:07] v_shiray at ukr dot net
Hmm. I did not say ANYTIME about opening a new link to MySQL.
It's very strange that you take care on this.
Please reread my initial submission.
I noticed about a possible 'bug' with resource freeing.
Provided source will work perfectly if
I will comment next line:
// $db2 = 0;
It's a very strange 'behaviour' as for me!
Do you think on other ?
------------------------------------------------------------------------
[2004-10-28 19:03:56] [EMAIL PROTECTED]
If you want to open a new link to a MySQL server you must specify the
4th param to mysql_connect witch is a boolean that has a default value
of FALSE.
$link_1 = mysql_connect('host', 'user', 'pass');
$link_2 = mysql_connect('host', 'user', 'pass', TRUE);
Only this is the way to create a new link to MySQL... otherwise PHP
will just return the old one... but only if mysql_connect's parrams are
the same !
This 4th param was introduced as of PHP 4.2.0.
To work on the $link_1 you should specify it...
mysql_query("SELECT ...", $link_1);
because otherwise PHP will use $link_2... akka the last opened link !
Good fortune ! I hope it's clear !
------------------------------------------------------------------------
[2004-10-28 18:36:30] v_shiray at ukr dot net
I had read manual many time before submitinig the "bug".
So as you said it's a normal behavior but it's very strange as for me.
Maybe you will have time to answer on some questions.
Why do this behaviour different between versions of PHP,
e.g 4.3.6 and 4.3.9 ?
How can I unset $db2 without triggering this "problem"?
So I may change
$db2 = 0;
to
unset($db2);
with the same effect.
------------------------------------------------------------------------
[2004-10-28 07:22:01] [EMAIL PROTECTED]
Thank you for taking the time to write to us, but this is not
a bug. Please double-check the documentation available at
http://www.php.net/manual/ and the instructions on how to report
a bug at http://bugs.php.net/how-to-report.php
See http://www.php.net/mysql_connect
------------------------------------------------------------------------
[2004-10-28 03:01:18] v_shiray at ukr dot net
MySQL 4.0.20
Problem has been detected also with
PHP 4.3.8 and 5.0.2 on the same computer
RedHat 9.0, MySQL 3.23.58, PHP 4.3.9
------------------------------------------------------------------------
The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
http://bugs.php.net/30592
--
Edit this bug report at http://bugs.php.net/?id=30592&edit=1
