function updateUserProfil(User $user) { if (!empty($_POST['Private'])) { $query = $this->db->prepare("UPDATE user SET UserName = :username , Mdp = :mdp , tel = :tel , isPrivate = :private WHERE id = :id"); $query->execute(array(":id" => $user->getId(), ":username" => $user->getUserName(), ":mdp" => $user->getMdp(), ":tel" => $user->getTel(), ":private" => $_POST['Private'])); } else { $query = $this->db->prepare("UPDATE user SET UserName = :username , Mdp = :mdp , tel = :tel, isPrivate = 0 WHERE id = :id"); $query->execute(array(":id" => $user->getId(), ":username" => $user->getUserName(), ":mdp" => $user->getMdp(), ":tel" => $user->getTel())); } }
public function initTable() { $adminConf = getConfigFile(); $query = $this->db->prepare("INSERT INTO user(UserName,Mdp,DateInscription,email,Tel) VALUES (:username , :mdp , NOW() , :email , :tel);\n INSERT INTO user_droit(id_Droits, id_User, Date) VALUES (1,1,NOW());"); $admin = new User(array("UserName" => $adminConf['pseudo'], "Mdp" => "admin", "email" => $adminConf['mail'], "tel" => $adminConf['tel'])); $admin->setHashMdp(); $query->execute(array(":username" => $admin->getUserName(), ":mdp" => $admin->getMdp(), ":email" => $admin->getEmail(), ":tel" => $admin->getTel())); }