Question 200935 in PHP Versions Question posted in
You can find a list of all versions here.

Php versions – How to continue execution of php code if mysqli_connect dies with fatal error "No route to host"

I have a code that do some connection to mysql server and performs some actions with results of the query. Like this:

$connection = mysqli_connect($hostname, $dbusername, $dbpassword);

if(!$connection) {
echo mysqli_connect_error();
echo "connection to server with sitemap failed";
// do another stuff
}


else {
$db_select = mysqli_select_db($connection, $dbname);
$sqlmap = "SELECT url FROM sitemap";
$resmap = mysqli_query($connection, $sqlmap);
$arraymap = array();
while ($rowmap = mysqli_fetch_array($resmap)){
  $arraymap[]  = $rowmap["url"];
}
}

Sometimes mysql server, that has an internal ip 192.168.254.1, is offline, and the script execution will stop with fatal error "No route to host". When i used php 5.6 version (and mysql_connect instead of mysqli_connect), i used and approach with

 if (!$connection) {
// do stuff for situation when mysql server is offline
}
else
{
// do stuff for situation when mysql server is online
}

to let the script continue to execute and make some other actions in sutiation when mysql server is offline. But now, in php 7.2, it just dies with fatal error. Is there a way to handle the "offline case" in php 7.2 using the mysqli_connect()?

I tried to echo mysqli_connect_error(), but again, it just dies with fatal error…

Tags:

2

Answers


  1. 0

    You should turn on mysqli error throwing with mysqli_report(MYSQLI_REPORT_ALL); and than catch it:

    mysqli_report(MYSQLI_REPORT_ALL);

try {
    $connection = mysqli_connect($hostname, $dbusername, $dbpassword);

    $db_select = mysqli_select_db($connection, $dbname);
    $sqlmap = "SELECT `url` FROM `sitemap`";
    $resmap = mysqli_query($connection, $sqlmap);
    $arraymap = [];

    while ($rowmap = mysqli_fetch_array($resmap)) {
        $arraymap[] = $rowmap["url"];
    }
} catch (Exception $e) {
    echo $e->getMessage() . PHP_EOL;
    echo 'Connection to server with sitemap failed';
}
    Login or Signup to reply.
  2. 0

    In PHP 7.2 you can use mysqli_connect_errno() function returns the last connection error. If the connection to the MySQL server fails it will check the error code 2002 meaning no route to the host so you can handle offline cases and other cases separately.

    <?php

$connection = mysqli_connect($hostname, $dbusername, $dbpassword);

if (mysqli_connect_errno()) {
    $error_code = mysqli_connect_errno();
    if ($error_code === 2002) {
        echo "Connection to MySQL server failed: No route to host";
        // Perform other actions for offline case
    } else {
        echo "Connection error: " . mysqli_connect_error();
        // Perform other actions for other connection errors
    }
} else {
    $db_select = mysqli_select_db($connection, $dbname);
    $sqlmap = "SELECT url FROM sitemap";
    $resmap = mysqli_query($connection, $sqlmap);
    $arraymap = array();
    while ($rowmap = mysqli_fetch_array($resmap)) {
        $arraymap[] = $rowmap["url"];
    }
    // Perform actions when the MySQL server is online
}

?>

    Reference: Can’t connect to MySQL server

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search