📁 File Manager
🏠 /
/
home
/
u857492117
/
domains
/
mangaldaicollege.org
/
public_html
/
dk1
Dosya Düzenle: leaderboard.php
<?php session_start(); include("config.php"); $logged_in = isset($_SESSION['participant_id']); $name = $logged_in ? $_SESSION['name'] : ''; // Fetch quizzes $quizzes = mysqli_query($conn, "SELECT * FROM quizzes"); ?> <!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, initial-scale=1"> <title>Leaderboard</title> <link href="https://fonts.googleapis.com/css2?family=Poppins:wght@400;600&display=swap" rel="stylesheet"> <style> body { font-family:'Poppins',sans-serif; background:#f0f2f5; margin:0; padding:0; } header { background:#6a11cb; color:white; padding:15px 30px; display:flex; justify-content:space-between; align-items:center; } header a { color:white; text-decoration:none; margin-left:15px; font-weight:600; } .container { width:90%; max-width:900px; margin:30px auto; } .card { background:white; border-radius:12px; padding:20px; margin:15px 0; box-shadow:0 8px 20px rgba(0,0,0,0.1); } .card h3 { color:#2575fc; margin:0; } table { width:100%; border-collapse:collapse; margin-top:15px; } th, td { padding:12px; border-bottom:1px solid #ddd; text-align:center; } th { background:#6a11cb; color:white; } .highlight { background:#e0e7ff; font-weight:600; } </style> </head> <body> <header> <div>Online Quiz System</div> <div> <?php if($logged_in){ echo "Hi, $name <a href='logout.php'>Logout</a>"; } else { ?> <a href="login.php">Login</a> <a href="register.php">Register</a> <?php } ?> </div> </header> <div class="container"> <h2>Leaderboard</h2> <?php while($quiz = mysqli_fetch_assoc($quizzes)) { ?> <div class="card"> <h3><?php echo htmlspecialchars($quiz['title']); ?></h3> <table> <tr> <th>Rank</th> <th>Participant</th> <th>Score</th> </tr> <?php $res = mysqli_query($conn, "SELECT p.name, qa.score, RANK() OVER (ORDER BY qa.score DESC) AS rank_position FROM quiz_attempts qa JOIN participants p ON qa.participant_id = p.participant_id WHERE qa.quiz_id='".$quiz['quiz_id']."' ORDER BY qa.score DESC LIMIT 10"); while($row = mysqli_fetch_assoc($res)) { $highlight = ($logged_in && $row['name'] == $name) ? "highlight" : ""; echo "<tr class='$highlight'><td>".$row['rank_position']."</td><td>".htmlspecialchars($row['name'])."</td><td>".$row['score']."</td></tr>"; } ?> </table> </div> <?php } ?> </div> </body> </html>
💾 Kaydet
İptal