prepare("SELECT * FROM admins WHERE username = ?"); $stmt->execute([$_POST['username']]); $admin = $stmt->fetch(PDO::FETCH_ASSOC); if ($admin && password_verify($_POST['password'], $admin['password'])) { $_SESSION['admin'] = $admin['username']; } else { $error = "Invalid login"; } } if (isset($_GET['logout'])) { session_destroy(); header("Location: admin.php"); exit; } if (!isset($_SESSION['admin'])) { ?>

Admin Login

$error

"; ?>
prepare("DELETE FROM laws WHERE id = ?")->execute([$lawId]); } elseif ($action === 'pass') { $db->prepare("UPDATE laws SET status='Passed', admin=? WHERE id=?")->execute([$_SESSION['admin'], $lawId]); } elseif ($action === 'unsure') { $db->prepare("UPDATE laws SET status='unsure', admin=? WHERE id=?")->execute([$_SESSION['admin'], $lawId]); } elseif ($action === 'noinfo') { $db->prepare("UPDATE laws SET status='noinfo', admin=? WHERE id=?")->execute([$_SESSION['admin'], $lawId]); } elseif ($action === 'obsoleted') { $db->prepare("UPDATE laws SET status='obsoleted', admin=? WHERE id=?")->execute([$_SESSION['admin'], $lawId]); } elseif ($action === 'novote') { $db->prepare("UPDATE laws SET status='novote', admin=? WHERE id=?")->execute([$_SESSION['admin'], $lawId]); } elseif ($action === 'repealed') { $db->prepare("UPDATE laws SET status='repealed', admin=? WHERE id=?")->execute([$_SESSION['admin'], $lawId]); } elseif ($action === 'fail') { $db->prepare("UPDATE laws SET status='Failed', admin=? WHERE id=?")->execute([$_SESSION['admin'], $lawId]); } header("Location: admin.php"); exit; } $laws = $db->query("SELECT * FROM laws ORDER BY created_at DESC")->fetchAll(PDO::FETCH_ASSOC); include "head.php"; ?>

Admin Panel

Logged in as | Logout

Title Proposer Status Actions
Pass Fail Noinfo
Unsure novote obsoleted
repealed Delete