File "savenoticecontroller.php"

Full Path: /home/u593703731/domains/anandinternationalschool.com/public_html/controller/savenoticecontroller.php
File size: 945 bytes
MIME-type: text/x-php
Charset: utf-8

<?php
include "../admin/includes/conn.php";

$heading = mysqli_real_escape_string($conn, $_POST['heading']);
$content = mysqli_real_escape_string($conn, $_POST['content']);
$show_on = mysqli_real_escape_string( $conn , $_POST['show_on']);

$fileName = "";
$uploadDir = __DIR__ . "/../assets/notices/";


if (!is_dir($uploadDir)) {
    mkdir($uploadDir, 0777, true);
}


if (!empty($_FILES['file']['name'])) {

    $fileName = time() . "_" . basename($_FILES['file']['name']);
    $tmpName  = $_FILES['file']['tmp_name'];

    if (!move_uploaded_file($tmpName, $uploadDir . $fileName)) {
        die("❌ File upload failed");
    }
}

$query = "INSERT INTO notices (heading, content, files,show_on)
          VALUES ('$heading', '$content', '$fileName','$show_on')";

if (mysqli_query($conn, $query)) {
    header("Location: ../admin/index.php?page=notice");
    exit;
} else {
    echo mysqli_error($conn);
}