MAINHACK

Viewing / Editing File: update_teacher_subjects.php

<?php
include("functions.php");
$s_code = $_SESSION['s_code_Xw2119904'];

if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $teacherId = trim($_POST['teacher_id']);
    $programme = trim($_POST['programme']);
    $classname = trim($_POST['classname']);
    $semester  = trim($_POST['semester']);
    $subjects  = $_POST['subject_names'] ?? [];

// Get existing subjects
    $existing = [];
    $stmt = $new->prepare("SELECT subject_name FROM teacher_subjects WHERE teacher_id=? AND s_code=? AND programe=? AND classname=? AND semester=?");
    $stmt->bind_param("sssss", $teacherId, $s_code, $programme, $classname, $semester);
    $stmt->execute();
    $res = $stmt->get_result();
    while ($row = $res->fetch_assoc()) $existing[] = $row['subject_name'];
    $stmt->close();

// Add new ones
    $toAdd = array_diff($subjects, $existing);
    if ($toAdd) {
        $ins = $new->prepare("INSERT INTO teacher_subjects (teacher_id, programe, subject_name, classname, semester, s_code) VALUES (?,?,?,?,?,?)");
        foreach ($toAdd as $sub) {
            $ins->bind_param("ssssss", $teacherId, $programme, $sub, $classname, $semester, $s_code);
            $ins->execute();
        }
        $ins->close();
    }

// Delete unchecked
    $toDelete = array_diff($existing, $subjects);
    if ($toDelete) {
        $del = $new->prepare("DELETE FROM teacher_subjects WHERE teacher_id=? AND subject_name=? AND programe=? AND classname=? AND semester=? AND s_code=?");
        foreach ($toDelete as $sub) {
            $del->bind_param("ssssss", $teacherId, $sub, $programme, $classname, $semester, $s_code);
            $del->execute();
        }
        $del->close();
    }

echo "✅ Subjects updated successfully!";
}

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: update_teacher_subjects.php

Server Info

System Features

User Info