public static function setModifAdresse(Utilisateur $user) { try { $conn = Main::BDDConnexionPDO(); $req = $conn->prepare("UPDATE Utilisateur SET Adresse=?, CodePostal=?, Ville=? WHERE AdresseMail=? "); $req->execute(array($user->getAdresse(), $user->getCodePostal(), $user->getVille(), $user->getAdresseMail())); $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; }
public static function setAjouterUser(Utilisateur $unUser) { try { $mdp = sha1($unUser->getPassword()); $conn = Main::BDDConnexionPDO(); $reqprepare2 = $conn->prepare("INSERT INTO Utilisateur (Nom, Prenom, Password, AdresseMail, Adresse, CodePostal, Ville) VALUES (?,?,?,?,?,?,?)"); $reqprepare2->execute(array($unUser->getNom(), $unUser->getPrenom(), $mdp, $unUser->getAdresseMail(), $unUser->getAdresse(), $unUser->getCodePostal(), $unUser->getVille())); $conn = null; } catch (\PDOException $ex) { Main::setFlashMessage($ex->getMessage(), 'error'); } }