ID: 40588 User updated by: frankpw at fw2s dot com Reported By: frankpw at fw2s dot com -Status: Feedback +Status: Open Bug Type: MySQLi related Operating System: Win XP Pro PHP Version: 5.2.1 New Comment:
Additional info: Server info: 5.0.27-community-max-nt Client info: 5.0.22 That's as close to match server and client versions as it gets. I've downloaded php_mysql.dll and php_mysqli.dll for server version 5.0.27 directly from MySQL. Please try the code below: <?php $mysqli = @mysqli_connect("localhost","root","pass",null,"abcd"); if (empty($mysqli)) die ("Connection attempt failed! " . mysqli_connect_error() . "<br />\n"); echo "Connected!<br />\n"; echo "Host info: " . mysqli_get_host_info($mysqli) . "<br />\n"; echo "Client info: " . mysqli_get_client_info() . "<br />\n"; echo "Server info: " . mysqli_get_server_info($mysqli) . "<br />\n"; echo "Protocol version: " . mysqli_get_proto_info($mysqli) . "<br />\n"; ?> For test purposes make sure that first four parameters are correct and use fifth as is. Repeat the test with "@" removed from the call to mysqli_connect(). You'll see that warning is being displayed but mysqli_connect_error() is empty and mysqli_connect_errno() == 0. Previous Comments: ------------------------------------------------------------------------ [2007-02-22 10:59:27] [EMAIL PROTECTED] Cannot reproduce. Make sure the client library is of the same version is the MySQL server. ------------------------------------------------------------------------ [2007-02-22 04:45:41] frankpw at fw2s dot com Description: ------------ In my class I'm opening a connection with mysqli_connect(). mysqli_connect_error() returns description of any error except one. If one parameter is of wrong type (i.e port as string rather than numeric). Reproduce code: --------------- public function OpenConnection($host, $user, $pass, $name = null, $port = null, $sock = null, $chrs = null) { $this->mysqli = @mysqli_connect($host, $user, $pass, $name, $port, $sock); if (empty($this->mysqli)) die ("Execution stopped! " . mysqli_connect_error() . "<br />\n"); if (!empty($chrs)) $this->DefaultCharacterSet($chrs); } Expected result: ---------------- "Execution stopped! mysqli_connect expects parameter 5 to be long, string given" Actual result: -------------- "Execution stopped!" ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=40588&edit=1