public static function setModifMail(Utilisateur $user) { try { $conn = Main::BDDConnexionPDO(); $req = $conn->prepare("UPDATE Utilisateur SET AdresseMail=? WHERE NumUser=? "); $req->execute(array($user->getAdresse(), $user->getNumUser())); $conn = null; } catch (\Exception $ex) { Main::setFlashMessage($ex->getMessage(), 'error'); } }
/** * @param Utilisateur $user * @return Collection */ public static function getLesCommandesbyUser(Utilisateur $user) { $LesCommandes = new Collection(); try { $conn = Main::BDDConnexionPDO(); $req = $conn->prepare("SELECT * FROM Commande\n\t\t\tWHERE NoUsers = ?"); $req->execute(array($user->getNumUser())); $req = $req->fetchAll(); foreach ($req as $Commande) { $user = MConnexion::getUnUserbyId($Commande['NoUsers']); $commande = new Commande($Commande['NumCommande'], $user, $Commande['DateCommande']); $LesCommandes->ajouter($commande); } } catch (\Exception $e) { Main::setFlashMessage($e->getMessage(), 'error'); } return $LesCommandes; }