mysql如果连接错误 - css在下次尝试时显示错误

Question

I have the code below to try 5 times to connect to mysql:

mysqli_report(MYSQLI_REPORT_STRICT);

$NUM_OF_ATTEMPTS = 5;
$attempts = 0;

do {
    try {
        $mysqli = new mysqli("localhost", "root", "", "data");
        break;
    }
    catch (Exception $e) {
        echo mysqli_connect_error();
        unset($mysqli);
        $attempts=$attempts+1;
        sleep(2);
        if($attempts<$NUM_OF_ATTEMPTS){
            continue;
        }
        else{
            exit;
        }
    }
break;
}while($attempts < $NUM_OF_ATTEMPTS);

what happens is, if for example, in the first try some error occur and it connects in the second the CSS will show different. the inputs smaller and things like that. What is wrong?

Answer 1

When it retries, the attempt will always be 0, try to save that in a session variable to make it last over sessions and page reloads...

session_start();    

mysqli_report(MYSQLI_REPORT_STRICT);

$NUM_OF_ATTEMPTS = 5;
$_SESSION["attempts"] = 0;

do {
    try {
        $mysqli = new mysqli("localhost", "root", "", "data");
        break;
    }
    catch (Exception $e) {
        echo mysqli_connect_error();
        unset($mysqli);
        $_SESSION["attempts"] = $_SESSION["attempts"] + 1;
        sleep(2);
        if($_SESSION["attempts"]<$NUM_OF_ATTEMPTS){
            continue;
        }
        else{
            exit;
        }
    }
break;
}while($_SESSION["attempts"] < $NUM_OF_ATTEMPTS);