Ошибка в SQL запросе

<?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "vr_pro";
 
$connection = new mysqli ($servername, $username, $password, $dbname);
if ($connection->connect_error) {
    die("Connection failed: " . $connection->connect_error);
}
 
$query = $_POST['query'];
$array = explode(" ", $query);
 
$sql = "SELECT `ID` FROM `employees` WHERE `SURNAME` = '" . $array[0] . "', 
`NAME` = '" . $array[1] . "', `PATRONYMIC` = '" . $array[2] . "'";
 
$result = $connection->query($sql);
$employee = $result->fetch_assoc();
 
if (!($connection->query($sql) === TRUE)) {
   echo "Error: " . $sql . "<br>" . $connection->error;
}
 
$connection->close();
 
$new_url = 'http://localhost/vr_pro/employee.php?id=' . $employee["ID"];
header('Location: '.$new_url);
?>

$sql = "SELECT `ID` FROM `employees` WHERE
`SURNAME` = '" . $connection->real_escape_string($array[0]) . "' AND 
`NAME` = '" . $connection->real_escape_string($array[1]) . "' AND 
`PATRONYMIC` = '" . $connection->real_escape_string($array[2]) . "'";

$sql = "SELECT `ID` FROM `employees` WHERE `SURNAME` = ? AND `NAME` = ? AND `PATRONYMIC` = ?";
$result = $connection->execute_query($sql, [$array[0], $array[1], $array[2]]);
foreach ($result as $row) {
    echo  $row["ID"], '|';
}