PHP Database::disconnectDb Examples

Example #1

File: privilege.php Project: jetmirhaxhisefa/rezervime

 public function getAll()
 {
     $sql = "SELECT * FROM privileges";
     $database = new Database();
     $result = $database->performQuery($sql);
     $database->disconnectDb();
     return $result;
 }

Example #2

File: settings.php Project: jetmirhaxhisefa/rezervime

$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();

Example #3

File: user.php Project: jetmirhaxhisefa/rezervime

 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;
 }