ID: 21209
Updated by: [EMAIL PROTECTED]
Reported By: [EMAIL PROTECTED]
-Status: Feedback
+Status: Bogus
Bug Type: MySQL related
Operating System: Windows
PHP Version: 4CVS-2002-12-26 (dev)
New Comment:
Unless you use an outdated libmysql, or mysql wasn't installed property
or a valid (default connection) already exists, mysql_error() returns
an errormessage, even if the connection failed.
Previous Comments:
------------------------------------------------------------------------
[2003-01-04 08:00:51] [EMAIL PROTECTED]
Michael note that the function states that it gives the error of the
last myqsl operation, but the note says on the page:
| Note: If the optional argument is specified the
| given link is used to retrieve the error message.
| If not, the last opened link is used.
So it implies, that if the parameter is not given,
an opened connection is needed... So the documentation
also needs to be changed.
Please do not close this bug before the mysql_error
documentation is fixed.
------------------------------------------------------------------------
[2003-01-04 05:23:49] [EMAIL PROTECTED]
Are you using the bundled version of MySQL, if not, which version?
I can't reproduce the bug in any of my systems.
Anyway changing this to a MySQL bug, and will see if it is verified.
------------------------------------------------------------------------
[2003-01-03 23:54:27] [EMAIL PROTECTED]
The manual states that mysql_error() without arguments retrieves the
error text of the last recently used MySQL function - _not_ the last
opened connection.
And that's exactly what happens at least here on Linux (tested with
4.3.0 and 4.4.0-CVS as of today).
So if the example doesn't work on Windows, it is broken on Windows. Can
you try the example on its own, without your custom error handler?
------------------------------------------------------------------------
[2003-01-03 20:37:16] [EMAIL PROTECTED]
That is not true.
Your code just produces a ``Could not connect: ''
here.
PHP Version 4.4.0-dev
System Windows NT localhost 5.1 build 2600
Build Date Dec 26 2002 20:10:08
Server API Apache
------------------------------------------------------------------------
[2003-01-03 17:25:23] [EMAIL PROTECTED]
Actually with
<?php
@mysql_connect("localhost", "mysql_user", "mysql_password") or
die("Could not connect: " . mysql_error());
?>
It returns:
Could not connect: Access denied for user: 'mysql_user@localhost'
(Using password: YES)
so using mysql_error() here is just fine, it also manages the
connections' error.
Thank you for your report.
------------------------------------------------------------------------
The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
http://bugs.php.net/21209
--
Edit this bug report at http://bugs.php.net/?id=21209&edit=1
