ID: 29019 User updated by: cyberlot at cyberlot dot net Reported By: cyberlot at cyberlot dot net Status: Open Bug Type: MySQL related Operating System: Fedora Core 2 PHP Version: 5.0.0RC3 New Comment:
narrowed the problem down further, Its directly related to me trying to extend the mysqli class. If I take out the extend it closes properly, If I put in the extend with no functions at all it does not close properly So <? $mysqli = new extend_mysqli('localhost','billing','billing','billing'); if (mysqli_connect_errno()) { printf("Connect failed: %s\n", mysqli_connect_error()); exit(); } ?> Connection does not close properly <? $mysqli = new mysqli('localhost','billing','billing','billing'); if (mysqli_connect_errno()) { printf("Connect failed: %s\n", mysqli_connect_error()); exit(); } ?> Connection does close properly. Previous Comments: ------------------------------------------------------------------------ [2004-07-05 19:39:22] cyberlot at cyberlot dot net Description: ------------ mysqli, using class interface not not closing connection at end of script unless you specificly call $mysqli->close This is a change of behavior from the normal mysql extension which does not "require" you to close connection. Reproduce code: --------------- <? $mysqli = new extend_mysqli('localhost','billing','billing','billing'); if (mysqli_connect_errno()) { printf("Connect failed: %s\n", mysqli_connect_error()); exit(); } ?> Expected result: ---------------- Every time its run it should release the database connection Actual result: -------------- Each time you run it a new db connection is done until you max out the mysql server. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=29019&edit=1