addEtudiantToCoursTreatment.php

<?php
require_once("connection.php");

$result4 = $connect->query("SELECT campus FROM lieux");
$result = $connect->query("SELECT classe FROM classes");
$result2 = $connect->query("SELECT id, nom FROM users WHERE role = 'intervenant'");
$result3 = $connect->query("SELECT id, nom FROM users WHERE role = 'etudiant'");

function verifyFields($field)
{
    $classe = filter_input(INPUT_POST, "classe");
    $nom = filter_input(INPUT_POST, "etudiant");
    $intervenant_name = filter_input(INPUT_POST, "intervenant");
    $cours = filter_input(INPUT_POST, "cours");
    $lieux = filter_input(INPUT_POST, "lieux");
    $date = filter_input(INPUT_POST, "date");

    $msgReturn = "";

    switch ($field) {
        case "classe":
            if ($classe == "") {
                $msgReturn .= "Please select a class<br>";
            }
            break;
        case "etudiant":
            if ($nom == "") {
                $msgReturn .= "Please select a student<br>";
            }
            break;
        case "date":
            if ($date == "") {
                $msgReturn .= "Please select a date<br>";
            }
            break;
        case "lieux":
            if ($lieux == "") {
                $msgReturn .= "Please select location<br>";
            }
            break;
        case "cours":
            if ($cours == "") {
                $msgReturn .= "Please select the subject<br>";
            }
            break;
        case "intervenant":
            if ($intervenant_name == "") {
                $msgReturn .= "Please select the teacher<br>";
            }
            break;
    }
    return $msgReturn;
}

function checkError($post)
{
    $Error = [];
    foreach ($post as $key => $value) {
        $err = verifyFields($key);
        if (strlen($err) > 0)
            $Error[] = $err;
    }
    return $Error;
}

if (isset($_POST["date"], $_POST["classe"], $_POST["etudiant"], $_POST["lieux"], $_POST["cours"], $_POST["intervenant"])) {
    $errors = checkError($_POST);
    if (empty($errors)) {
        $date = filter_input(INPUT_POST, "date");
        $lieux = filter_input(INPUT_POST, "lieux");
            $getAdresse = $conn->prepare("SELECT * FROM lieux WHERE campus = :lieux");
            $getAdresse->execute([':lieux' => $lieux]);
            $adresseList = $getAdresse->fetchAll();
            $adresse = $adresseList[0]['adresse'];
        $cours = filter_input(INPUT_POST, "cours");
        $theme = filter_input(INPUT_POST, "theme");
        $debut_am = filter_input(INPUT_POST, "debut_am");
        $fin_am = filter_input(INPUT_POST, "fin_am");
        $debut_pm = filter_input(INPUT_POST, "debut_pm");
        $fin_pm = filter_input(INPUT_POST, "fin_pm");
        $intervenant_name = filter_input(INPUT_POST, "intervenant");
            $getId = $conn->prepare("SELECT id FROM users WHERE nom = :intervenant_name");
            $getId->execute([':intervenant_name' => $intervenant_name]);
            $details = $getId->fetchAll();
            $intervenant_id = $details[0]['id'];
        $classe = filter_input(INPUT_POST, "classe");
        $nom = filter_input(INPUT_POST, "etudiant");

        if (!$conn) {
            echo "Error: Unable to connect to MySQL." . PHP_EOL;
            echo "Debugging errno: " . mysqli_connect_errno() . PHP_EOL;
            echo "Debugging error: " . mysqli_connect_error() . PHP_EOL;
        } else {
            $sql = $conn->prepare("INSERT INTO `planning`(`id_planning`, `date`,  `lieux`, `adresse`, `cours`, `theme`, `debut_am`, `fin_am`, `debut_pm`, `fin_pm`, `intervenant_name`, `intervenant_id`, `classe`, `nom`) VALUES (NULL, :date, :lieux, :adresse, :cours, :theme, :debut_am, :fin_am, :debut_pm, :fin_pm, :intervenant_name, :intervenant_id, :classe, :nom)");
            $sql->execute([':date' => $date, ':lieux' => $lieux, ':adresse' => $adresse, ':cours' => $cours, ':theme' => $theme, ':debut_am' => $debut_am, ':fin_am' => $fin_am, ':debut_pm' => $debut_pm, ':fin_pm' => $fin_pm, ':intervenant_name' => $intervenant_name, ':intervenant_id' => $intervenant_id, ':classe' => $classe, ':nom' => $nom]);
            header('Location: addEtudiantToCours.php?id=Database updated');
        }
        // mysqli_close($conn);
    }
}