Skip to content
Extraits de code Groupes Projets
Sélectionner une révision Git
  • ff057c282b3a28f4f2eca3a050d0d6ebc89b7231
  • master par défaut protégée
  • tichadou2015-master-patch-52256
3 résultats

manger.py

Blame
    • Blame
    • forms.php 12,75 Kio 
    <?php

function inscription_student($bdd){

    if (!isset($_POST['name'])){

        ?>
        <form action="/pima/inscription/inscription_student.php" method="post">
            <div class="form-group form-row">
                <label for="inputFirstName" class="col-sm-2 col-form-label">Prénom</label>
                <div class="col-sm-10">
                    <input type="text" class="form-control" id="inputFirstName" name="firstname" placeholder="Prénom">
                </div>
            </div>

            <div class="form-group form-row">
                <label for="inputName" class="col-sm-2 col-form-label">Nom</label>
                <div class="col-sm-10">
                    <input type="text" class="form-control" id="inputName" name="name" placeholder="Nom">
                </div>
            </div>

            <div class="form-group form-row">
                <label for="inputEmail" class="col-sm-2 col-form-label">Adresse Mail</label>
                <div class="col-sm-10">
                    <input type="text" class="form-control" id="inputEmail" name="mail" placeholder="Adresse Mail">
                </div>
            </div>

            <div class="form-group form-row">
                <label for="inputPassword" class="col-sm-2 col-form-label">Mot de passe</label>
                <div class="col-sm-10">
                    <input type="password" class="form-control" id="inputPassword" name="mdp">
                </div>
            </div>

            <div class="form-group row">
                <label class="col-sm-2 col-form-label">Matière</label>

                <div class="col-sm-2">
                    <div class="form-check form-check-inline">
                        <input class="form-check-input" type="checkbox" id="inlineCheckbox1" value="math" name="math">
                        <label class="form-check-label" for="inlineCheckbox1">Maths</label>
                    </div>
                </div>

                <div class="col-sm-2">
                    <div class="form-check form-check-inline">
                      <input class="form-check-input" type="checkbox" id="inlineCheckbox2" value="physique" name="physique">
                      <label class="form-check-label" for="inlineCheckbox2">Physique</label>
                    </div>
                </div>

                <div class="col-sm-2">
                    <div class="form-check form-check-inline">
                      <input class="form-check-input" type="checkbox" id="inlineCheckbox3" value="chimie" name="chimie">
                      <label class="form-check-label" for="inlineCheckbox3">Chimie</label>
                    </div>
                </div>

                <div class="col-sm-2">
                    <div class="form-check form-check-inline">
                      <input class="form-check-input" type="checkbox" id="inlineCheckbox4" value="francais" name="francais">
                      <label class="form-check-label" for="inlineCheckbox4">Français</label>
                    </div>
                </div>
            </div>

            <div class="form-group row">
                <label class="col-sm-2 col-form-label">Disponibilités</label>
    
                <div class="col-sm-1">
                    <div class="form-check form-check-inline">
                        <input class="form-check-input" type="checkbox" id="inlineCheckbox21" value="lundi" name="lundi">
                        <label class="form-check-label" for="inlineCheckbox21">Lundi</label>
                    </div>
                </div>

                <div class="col-sm-1">
                    <div class="form-check form-check-inline">
                      <input class="form-check-input" type="checkbox" id="inlineCheckbox22" value="mardi" name="mardi">
                      <label class="form-check-label" for="inlineCheckbox22">Mardi</label>
                    </div>
                </div>

                <div class="col-sm-2">
                    <div class="form-check form-check-inline">
                      <input class="form-check-input" type="checkbox" id="inlineCheckbox23" value="mercredi" name="mercredi">
                      <label class="form-check-label" for="inlineCheckbox23">Mercredi</label>
                    </div>
                </div>

                <div class="col-sm-1">
                    <div class="form-check form-check-inline">
                      <input class="form-check-input" type="checkbox" id="inlineCheckbox24" value="jeudi" name="jeudi">
                      <label class="form-check-label" for="inlineCheckbox24">Jeudi</label>
                    </div>
                </div>

                <div class="col-sm-2">
                    <div class="form-check form-check-inline">
                      <input class="form-check-input" type="checkbox" id="inlineCheckbox25" value="vendredi" name="vendredi">
                      <label class="form-check-label" for="inlineCheckbox25">Vendredi</label>
                    </div>
                </div>

                <div class="col-sm-1">
                    <div class="form-check form-check-inline">
                      <input class="form-check-input" type="checkbox" id="inlineCheckbox26" value="samedi" name="samedi">
                      <label class="form-check-label" for="inlineCheckbox26">Samedi</label>
                    </div>
                </div>

                <div class="col-sm-1">
                    <div class="form-check form-check-inline">
                      <input class="form-check-input" type="checkbox" id="inlineCheckbox27" value="dimanche" name="dimanche">
                      <label class="form-check-label" for="inlineCheckbox27">Dimanche</label>
                    </div>
                </div>
            </div>

            <div class="form-group form-row">
                <div class="offset-sm-2">
                    <!-- <button type="submit">S'inscrire</button> -->
                    <input type="submit" value="S'inscrire">
                </div>
            </div>
        </form>
        <?php
    }

    if (isset($_POST['name'])){
        $firstname = $_POST['firstname'];
        $name = $_POST['name'];
        $type = "Student";
        $mail = $_POST['mail'];
        $mdp = $_POST['mdp'];

        $sql = "INSERT INTO users(firstname,name,type,mail,mdp) values (?,?,?,?,?)";
        $bdd->prepare($sql)->execute([$firstname,$name,$type,$mail,$mdp]);
    
        $sql="SELECT * FROM users";
        $res = $bdd->query($sql)->fetchAll(\PDO::FETCH_OBJ);
        foreach($res as $r){
            $id = $r->ID;
        }


        if (isset($_POST['math'])){
            $sql = "INSERT INTO subjects(ID,subject) values (?,?)";
            $bdd->prepare($sql)->execute([$id,'Math']);
        }
        if (isset($_POST['physique'])){
            $sql = "INSERT INTO subjects(ID,subject) values (?,?)";
            $bdd->prepare($sql)->execute([$id,'Physique']);
        }
        if (isset($_POST['chimie'])){
            $sql = "INSERT INTO subjects(ID,subject) values (?,?)";
            $bdd->prepare($sql)->execute([$id,'Chimie']);
        }
        if (isset($_POST['francais'])){
            $sql = "INSERT INTO subjects(ID,subject) values (?,?)";
            $bdd->prepare($sql)->execute([$id,'Français']);
        }


        if (isset($_POST['lundi'])){
            $sql = "INSERT INTO dispos(ID,dispo) values (?,?)";
            $bdd->prepare($sql)->execute([$id,'lundi']);
        }
        if (isset($_POST['mardi'])){
            $sql = "INSERT INTO dispos(ID,dispo) values (?,?)";
            $bdd->prepare($sql)->execute([$id,'mardi']);
        }
        if (isset($_POST['mercredi'])){
            $sql = "INSERT INTO dispos(ID,dispo) values (?,?)";
            $bdd->prepare($sql)->execute([$id,'mercredi']);
        }
        if (isset($_POST['jeudi'])){
            $sql = "INSERT INTO dispos(ID,dispo) values (?,?)";
            $bdd->prepare($sql)->execute([$id,'jeudi']);
        }
        if (isset($_POST['vendredi'])){
            $sql = "INSERT INTO dispos(ID,dispo) values (?,?)";
            $bdd->prepare($sql)->execute([$id,'vendredi']);
        }
        if (isset($_POST['samedi'])){
            $sql = "INSERT INTO dispos(ID,dispo) values (?,?)";
            $bdd->prepare($sql)->execute([$id,'samedi']);
        }
        if (isset($_POST['dimanche'])){
            $sql = "INSERT INTO dispos(ID,dispo) values (?,?)";
            $bdd->prepare($sql)->execute([$id,'dimanche']);
        }

        echo "<p>Inscription faite!</p>";
    }
}

