$_SESSION['error'] = ' // There is a problem in the server. Please, try again.'; } else { try { $conn = new PDO("mysql:host={$mysql_hostname};dbname={$mysql_dbname}", $mysql_username, $mysql_password); $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $stmt = $conn->prepare("SELECT idfriend, friendname, friendemail, invitation, confirmation FROM friend WHERE game_idgame = :game_id"); $stmt->bindParam(':game_id', $game->getIdgame(), PDO::PARAM_INT); $stmt->execute(); $allFriends = array(); while ($datos = $stmt->fetch()) { $friend = new Friend($datos['idfriend'], $datos['friendname'], $datos['friendemail'], $datos['invitation'], $datos['confirmation']); $allFriends[] = $friend; } $i = 0; foreach ($allFriends as $friend) { if ($friend->getConfirmation()) { $i++; } } $_SESSION['total_confirmed'] = $i; $_SESSION['numberfriends'] = count($allFriends); } catch (Exception $e) { if ($e->getCode() == 23000) { $_SESSION['error'] = $_SESSION['error']; } else { $_SESSION['error'] = $e->getCode(); } } //End Try } //End Else