$post = $_POST["post"]; $debut = $_POST["debut"]; $fin = $_POST["fin"]; try { $guard_id = $service->getGuardId($guard); $poste_id = $service->getPostId($post); $stmt = $service->runQuery("SELECT poste_id, guard_id FROM guardtours WHERE poste_id=:poste_id OR guard_id=:guard_id"); $stmt->execute(array(':poste_id' => $poste_id, ":guard_id" => $guard_id)); $row = $stmt->fetch(PDO::FETCH_ASSOC); if ($row['poste_id'] == $poste_id) { $error[] = "sorry this post already taken !"; } else { if ($row['guard_id'] == $guard_id) { $error[] = "sorry this guard already taken !"; } else { $service->registerTools($heure, $interval, $debut, $fin, $guard_id, $poste_id); } } } catch (PDOException $e) { echo $e->getMessage(); } } ?> <!DOCTYPE html> <html lang="en"> <head> <meta charset="utf-8"> <title>Tools</title> <meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=1.0, user-scalable=no">