/** * Konstruktor * * *Description* * * @param * * @return */ public function __construct() { $this->db = parent::connect(); $this->pass = \Controller\Helpers::encryptPassword(self::DEFAULT_PASS); $this->arrData = $this->loadInsertDatabase(); }
/** * Eintrag Benutzer aendern * * *Description* * * @param array * * @return boolean */ public function updateUser($user) { //Passwort verschlüsselt ersetzen if (!empty($user['password'])) { $pass = \Controller\Helpers::encryptPassword($user['password']); } else { // Falls leer altes Passwort aus DB holen $sql_request = "SELECT password FROM " . TBL_PRFX . "user WHERE username = :username"; $stmt = $this->db->prepare($sql_request); $stmt->execute(array(':username' => $user['username'])); $request = $stmt->fetch(\PDO::FETCH_ASSOC); $pass = $request['password']; } $sql_query = "UPDATE " . TBL_PRFX . "user \n\t\t\tSET\n\t\t\t\temail = :email,\n\t\t\t\tusername = :username,\n\t\t\t\tpassword = :password,\n\t\t\t\tstatus = :status\n\t\t\tWHERE id = :id"; $arrExec = array(':email' => $user['email'], ':username' => $user['username'], ':password' => $pass, ':status' => $user['status'], ':id' => $user['id']); //Update User $stmt = $this->db->prepare($sql_query); if ($stmt->execute($arrExec)) { return TRUE; } else { return FALSE; } }