<?php
ob_start();
session_start();
try {
$db_host = 'localhost';
$db_name = 'test';
$db_user = 'root';
$db_pass = '';
$option = array(
PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8",
PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC);
$db = new pdo("mysql:host=".$db_host.";dbname=".$db_name, $db_user, $db_pass, $option);
} catch(PDOException $e) {
print $e->getMessage();
}
$id = isset($_GET['id']) ? abs(intval($_GET['id'])) : null;
require_once 'functions.php';
if(isset($_COOKIE['login']) && isset($_COOKIE['pass'])){
$login = $_COOKIE['login'];
$pass = $_COOKIE['pass'];
if(empty($login) || empty($pass)){
setcookie('login', '', $login, time() + 3600 * 24 * 365, '/');
setcookie('pass', '', $login, time() + 3600 * 24 * 365, '/');
}
$user = $db->prepare("SELECT * FROM users WHERE login = ? AND pass = ?");
$user->execute(array($login, $pass));
$rows = $user->fetch(PDO::FETCH_ASSOC);
$user = $rows['id'];
if(isset($rows['id'])){
if($rows['login'] !== $login || $rows['pass'] !== $pass){
setcookie('login', '', $login, time() + 3600 * 24 * 365, '/');
setcookie('pass', '', $login, time() + 3600 * 24 * 365, '/');
}
}
}
?>