public function setUser($userData, $update = false) { if ($this->dbObj == null) { $users = $this->get('users'); $users[$userData['user_name']]['user_password'] = $userData['user_password']; $users[$userData['user_name']]['role_name'] = $userData['role_name']; $this->set('users', $users); } else { $sql = ""; if (!$update) { $sql = "INSERT INTO users (user_name, user_password, user_role) VALUES "; $sql .= "('{$userData['user_name']}'"; $sql .= ", '{$userData['user_password']}'"; $sql .= ", '{$userData['user_role']}')"; } else { $sql = "UPDATE users SET "; $sql .= "user_password='******'user_password']}'"; $sql .= ", user_role='{$userData['user_role']}'"; $sql .= " WHERE user_name='{$userData['user_name']}'"; } $this->dbObj->ExecuteNonQuery($sql); } }