exec('TRUNCATE TABLE votes'); $message = 'All votes have been cleared.'; } else { // Optional: handle unauthorized cleanup attempt } } // Handle logout if (isset($_GET['logout'])) { session_destroy(); header('Location: results.php'); exit; } $is_loggedin = isset($_SESSION['loggedin']) && $_SESSION['loggedin']; ?> Voting Results

Voting Results

Logout

Most Beautiful Website

query("SELECT website_number, COUNT(*) as votes FROM votes WHERE category = 'beauty' GROUP BY website_number ORDER BY votes DESC"); $results = $stmt->fetchAll(PDO::FETCH_ASSOC); if (empty($results)): echo "

No votes yet for this category.

"; else: ?>
  • Website votes

Most Funny/Interesting Website

query("SELECT website_number, COUNT(*) as votes FROM votes WHERE category = 'funny' GROUP BY website_number ORDER BY votes DESC"); $results = $stmt->fetchAll(PDO::FETCH_ASSOC); if (empty($results)): echo "

No votes yet for this category.

"; else: ?>
  • Website votes

Raw Votes

query("SELECT id, voter_name, category, website_number, created_at FROM votes ORDER BY created_at DESC"); $raw_votes = $stmt->fetchAll(PDO::FETCH_ASSOC); if (empty($raw_votes)): echo "

No votes have been cast yet.

"; else: ?>
ID Voter Name Category Website Number Timestamp

View Results

You must be logged in to see the voting results.