Problème de connectivité

 
 
 <?php  
//Démarrage des sessions ( à placer avant tout autre code ! )
 session_start();  

//affichage des erreurs PHP sur la page :
error_reporting(E_ALL);
ini_set('display_errors', TRUE);
ini_set('display_startup_errors', TRUE);

 //redirection si l'utilisateur est déjà connecté
 if(isset($_SESSION["username"])) {  
  header("location:dashboard/dashboard.php");  
 } 
 
//connexion à la bdd 
require_once  "inc/eldb.php"; 
 
 
//récupération PROPRE des variables AVANT de les utiliser
$recaptcha = !empty($_POST['g-recaptcha-response']) ? $_POST['g-recaptcha-response'] : NULL;
$remoteip = !empty($_SERVER['REMOTE_ADDR']) ? $_SERVER['REMOTE_ADDR'] : NULL;

$login = !empty( $_POST["login"] ) ? $_POST["login"] : NULL;
$usern = !empty($_POST["usern"]) ? $_POST["usern"] : NULL;
$motdp = !empty($_POST["motdp"]) ? $_POST["motdp"] : NULL; 
//initialisation des autres variables 
$errorpost = false;
$errmessage = false;
$errorpwd = false;
$secret = "6LfLTPIUAAAAAJM0GxpimcmUXtJ16CcUdwnKsgkq";



$api_url = "https://www.google.com/recaptcha/api/siteverify?secret=" 
    . $secret
    . "&response=" . $recaptcha
    . "&remoteip=" . $remoteip ;
  
$decode = json_decode(file_get_contents($api_url), true);
$success = !empty($decode['success']) ? $decode['success'] : NULL;

 if($login) {  
    if ($success == true) {
      if(empty($usern) || empty($motdp)) {  
           $errorpost = true;
      }  else  {  
        $username = mysqli_real_escape_string($db, $usern);  
        $password = mysqli_real_escape_string($db, $motdp);  
        $query = "SELECT * 
                  FROM users 
                  WHERE uname = '$username'";  
                  
       
        // Perform a query, check for error
       if (!$result = mysqli_query($db, $query)) {
        echo("Error description: " . mysqli_error($db));
        exit;
       }
       if(mysqli_num_rows($result) > 0) {  
        while($row = mysqli_fetch_array($result))  
        {  
           if(password_verify($password, $row["password"])) {  
              //return true;  
              $_SESSION["username"] = $username;  
              setlocale (LC_TIME, 'fr_FR.utf8','fra');
              $date = strftime('%d %B %Y à %H:%M',strtotime("+6 hours"));
              try{
                $stmt = $db->prepare("UPDATE users SET lastcon = ?, lastip = ? WHERE uname = ? ");
                $uname = $username;
                $lastcon = $date;
                $stmt->bind_param("sss", $lastcon, $remoteip, $username);
                $stmt->execute();
                $stmt->close();
                header("location: dashboard/dashboard.php");
              }catch(Exception $e){
                 $errorpwd = "Erreur lors de l'enregistrement en BDD" . $db->error;
              }
           }  else  {
              $errorpwd = true;
           }  
        }  
       }  else  {  
        $errorusr = true;
      }  
    }  
   } else {
    $errmessage = true;
   }
}
?>