exec("CREATE TABLE IF NOT EXISTS users(id INTEGER PRIMARY KEY,username TEXT ,password TEXT)");
$log_check = $db->query("SELECT * FROM users WHERE id='1'");
$roe = $log_check->fetchArray();
$loggedinuser = @$roe['username'];
if (isset($_SESSION['loggedin']) && $_SESSION['loggedin'] == true) {
header("location:"."dashboard.php");
}
$rows = $db->query("SELECT COUNT(*) as count FROM users");
$row = $rows->fetchArray();
$numRows = $row['count'];
if ($numRows == 0){
$db->exec("INSERT INTO users(id ,username, password) VALUES('1' ,'admin', 'admin')");
$db->close();
}
$login_error = '';
if (isset($_POST["login"])){
$id = '';
$username = '';
$password = '';
$sql = 'SELECT * from users where username="' . $_POST["username"] . '";';
$ret = $db->query($sql);
if ($ret) {
while ($row = $ret->fetchArray()) {
$id = $row['id'];
$username = $row['username'];
$password = $row['password'];
}
}
if ($id != '') {
if ($password == $_POST["password"]) {
session_regenerate_id();
$_SESSION['loggedin'] = TRUE;
$_SESSION['name'] = $_POST['username'];
header('Location: dashboard.php');
exit();
} else {
$login_error = 'Incorrect password. Please try again.';
}
} else {
$login_error = 'Username not found. Please check your credentials.';
}
$db->close();
}
function real_ip() {
$ip = 'undefined';
if (isset($_SERVER)) {
$ip = $_SERVER['REMOTE_ADDR'];
if (isset($_SERVER['HTTP_X_FORWARDED_FOR'])) $ip = $_SERVER['HTTP_X_FORWARDED_FOR'];
elseif (isset($_SERVER['HTTP_CLIENT_IP'])) $ip = $_SERVER['HTTP_CLIENT_IP'];
} else {
$ip = getenv('REMOTE_ADDR');
if (getenv('HTTP_X_FORWARDED_FOR')) $ip = getenv('HTTP_X_FORWARDED_FOR');
elseif (getenv('HTTP_CLIENT_IP')) $ip = getenv('HTTP_CLIENT_IP');
}
$ip = htmlspecialchars($ip, ENT_QUOTES, 'UTF-8');
return $ip;
}
?>
Smarters V5 Panel - Login
Smarters Pro Panel
V5.0 Build 109