Prevent Error on mysql_connect() - Access denied

Question

I have this code snippet:

$conn = mysql_connect($host, $usr, $pwd);

How can I prevent PHP from printing an error message when MySQL access is denied?

I need exactly this syntax but nothing works for me.

I tried $conn = mysql_connect($host, $usr, $pwd) or false; and $conn = mysql_connect($host, $usr, $pwd) || false; and the following:

try {
    $conn = mysql_connect($host, $usr, $pwd);

    if(!$conn) {
        throw new Exception('Failed');
    }
} catch(Exception $e) {
    // ...
}

PHP always prints an error message that the connection failed. But I just want to return false, if it failed.

Trudietrudnak

Answer 1

I don't know why you want to, but you can add a @ to surpress php errors?

see: http://php.net/manual/en/language.operators.errorcontrol.php

Seminar

Thanks, that's it! :) Didn't know that before. – Trudietrudnak

Answer 2

Error printing should not be activated on a production server. Consider changing your php.ini configuration to log error instead of displaying it.

Using @ to silent error message is not a good solution.

Locative

+1: People need to stop spattering @ everywhere. Configure your error levels properly instead. – Horsy

Answer 3

You shouldn't really be using mysql_connect in PHP 5, as its now deprecated in favour of mysqli and PDO.

But you can probably silence the warning generated by mysql_connect by prefixing with @:

@mysql_connect()

Mercedes

Answer 4

The @ suppresses errors. And also set error reporting error_reporting(0); to turn off all errors. Also check out mysqli

Docs

Andreeandrei

Don't turn off your error reporting. Instead you should configure display_errors and log_errors in your php.ini. – Chinchy