Re: How do I detect if mysql_connect failes?

At 5:22 AM +0200 4/20/01, Marcus Rasmussen wrote:

I CAN detect if an erro occours. (just some error I did) I still don't get any return from mysql_errno() or mysql_error() I don't iether get a return from mysql_errno() or mysql_error() when I do not surpress with @ (the function, mysql_connect(), then prints a message.) Guess I could surpress and write the error message myself, but I just want the original one, wich I should be able to get with mysql_error() PS. It is only mysql_connect that do it.

I think this used to be in the docs or notes, but I couldn't find it when I did a quick search. As I understand it, mysql_error() and mysql_errno() only return errors on an active connection. So, if the error occurs on mysql_connect/pconnect(), they will not return anything. So, you can do something like: $LinkId = @mysql_connect(...); if (!$LinkId) {

      call error_function('Unable to connect to database;);
      exit;

} or, more simply: $LinkId = @mysql_connect(...) or die('Unable to connect to database'); There's no way that I know of to get more details on WHY the connect failed other than not using the '@' and seeing what the mysql_connect error message does. In PHP4, you might be able to catch that message using the output buffering functions, then format that the way you want. See http://www.php.net/manual/en/ref.outcontrol.php for more info on output buffering. -steve

Marcus R. *********** REPLY SEPARATOR *********** On 20-04-01 at 12:35 David Robley wrote:

On Fri, 20 Apr 2001 12:19, Marcus Rasmussen wrote:

Hello. My question is: How do I detect if mysql_connect() failed when I'm surpressing the error message with @ like $linkid = @mysql_connect("host","user","pass"); And how do I, if it failes, get the error message? The manuel says that it: [quote]Returns a positive MySQL link identifier on success, or an error message on failure.[unquote] In my mind I should be able to detect if it returns an errormessage like this: if(!$linkid)

     $error = mysql_error();

or: if(!is_int($linkid))

     $error = mysql_error();

Noone of theese 2 types works :-(. I'm using is_int() because the manuel says that mysql_connect() returns an int. (How can it then return an error message? I thought that an error message would be some kind if string :-).) Here comes another problem, when an error occours I should be able to see the message with mysql_error() (since the linkid not contains an error message.) Marcus R.

Try testing the value of mysql_errno() and echo mysql_error accordingly. --

David Robley                        | WEBMASTER & Mail List Admin

RESEARCH CENTRE FOR INJURY STUDIES | http://www.nisu.flinders.edu.au/

AusEinet                            | http://auseinet.flinders.edu.au/

Flinders University, ADELAIDE, SOUTH AUSTRALIA

-- +---------- KDVS 90.3fm Annual Fundraiser : 16 - 22 April 2001 ----------+ | Steve Edberg University of California, Davis | | sbedberg@ucdavis.edu Computer Consultant | | http://aesric.ucdavis.edu/ http://pgfsun.ucdavis.edu/ | +----------------------------- www.kdvs.org -----------------------------+