#50772 [NEW]: mysqli constructor without parameters does not return a working mysqli object

From: elmo dot allen at iki dot fi Operating system: Windows 7 PHP version: 5.3.1 PHP Bug Type: MySQLi related Bug description: mysqli constructor without parameters does not return a working mysqli object Description: ------------ Documentation states that calling mysqli::__construct() without parameters (i.e. new mysqli()) should do the same as calling mysqli_init(). It does not, however, return a working mysqli object, but all the following calls to its methods only return Warning "Couldn't fetch mysqli". Using mysqli_init() directly works as intended, but using it makes making derived mysqli classes much harder, if trying to use real_connect(), because derived classes can only call their parent's constructor, not mysqli_init(). The following code is by design trying a connection and failing (with MySQL server not running) and gracefully admitting it with an error message (warnings not tried to be silenced here). Not working in PHP 5.2.8 either. No newer snapshots for Windows seem to be available. Reproduce code: --------------- <?php // Does not return a working object $db1 = new mysqli(); // These calls fail $db1->options(MYSQLI_OPT_CONNECT_TIMEOUT, 3); $db1->real_connect("localhost"); if(mysqli_connect_error()) echo "error 1"; else echo "ok 1"; // This works $db2 = mysqli_init(); // And these calls work as intended (give correct error msgs when connection fails) $db2->options(MYSQLI_OPT_CONNECT_TIMEOUT, 3); $db2->real_connect("localhost"); if(mysqli_connect_error()) echo "error 2"; else echo "ok 2"; ?> Expected result: ---------------- Warning: mysqli::real_connect() [mysqli.real-connect]: [2002] A connection attempt failed because the connected party did not (trying to connect via tcp://localhost:3306) in C:\Users\Elmo\Documents\Web server\test.php on line 7 Warning: mysqli::real_connect() [mysqli.real-connect]: (HY000/2002): A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond. in C:\Users\Elmo\Documents\Web server\test.php on line 7 error 1 Warning: mysqli::real_connect() [mysqli.real-connect]: [2002] A connection attempt failed because the connected party did not (trying to connect via tcp://localhost:3306) in C:\Users\Elmo\Documents\Web server\test.php on line 13 Warning: mysqli::real_connect() [mysqli.real-connect]: (HY000/2002): A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond. in C:\Users\Elmo\Documents\Web server\test.php on line 13 error 2 Actual result: -------------- Warning: mysqli::options() [mysqli.options]: Couldn't fetch mysqli in C:\Users\Elmo\Documents\Web server\test.php on line 6 Warning: mysqli::real_connect() [mysqli.real-connect]: Couldn't fetch mysqli in C:\Users\Elmo\Documents\Web server\test.php on line 7 ok 1 Warning: mysqli::real_connect() [mysqli.real-connect]: [2002] A connection attempt failed because the connected party did not (trying to connect via tcp://localhost:3306) in C:\Users\Elmo\Documents\Web server\test.php on line 13 Warning: mysqli::real_connect() [mysqli.real-connect]: (HY000/2002): A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond. in C:\Users\Elmo\Documents\Web server\test.php on line 13 error 2 -- Edit bug report at http://bugs.php.net/?id=50772&edit=1 -- Try a snapshot (PHP 5.2): http://bugs.php.net/fix.php?id=50772&r=trysnapshot52 Try a snapshot (PHP 5.3): http://bugs.php.net/fix.php?id=50772&r=trysnapshot53 Try a snapshot (PHP 6.0): http://bugs.php.net/fix.php?id=50772&r=trysnapshot60 Fixed in SVN: http://bugs.php.net/fix.php?id=50772&r=fixed Fixed in SVN and need be documented: http://bugs.php.net/fix.php?id=50772&r=needdocs Fixed in release: http://bugs.php.net/fix.php?id=50772&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=50772&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=50772&r=needscript Try newer version: http://bugs.php.net/fix.php?id=50772&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=50772&r=support Expected behavior: http://bugs.php.net/fix.php?id=50772&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=50772&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=50772&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=50772&r=globals PHP 4 support discontinued: http://bugs.php.net/fix.php?id=50772&r=php4 Daylight Savings: http://bugs.php.net/fix.php?id=50772&r=dst IIS Stability: http://bugs.php.net/fix.php?id=50772&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=50772&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=50772&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=50772&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=50772&r=mysqlcfg