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