$q = sqlite_query($this->db, "SELECT * FROM users WHERE uid = '{$id}' AND password = '******' LIMIT 1", $e);
if (sqlite_num_rows($q) > 0) {
$r = sqlite_fetch_array($q);
$_SESSION['uid'] = $r['uid'];
$_SESSION['uname'] = $r['username'];
}
}
}
public function isloggedin()
{
return isset($_SESSION['uid']);
}
public function logout()
{
unset($_SESSION['uid']);
session_destroy();
setcookie("userid", "", time() - 60 * 60 * 24 * 30);
setcookie("pass", "", time() - 60 * 60 * 24 * 30);
}
public function uname()
{
if ($this->isloggedin()) {
return $_SESSION['uname'];
} else {
return "NO LOGIN.";
}
}
}
$u = new userauth();
$u->dbinit();
$result = $stmt->fetch(PDO::FETCH_ASSOC);
if ($result) {
$_SESSION['uid'] = $result['uid'];
$_SESSION['uname'] = $result['username'];
}
}
}
public function isAuthenticated()
{
return isset($_SESSION['uid']);
}
public function logout()
{
unset($_SESSION['uid']);
session_destroy();
setcookie("userid", "", time() - 60 * 60 * 24 * 30);
setcookie("pass", "", time() - 60 * 60 * 24 * 30);
}
public function uname()
{
if ($this->isAuthenticated()) {
return $_SESSION['uname'];
} else {
return "NO LOGIN.";
}
}
}
$auth = new userauth();
$auth->dbinit();
//Initial
//$u->createTables();
