예제 #1
0
파일: logout.php 프로젝트: gertiksxx/PalMA
<?php

// Copyright (C) 2014 Universitätsbibliothek Mannheim
// See file LICENSE for license details.
// Datenbankanbindung initialisieren.
require_once 'DBConnector.class.php';
$dbcon = new DBConnector();
session_start();
if (isset($_SESSION['username'])) {
    $username = $_SESSION['username'];
    $dbcon->delUser($username, $dbcon->ipAddress());
}
session_destroy();
header('Location: index.php');
/*
    // Alternate code, currently unused, not working with Apache2 proxy.
    $hostname = $_SERVER['HTTP_HOST'];
    $path = dirname($_SERVER['PHP_SELF']);
    header('Location: http://'.$hostname.($path == '/' ? '' : $path).'/login.php');
*/
예제 #2
0
    //~ $db->exec("CREATE TRIGGER dbchange AFTER UPDATE ON user
    //~ BEGIN
    //~ dbModifiedCallback();
    //~ END");
    //~ $db = new DBConnector('palma.db');
    echo "Tables=" . $db->querySingle('SELECT count(*) FROM sqlite_master WHERE type="table"') . "\n";
    var_dump($db->query("SELECT * from sqlite_master"));
    $address = $db->ipAddress();
    $db->addUser('testuser1', $address);
    //~ $db->addUser('testuser2', $address);
    //~ $db->addUser('testuser3', $address);
    //~ $db->addUser('testuser4', $address);
    $users = $db->getUsers();
    $db->enableUser('testuser1');
    var_dump($users);
    $db->delUser('haenger', $address);
    $db->delUser('ivwz', $address);
    $db->delUser('skrieg', $address);
    $db->delUser('testuser1', $address);
    $db->delUser('testuser2', $address);
    $db->delUser('testuser3', $address);
    $db->delUser('testuser4', $address);
    echo "Query=" . $db->querySingle('select name from user') . "\n";
    echo "Query=" . $db->querySingle('select count(name) from user') . "\n";
    echo "Query=" . $db->querySingle('select value from setting where key="layout"') . "\n";
    $db->close();
    //~ $db = new DBConnector('palma.db');
    //~ $users = $db->getUsers();
    //~ var_dump($users);
    //~ $db->close();
}