public function update($etudiant)
 {
     parent::update($etudiant);
     $sql = "UPDATE etudiant SET dep_num=:dep_num, div_num=:div_num WHERE per_num=:per_num";
     $requete = $this->db->prepare($sql);
     $requete->bindValue(":dep_num", $etudiant->getDepNum());
     $requete->bindValue(":div_num", $etudiant->getDivNum());
     $requete->bindValue(":per_num", $etudiant->getPerNum());
     $retour = $requete->execute();
     return $retour;
 }
 public function update($salarie)
 {
     parent::update($salarie);
     $sql = "UPDATE salarie SET fon_num=:fon_num, sal_telprof=:sal_telprof WHERE per_num=:per_num";
     $requete = $this->db->prepare($sql);
     $requete->bindValue(":fon_num", $salarie->getFonNum());
     $requete->bindValue(":sal_telprof", $salarie->getSalTelProf());
     $requete->bindValue(":per_num", $salarie->getPerNum());
     $retour = $requete->execute();
     return $retour;
 }
Exemplo n.º 3
0
    $personneManager = new PersonneManager($_SESSION['connexion']);
    $villeManager = new VilleManager($_SESSION['connexion']);
    if ($_POST['ville'] != null) {
        $idville = $villeManager->getIdwithNom($_POST['ville']);
    } else {
        $idville = null;
    }
    $a['id'] = $_SESSION['utilisateur']->getId();
    if ($_POST['nom'] != null) {
        $a['nom'] = $_POST['nom'];
    }
    if ($_POST['prenom'] != null) {
        $a['prenom'] = $_POST['prenom'];
    }
    if ($_POST['rue'] != null) {
        $a['rue'] = $_POST['rue'];
    }
    if ($_POST['numero'] != null) {
        $a['numero'] = $_POST['numero'];
    }
    if ($_POST['telephone'] != null) {
        $a['telephone'] = $_POST['telephone'];
    }
    if ($idville != null) {
        $a['idville'] = $idville;
    }
    $majuser->hydrate($a);
    $personneManager->update($majuser);
    $_SESSION['utilisateur'] = $majuser;
    header("location: index.php?page=profil");
}