From: [EMAIL PROTECTED]
Operating system: Unix (FreeBSD)
PHP version: 4.2.3
PHP Bug Type: MySQL related
Bug description: Functions closing mysql resources
There are two databases involved:
database1 is connected to in the main body of the page
database2 is connected to in a function
========================================================
function foo()
{
mysql_connect(Same Arguements)
db1_connection = select_db (db1)
do something
close db1_connection
}
mysql_connect(Same Arguements)
db2_connection = select_db(db2)
do something with db1
foo()
do something with db1 //**** This will fail
======================================================
The second "do something with db1 will fail with a "not a valid result
resource" error. I percieve of two possible reasons for this:
1. mysql_close(db1_connection) is closing all the links
or, most likely
2. Since mysql_connect is called with the same arguements it returns the
same resource id (I know this) then, when I close db1_connection it closes
that resource.
So, either way we have a variable scope issue. According to what I
understand about the scope rules of php the functions should have no
knowledge of my connection to db2 unless I declare it as global in the
function foo. But, it does anyway.
As an aside, I used to be able to globally include a resource id into a
function, leave it open and return from the function. Now, it appears
that when the function exits it disposes of the "global" resource in its
clean up proceedures.
--
Edit bug report at http://bugs.php.net/?id=21663&edit=1
--
Try a CVS snapshot: http://bugs.php.net/fix.php?id=21663&r=trysnapshot
Fixed in CVS: http://bugs.php.net/fix.php?id=21663&r=fixedcvs
Fixed in release: http://bugs.php.net/fix.php?id=21663&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=21663&r=needtrace
Try newer version: http://bugs.php.net/fix.php?id=21663&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=21663&r=support
Expected behavior: http://bugs.php.net/fix.php?id=21663&r=notwrong
Not enough info: http://bugs.php.net/fix.php?id=21663&r=notenoughinfo
Submitted twice: http://bugs.php.net/fix.php?id=21663&r=submittedtwice
register_globals: http://bugs.php.net/fix.php?id=21663&r=globals
PHP 3 support discontinued: http://bugs.php.net/fix.php?id=21663&r=php3
Daylight Savings: http://bugs.php.net/fix.php?id=21663&r=dst
IIS Stability: http://bugs.php.net/fix.php?id=21663&r=isapi
Install GNU Sed: http://bugs.php.net/fix.php?id=21663&r=gnused
