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.

score 10 · Answer 1 · answered Sep 20 '11 at 12:44

10

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.

answered Sep 20 '11 at 12:44

grunk

14,718
15
67
108

4

+1: People need to **stop** spattering `@` everywhere. Configure your error levels properly instead. – Lightness Races in Orbit Sep 20 '11 at 12:48

score 6 · Accepted Answer · answered Sep 20 '11 at 12:41

6

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

answered Sep 20 '11 at 12:41

Nanne

64,065
16
119
163

Thanks, that's it! :) Didn't know that before. – headacheCoder Sep 20 '11 at 12:48

score 3 · Answer 3 · answered Sep 20 '11 at 12:42

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()

answered Sep 20 '11 at 12:42

JamesHalsall

13,224
4
41
66

score 0 · Answer 4 · answered Sep 20 '11 at 12:46

0

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

Docs

answered Sep 20 '11 at 12:46

Mob

10,958
6
41
58

Don't turn off your error reporting. Instead you should configure display_errors and log_errors in your php.ini. – Mikk Sep 20 '11 at 13:08

Prevent Error on mysql_connect() - Access denied

4 Answers4