Blog

<?php
$conn = new mysqli("localhost", "root", "", "testdb");

if ($conn->connect_error) {
  die("Connection failed: " . $conn->connect_error);
}

$sql = "SELECT * FROM students ORDER BY id DESC";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
  echo "<table style='border-collapse:collapse; width:100%; margin-top:15px;'>
          <tr style='background:#34495e; color:#fff;'>
            <th style='padding:10px; border:1px solid #ccc;'>ID</th>
            <th style='padding:10px; border:1px solid #ccc;'>Name</th>
            <th style='padding:10px; border:1px solid #ccc;'>Email</th>
            <th style='padding:10px; border:1px solid #ccc;'>Course</th>
            <th style='padding:10px; border:1px solid #ccc;'>Registered</th>
          </tr>";

  while ($row = $result->fetch_assoc()) {
    echo "<tr>
            <td style='padding:10px; border:1px solid #ccc;'>" . $row["id"] . "</td>
            <td style='padding:10px; border:1px solid #ccc;'>" . $row["name"] . "</td>
            <td style='padding:10px; border:1px solid #ccc;'>" . $row["email"] . "</td>
            <td style='padding:10px; border:1px solid #ccc;'>" . $row["course"] . "</td>
            <td style='padding:10px; border:1px solid #ccc;'>" . $row["created_at"] . "</td>
          </tr>";
  }

  echo "</table>";
} else {
  echo "<p>❌ No students found in the database.</p>";
}

$conn->close();
?>

<form method="GET" action="" style="margin:20px 0;">
  <input type="text" name="search" placeholder="Enter name to search..." 
         style="padding:10px; width:60%; border:1px solid #ccc;">
  <input type="submit" value="Search" 
         style="padding:10px 20px; background:#2980b9; color:white; border:none; cursor:pointer;">
</form>