query("SELECT * FROM management LIMIT 1"); $management = $check->fetch_assoc(); if ($_SERVER['REQUEST_METHOD'] === 'POST') { $head_name = trim($_POST['head_name']); // ✅ Save date properly (Y-m-d) $next_term_date = !empty($_POST['next_term_date']) ? $_POST['next_term_date'] : null; $closing_date = !empty($_POST['closing_date']) ? $_POST['closing_date'] : null; $head_signature = $management['head_signature'] ?? ''; $stamp_image = $management['stamp_image'] ?? ''; // Upload Signature if (!empty($_FILES['head_signature']['name'])) { $sigFile = time() . '_head_' . basename($_FILES['head_signature']['name']); if (move_uploaded_file($_FILES['head_signature']['tmp_name'], $uploadDir . $sigFile)) { $head_signature = $sigFile; } } // Upload Stamp if (!empty($_FILES['stamp_image']['name'])) { $stampFile = time() . '_stamp_' . basename($_FILES['stamp_image']['name']); if (move_uploaded_file($_FILES['stamp_image']['tmp_name'], $uploadDir . $stampFile)) { $stamp_image = $stampFile; } } // Insert or Update if ($management) { $stmt = $conn->prepare("UPDATE management SET head_name=?, head_signature=?, stamp_image=?, next_term_date=?, closing_date=? WHERE id=?"); $stmt->bind_param("sssssi", $head_name, $head_signature, $stamp_image, $next_term_date, $closing_date, $management['id']); $stmt->execute(); } else { $stmt = $conn->prepare("INSERT INTO management (head_name, head_signature, stamp_image, next_term_date, closing_date) VALUES (?,?,?,?,?)"); $stmt->bind_param("sssss", $head_name, $head_signature, $stamp_image, $next_term_date, $closing_date); $stmt->execute(); } $message = "Saved successfully"; // Refresh data $check = $conn->query("SELECT * FROM management LIMIT 1"); $management = $check->fetch_assoc(); } ?>
🏫 School Management Setup
✅