PHP - If no MySQL Connection then display simple message

Question

How can I catch and ignore errors when connecting to a database and display a simple text message instead?

My connection looks like this:

$connection = mysqli_connect($dbhost, $dbuser, $dbpw, $dbname);

If the connection fails I want it simply to echo "Error connecting to the database" instead of the big error box.

EDIT:

Although error_reporting(0) did work, what worked better was just putting '@' in front of mysqli_connect:

$connection = @mysqli_connect($dbhost, $dbuser, $dbpw, $dbname);
    if (!$connection) {
        $connection_status = 'Connection to database failed';
    } else {
        $connection_status = null;
    }

?>
<?php echo $connection_status; ?>

What big error box...?

Charlotte Dunois
– Charlotte Dunois

2016-05-22 20:25:35 +00:00
Commented May 22, 2016 at 20:25 — Charlotte Dunois
– Charlotte Dunois, Commented May 22, 2016 at 20:25

Arnold Daniels · Accepted Answer · 2016-05-22 20:27:09Z

4

Taken from the documentation of mysqli_connect:

Examples

Example #1 mysqli_connect() example

<?php
$link = mysqli_connect("127.0.0.1", "my_user", "my_password", "my_db");

if (!$link) {
    echo "Error: Unable to connect to MySQL." . PHP_EOL;
    echo "Debugging errno: " . mysqli_connect_errno() . PHP_EOL;
    echo "Debugging error: " . mysqli_connect_error() . PHP_EOL;
    exit;
}

echo "Success: A proper connection to MySQL was made! The my_db database is great." . PHP_EOL;
echo "Host information: " . mysqli_get_host_info($link) . PHP_EOL;

mysqli_close($link);
?>

answered May 22, 2016 at 20:27

Arnold Daniels

16.6k6 gold badges55 silver badges84 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Gynteniuxas · Accepted Answer · 2016-05-22 20:41:35Z

1

mysqli_connect:

$connection = mysqli_connect($dbhost, $dbuser, $dbpw, $dbname);
if (!$connection)
{
    error_reporting(0);
    die("Error: Unable to connect to MySQL." . PHP_EOL);
}

To disable "big error boxes" (I assume standart messages?), write error_reporting(0); above this.

edited May 22, 2016 at 20:41

answered May 22, 2016 at 20:25

Gynteniuxas

7,09918 gold badges41 silver badges59 bronze badges

2 Comments

Timothy Fisher Over a year ago

the error_reporting(0); does work, but is there anyway to only use error_reporting(0) for the connection? Turn them back on afterwards?

Gynteniuxas Over a year ago

Yes, you can do something like in my edit. If the if clause is true, then error_reporting() stays the same as default (or previously declared).

Nick · Accepted Answer · 2016-05-22 20:39:48Z

1

You may set your custom handler for errors

register_shutdown_function("shutdownHandler");
function shutdownHandler()
{
    if (!is_null($e = error_get_last())).
    {
        echo $e['message'];
    }
}

edited May 22, 2016 at 20:39

answered May 22, 2016 at 20:26

Nick

10.2k8 gold badges65 silver badges97 bronze badges

Collectives™ on Stack Overflow

PHP - If no MySQL Connection then display simple message

3 Answers 3

Examples

Comments

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Examples

Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related