Перепробывал многие варианты, но в чем то ошибся..
Код:
if (!empty($_POST))
{
$login = $db->quote($_POST['login']);
$query = $db->prepare("SELECT `id` FROM `account` WHERE `username`=".$login." LIMIT 1");
$query->execute();
$rows = $query->fetchAll();
if (count($rows) == 1)
{
$query = $db->prepare("SELECT `id` FROM `account` WHERE `username`=".$login." AND `sha_pass_hash`= SHA1(CONCAT(UPPER($_POST['login']), ':', UPPER($_POST['password']))) LIMIT 1");
$query->execute();
$row = $query->fetch(PDO::FETCH_ASSOC);
$_SESSION['user_id'] = $row['id'];
$time = 86400;
if (isset($_POST['remember']))
{
setcookie('login', $login, time()+$time, "/");
setcookie('password', $password, time()+$time, "/");
}
header('Location: index.php');
exit;
}
else
{
echo "<meta http-equiv='refresh' content='0; url=/index.php'>";
}
}