#19884 [Opn->Bgs]: Functions close connections

ID: 19884 Updated by: cynic@php.net Reported By: darylm@magiasoftware.com -Status: Open +Status: Bogus Bug Type: MySQL related Operating System: FreeBSD && XP PHP Version: 4.2.3 New Comment: Not enough information was provided for us to be able to handle this bug. Please re-read the instructions at http://bugs.php.net/how-to-report.php If you can provide more information, feel free to add it to this bug and change the status back to "Open". Thank you for your interest in PHP. i don't think that counts as a script. you know, something that we could actually run. code, you know? and: 1. no, don't paste your whole application here. isolate the problem to the lowest line count possible. 2. *no* echo "<html><pre><font>$foo</font></pre></html>" stuff if it's not required to make the bug show up; strip anrything that's not absolutely needed. 3. it needs to be *actual code*. just waving it like this makes it harder for the developers, and you're less likely to get a speedy fix. 4. *paste* the code here: "i made a typo when i was typing it in here coz i can't use clipboard" threads are wasting resources and have the same ill effect as the previous point. the PHP developers don't enjoy finding actual bugs buried in heaps of parse errors. i hope that was explicit enough. Previous Comments: ------------------------------------------------------------------------ [2002-10-13 08:50:52] darylm@magiasoftware.com I open a connection to mysql ($conn) for use in my program. Then I call a function (FuncName) that begins with the line (global $conn). Even though there is no mysql_close($conn) statement when the function returns I no longer have a mysql connection. This causes subsequent database queries to return "mysql resource error". Therefore, it appears as though the mysql connection is being closed by the function. ------------------------------------------------------------------------ [2002-10-13 01:35:36] cynic@php.net Not enough information was provided for us to be able to handle this bug. Please re-read the instructions at http://bugs.php.net/how-to-report.php If you can provide more information, feel free to add it to this bug and change the status back to "Open". Thank you for your interest in PHP. ------------------------------------------------------------------------ [2002-10-13 00:54:19] darylm@magiasoftware.com I have many functions that use a mysql_result_resource that is declared global (i.e. global $mysql_link). For some reason after a call to those functions my mysql_connection disappears/is closed. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=19884&edit=1