students.php

<?php
require 'config/db.php';
require 'includes/functions.php';

if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $studentName = trim($_POST['student_name'] ?? '');
    $rollNo = trim($_POST['roll_no'] ?? '');
    $className = trim($_POST['class_name'] ?? '');

    if ($studentName === '' || $rollNo === '' || $className === '') {
        redirect_with_message('students.php', 'All student fields are required.', 'error');
    }

    $stmt = $pdo->prepare("INSERT INTO students (student_name, roll_no, class_name) VALUES (?, ?, ?)");
    try {
        $stmt->execute([$studentName, $rollNo, $className]);
        redirect_with_message('students.php', 'Student added successfully.');
    } catch (PDOException $e) {
        redirect_with_message('students.php', 'Roll number must be unique.', 'error');
    }
}

$students = get_students($pdo);
include 'includes/header.php';
?>
<h2>Manage Students</h2>
<form method="POST">
    <div class="grid">
        <div><input type="text" name="student_name" placeholder="Student Name" required></div>
        <div><input type="text" name="roll_no" placeholder="Roll No" required></div>
        <div><input type="text" name="class_name" placeholder="Class" required></div>
        <div><button type="submit">Add Student</button></div>
    </div>
</form>
<table>
    <tr><th>ID</th><th>Name</th><th>Roll No</th><th>Class</th></tr>
    <?php foreach ($students as $student): ?>
        <tr>
            <td><?php echo h($student['id']); ?></td>
            <td><?php echo h($student['student_name']); ?></td>
            <td><?php echo h($student['roll_no']); ?></td>
            <td><?php echo h($student['class_name']); ?></td>
        </tr>
    <?php endforeach; ?>
</table>
<?php include 'includes/footer.php'; ?>