<?php
session_start();
require_once('../config/db.php');

if ($_SERVER['REQUEST_METHOD'] == 'POST' && isset($_POST['student_id'])) {
    $student_id = $_POST['student_id'];
    $course_id  = $_POST['course_id'];
    $teacher_id = $_POST['teacher_id'];
    $assignment_details = $_POST['assignment_details'];
    $notes      = $_POST['notes'];
    $exam_date  = $_POST['exam_date'];

    try {
        $stmt = $conn->prepare("INSERT INTO assignments (student_id, course_id, teacher_id, assignment_details, notes, exam_date) VALUES (?, ?, ?, ?, ?, ?)");
        $stmt->execute([$student_id, $course_id, $teacher_id, $assignment_details, $notes, $exam_date]);

        $_SESSION['success'] = "✅ تم حفظ الواجب بنجاح";
    } catch (Exception $e) {
        $_SESSION['error'] = "❌ فشل الحفظ: " . $e->getMessage();
    }

    header("Location: manage_assignments.php?student_id=" . $student_id);
    exit;
}