Not showing Error messages in MySQL

Anon

Hi all!

I wanted to know if there is a way i can hide mysql errors from my web. I have tried with

mysql_connect('not_a_server','us','pd')
or die ("show only this!");

but it also shows me the "Warning: MySQL Connection Failed: Unknown MySQL Server Host (not_a_server)" message.

thanks to all!

fernando MArtin
fernigcc@hotmail.com

jsagara

I think if you do this:

@$conn = mysql_connect('not_a_server','us','pd');

the error messages will be suppressed.

Anon

What exactly does the @ do?

Anon

From http://www.php.net/manual/en/features.error-handling.php

All PHP expressions can also be called with the "@" prefix, which turns off error reporting for that particular expression. If an error occurred during such an expression and the track_errors feature is enabled, you can find the error message in the global variable $php_errormsg.

Note: The @ error-control operator prefix will not disable messages that are the result of parse errors.

Warning
Currently the @ error-control operator prefix will even disable error reporting for critical errors that will terminate script execution. Among other things, this means that if you use @ to suppress errors from a certain function and either it isn't available or has been mistyped, the script will die right there with no indication as to why.

Anon

If I use the '@' to suppress errors as suggested, e.g.

@$link=mysql_connect("domain.com.au", "database", "password")
or die("--");

is there then a way to retrieve the errors so I can write them to a flat-file?

I tried:

$errorNum=mysql_errno();
$errorMessage=mysql_error();
echo $errorNum." ";
echo $errorMessage." ";

straight after the mysql_connect, but nothing was returned from these functions. So, is there a way I can retrieve these error for error logging while not having them display on the web page itself??

Thanks in advance.

DAV

Anon

Take out the die() function. After you've logged your errors, then call exit.

davidv

Jon,

I tried:

if(! @mysql_connect("BAD_hostname","Userid", "Password"))
{
echo "Database error.";
$errorNum=mysql_errno();
$errorMessage=mysql_error();
//no more processing occurs if...
$errorEnd="true";
if ($file=fopen("./errorlog.html","a"))
{
$errordate = date("Y-m-d");
$errortime = date("G:i:s");
fputs($file,"Error at $errordate $errortime. Error num: $errorNum, Message: $errorMessage ");
}
}

and at no error messages appeared on the web page and something was logged into errorlog.html, however $errorNum and $errorMessage are still empty...

What do I do?

DAV

Anon

Bizarre... I tried it on my server and it works fine (granted, I didn't write the $errorMessage and $errorNum to a file, I just echoed them).

Try it: http://www.sagara.org/test.php

Anon

It looks like something to do with your configuration. Take a peek at http://www.zend.com/manual/features.error-handling.php for more sophisticated error-handling routines.

Also, run phpinfo() and see if the track_errors feature is enabled. According to the docs, even if you prefix a PHP expression with "@", with this set you can still view the error message in the global variable $php_errormsg. I don't know how (or if!) this relates to the mysql-specific errors, though.

Good luck,

[deleted]

mysql_connect does not return an error message because mysql_error() and mysql_errno() require a connection identifier that does no exist if the connection was not created.

This won't work:

if (!$link = @mysql_conect(bladebla))
{
echo mysql_error($link); // calling mysql_error() with FALSE as an argument.
}

but this will:

if (!$result=@(bladebla, $link))
{
echo mysql_error($link);
}