prepare("SELECT * FROM users WHERE LOWER(username) = LOWER(?)"); $stmt->execute([$username]); $user = $stmt->fetch(); if ($user && password_verify($password, $user['password'])) { $_SESSION['user'] = $user['username']; header("Location: home.php"); exit; } else { $error = "Login fehlgeschlagen!"; } } ?>