prepare('SELECT * FROM user'); $query->execute(); $userList = $query->fetchAll(); foreach ($userList as $k) { if ($k['user'] == $user && $k['password'] == $password) { session_start(); $_SESSION['user'] = $user; $_SESSION['password'] = $password; header('Location: admin.php'); } else { header('Location: index.php'); } } }