function inscription_teacher($bdd){
    if (!isset($_POST['name'])){
        echo "<form action=\"/pima/inscription/inscription_teacher.php\" method=\"post\">
        <p>Prénom: <input type=\"text\" name=\"firstname\"></p>
        <p>Nom: <input type=\"text\" name=\"name\"></p>
        <p>Mot de passe: <input type=\"password\" name=\"mdp\"></p>

        <p>Matières: Math <input type=\"checkbox\" name=\"math\">
        Physique <input type=\"checkbox\" name=\"physique\">
        Chimie <input type=\"checkbox\" name=\"chimie\">
        Français <input type=\"checkbox\" name=\"francais\" Checked></p>
            <p>Dispos: Lundi <input type=\"checkbox\" name=\"lundi\">
        Mardi <input type=\"checkbox\" name=\"mardi\">
        Mercredi <input type=\"checkbox\" name=\"mercredi\">
        Jeudi <input type=\"checkbox\" name=\"jeudi\">
        Vendredi <input type=\"checkbox\" name=\"vendredi\">
        samedi <input type=\"checkbox\" name=\"samedi\">
        Dimanche <input type=\"checkbox\" name=\"dimanche\"></p>
        <input type=\"submit\" value='S\'inscrire'></form>";
    }

    if (isset($_POST['name'])){
        $firstname = $_POST['firstname'];
        $name = $_POST['name'];
        $type = "Teacher";
        $mail = $_POST['mail'];
        $mdp = $_POST['mdp'];

        $sql = "INSERT INTO users(firstname,name,type,mail,mdp) values (?,?,?,?,?)";
        $bdd->prepare($sql)->execute([$firstname,$name,$type,$mail,$mdp]);

        $sql="SELECT * FROM users";
        $res = $bdd->query($sql)->fetchAll(\PDO::FETCH_OBJ);
        foreach($res as $r){
            $id = $r->ID;
        }


        if (isset($_POST['math'])){
            $sql = "INSERT INTO subjects(ID,subject) values (?,?)";
            $bdd->prepare($sql)->execute([$id,'Math']);
        }
        if (isset($_POST['physique'])){
            $sql = "INSERT INTO subjects(ID,subject) values (?,?)";
            $bdd->prepare($sql)->execute([$id,'Physique']);
        }
        if (isset($_POST['chimie'])){
            $sql = "INSERT INTO subjects(ID,subject) values (?,?)";
            $bdd->prepare($sql)->execute([$id,'Chimie']);
        }
        if (isset($_POST['francais'])){
            $sql = "INSERT INTO subjects(ID,subject) values (?,?)";
            $bdd->prepare($sql)->execute([$id,'Français']);
        }


        if (isset($_POST['lundi'])){
            $sql = "INSERT INTO dispos(ID,dispo) values (?,?)";
            $bdd->prepare($sql)->execute([$id,'lundi']);
        }
        if (isset($_POST['mardi'])){
            $sql = "INSERT INTO dispos(ID,dispo) values (?,?)";
            $bdd->prepare($sql)->execute([$id,'mardi']);
        }
        if (isset($_POST['mercredi'])){
            $sql = "INSERT INTO dispos(ID,dispo) values (?,?)";
            $bdd->prepare($sql)->execute([$id,'mercredi']);
        }
        if (isset($_POST['jeudi'])){
            $sql = "INSERT INTO dispos(ID,dispo) values (?,?)";
            $bdd->prepare($sql)->execute([$id,'jeudi']);
        }
        if (isset($_POST['vendredi'])){
            $sql = "INSERT INTO dispos(ID,dispo) values (?,?)";
            $bdd->prepare($sql)->execute([$id,'vendredi']);
        }
        if (isset($_POST['samedi'])){
            $sql = "INSERT INTO dispos(ID,dispo) values (?,?)";
            $bdd->prepare($sql)->execute([$id,'samedi']);
        }
        if (isset($_POST['dimanche'])){
                $sql = "INSERT INTO dispos(ID,dispo) values (?,?)";
            $bdd->prepare($sql)->execute([$id,'dimanche']);
        }

        echo "<p>Inscription faite!</p>";
    }
}

function connection($bdd){
    ?>

    <form action="/pima/connection/connection.php" method='post'>
        <div class="form-group form-row">
            <label for="inputMail" class="col-sm-2 col-form-label">Adresse Mail</label>
            <div class="col-sm-10">
                <input type='text' class="form-control" id="inputMail" name='mail' placeholder="Adresse Mail">
            </div>
        </div>

        <div class="form-group form-row">
            <label for="inputMdp" class="col-sm-2 col-form-label">Mot de passe</label>
            <div class="col-sm-10">
                <input type="password" class="form-control" id="inputMdp" name="mdp">
            </div>
        </div>

        <div class="form-group form-row">
            <div class="offset-sm-2">
                <input type="submit" value="Se connecter">
            </div>
        </div>
    </form>

    <?php
}

?>