Edit report at http://bugs.php.net/bug.php?id=32098&edit=1
ID: 32098 Updated by: [email protected] Reported by: tj at primetimesolutions dot com Summary: MySQLi object connection status function -Status: Open +Status: Bogus Type: Feature/Change Request Package: MySQLi related Operating System: All PHP Version: 5.0.3 -Assigned To: +Assigned To: mysql Block user comment: N Private report: N New Comment: I don't understand. var_dump($no_connected_mysqli_object) gives you. Warning: mysqli::mysqli(): (28000/1045): Access denied for user 'root'@'localhost' (using password: YES) in /home/nixnutz/php/php-src/branches/PHP_5_3_cta/foo.php on line 2 Warning: var_dump(): Property access is not allowed yet in /home/nixnutz/php/php-src/branches/PHP_5_3_cta/foo.php on line 3 Warning: var_dump(): Property access is not allowed yet in /home/nixnutz/php/php-src/branches/PHP_5_3_cta/foo.php on line 3 Warning: var_dump(): Couldn't fetch mysqli in /home/nixnutz/php/php-src/branches/PHP_5_3_cta/foo.php on line 3 Warning: var_dump(): Couldn't fetch mysqli in /home/nixnutz/php/php-src/branches/PHP_5_3_cta/foo.php on line 3 Warning: var_dump(): Couldn't fetch mysqli in /home/nixnutz/php/php-src/branches/PHP_5_3_cta/foo.php on line 3 Warning: var_dump(): Couldn't fetch mysqli in /home/nixnutz/php/php-src/branches/PHP_5_3_cta/foo.php on line 3 Warning: var_dump(): Couldn't fetch mysqli in /home/nixnutz/php/php-src/branches/PHP_5_3_cta/foo.php on line 3 Warning: var_dump(): Couldn't fetch mysqli in /home/nixnutz/php/php-src/branches/PHP_5_3_cta/foo.php on line 3 Warning: var_dump(): Couldn't fetch mysqli in /home/nixnutz/php/php-src/branches/PHP_5_3_cta/foo.php on line 3 Warning: var_dump(): Couldn't fetch mysqli in /home/nixnutz/php/php-src/branches/PHP_5_3_cta/foo.php on line 3 Warning: var_dump(): Couldn't fetch mysqli in /home/nixnutz/php/php-src/branches/PHP_5_3_cta/foo.php on line 3 Warning: var_dump(): Couldn't fetch mysqli in /home/nixnutz/php/php-src/branches/PHP_5_3_cta/foo.php on line 3 Warning: var_dump(): Couldn't fetch mysqli in /home/nixnutz/php/php-src/branches/PHP_5_3_cta/foo.php on line 3 Warning: var_dump(): Couldn't fetch mysqli in /home/nixnutz/php/php-src/branches/PHP_5_3_cta/foo.php on line 3 object(mysqli)#1 (17) { ["affected_rows"]=> NULL ["client_info"]=> NULL ["client_version"]=> int(50007) ["connect_errno"]=> int(1045) ["connect_error"]=> string(63) "Access denied for user 'root'@'localhost' (using password: YES)" ["errno"]=> NULL ["error"]=> NULL ["field_count"]=> NULL ["host_info"]=> NULL ["info"]=> NULL ["insert_id"]=> NULL ["server_info"]=> NULL ["server_version"]=> NULL ["sqlstate"]=> NULL ["protocol_version"]=> NULL ["thread_id"]=> NULL ["warning_count"]=> NULL } And: $m = @new mysqli("localhost", "root", "rooti"); var_dump(@$m->connect_error); ixn...@linux-fuxh:~/php/php-src/branches/PHP_5_3_cta> sapi/cli/php foo.php Warning: mysqli::mysqli(): (28000/1045): Access denied for user 'root'@'localhost' (using password: YES) in /home/nixnutz/php/php-src/branches/PHP_5_3_cta/foo.php on line 2 string(63) "Access denied for user 'root'@'localhost' (using password: YES)" There's your propery. If you suppress warnings you can even access it. Previous Comments: ------------------------------------------------------------------------ [2005-02-24 23:03:11] tj at primetimesolutions dot com Description: ------------ It would be helpful and spiffy to have a function or member variable on MySQLi objects that one could use to determine if the connection was a success or failure. According to the documentation, the solution is to call the mysqli_connect_errno() function after construction of the object, but doing so sort of eliminates the "object oriented-ness" of the design, and causes sloppy code (i.e. extra variables required to store status of different connection successes, etc.). ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/bug.php?id=32098&edit=1
