public function getAll() { $sql = "SELECT * FROM privileges"; $database = new Database(); $result = $database->performQuery($sql); $database->disconnectDb(); return $result; }
$session = new Session(); if (!$session->isLogin) { redirect("login.php"); } include_once 'includes/header.php'; $database = new Database(); $languages = new Language(); $widget = new Widget(); $post = new Post(); $menu = new Menu(); ?> <title id="settings">Settings</title> <?php if (isset($_GET['settings']) && $_GET['settings'] == 1) { include_once 'includes/languages.php'; } else { if (isset($_GET['settings']) && $_GET['settings'] == 2) { include_once 'includes/widgets.php'; } else { redirect("settings.php?settings=1"); } } ?> <script type="text/javascript" src="js/formValidation.js"></script> <script type="text/javascript" src="js/delete.js"></script> <?php include_once 'includes/footer.php'; $database->disconnectDb();
public function changePrivilege() { $database = new Database(); $sql = "UPDATE users SET privilegeId = '{$this->privilegeId}' WHERE userId = {$this->id}"; $query = $database->performQuery($sql); $database->disconnectDb(); return $query; }