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; }
$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"); }