exec("CREATE TABLE IF NOT EXISTS students ( id INT AUTO_INCREMENT PRIMARY KEY, first_name VARCHAR(100) NOT NULL, last_name VARCHAR(100) NOT NULL, date_of_birth DATE NOT NULL, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP );"); $stmt = $pdo->query("SELECT id, first_name, last_name, created_at FROM students ORDER BY created_at DESC LIMIT 5"); if($stmt) { $students = $stmt->fetchAll(PDO::FETCH_ASSOC); } } catch (Exception $e) { error_log("DB Error on dashboard: " . $e->getMessage()); } ?> <?= htmlspecialchars($page_title) ?> - <?= htmlspecialchars($_SERVER['PROJECT_NAME'] ?? 'WebApp') ?>

Dashboard

Add New Student
Recently Added Students

No students have been added yet. Add the first one!

# First Name Last Name Date Added Actions
View