<?php

// session_start();
include("includes/config.php");

if(isset($_POST['add_gallery'])){

    $title = $_POST['title'];

    $photo = $_FILES['photo']['name'];
  

    $allowed_image_extensions = array('gif','png','jpg','jpeg','webp','WEBP');

    $photo_filename = $_FILES['photo']['name'];
    $photo_file_extension = pathinfo($photo_filename, PATHINFO_EXTENSION);
    
    if(!in_array($photo_file_extension, $allowed_image_extensions)){
        $_SESSION['status'] = "The image file is not allowed. Please upload an image.";
        header('Location: gallery.php');
        exit;

    } else {
       
        $query = "INSERT INTO gallery (title, photo) VALUES ('$title','$photo')";
        $query_run = mysqli_query($conn, $query);

        
        if($query_run){
            move_uploaded_file($_FILES["photo"]["tmp_name"], "gallery/".$_FILES["photo"]["name"]);
          
            $_SESSION['status'] = "Data Uploaded Successfully";
            header('Location: view-gallery.php');
            exit;
        } else {
            $_SESSION['status'] = "Data Not Uploaded Successfully";
            header('Location: gallery.php');
            exit;
        }
    }
}


// // update 
// if(isset($_POST['update_gallery'])){
//     $id = $_POST['id'];
//     $title = $_POST['title'];
   
//     $old_photo = $_POST['image_old'];
//     $update_photo_filename = $_FILES["photo"]["name"] ? $_FILES["photo"]["name"] : $old_photo;

//     // $old_pdf = $_POST['pdf_old'];
//     // $update_pdf_filename = $_FILES["pdf"]["name"] ? $_FILES["pdf"]["name"] : $old_pdf;

//     $allowed_image_extensions = array('gif','png','jpg','jpeg','webp','WEBP');
//     // $allowed_pdf_extensions = array('pdf');

//     $photo_file_extension = pathinfo($update_photo_filename, PATHINFO_EXTENSION);
//     // $pdf_file_extension = pathinfo($update_pdf_filename, PATHINFO_EXTENSION);

//     // Check if the uploaded file extensions are allowed
//     if(!in_array($photo_file_extension, $allowed_image_extensions)){
//         $_SESSION['status'] = "The image file is not allowed. Please upload an image.";
//         header("Location: edit-gallery.php?id=$id"); // Redirect to the edit page with the department_id
//         exit;
//     // } elseif (!in_array($pdf_file_extension, $allowed_pdf_extensions)) {
//     //     $_SESSION['status'] = "The PDF file is not allowed. Please upload a PDF file.";
//     //     header("Location: edit-department.php?id=$id"); // Redirect to the edit page with the department_id
//     //     exit;
//     }

//     // Update the department information in the database
//     $query = "UPDATE gallery SET title='$title', photo='$update_photo_filename' WHERE id ='$id' ";

//     $query_run = mysqli_query($conn, $query);

//     if($query_run){
//         // If new photo is uploaded, move it to the desired directory and delete the old one
//         if($_FILES["photo"]["name"] !='' && $_FILES["photo"]["name"] != $old_photo){
//             move_uploaded_file($_FILES["photo"]["tmp_name"], "gallery/".$_FILES["photo"]["name"]);
//             unlink("gallery/". $old_photo);    
//         }

//         // If new PDF is uploaded, move it to the desired directory and delete the old one
//         // if($_FILES["pdf"]["name"] !='' && $_FILES["pdf"]["name"] != $old_pdf){
//         //     move_uploaded_file($_FILES["pdf"]["tmp_name"], "pdfs/".$_FILES["pdf"]["name"]);
//         //     unlink("pdfs/". $old_pdf);    
//         // }

//         $_SESSION['status'] = "Image and PDF Updated Successfully";
//         header('Location: view-gallery.php');
//     } else {
//         $_SESSION['status'] = "Image and PDF Not Updated Successfully";
//         header('Location: view-gallery.php');
//     }
// }

// // delete

// if(isset($_POST['delete_gallery'])){
//     $id = $_POST['delete_id'];
//     $photo = $_POST['del_gallery'];
//     $pdf = $_POST['del_pdf'];

//     $query = "DELETE FROM gallery WHERE id = '$id'";
//     $query_run = mysqli_query($conn, $query);

//     if($query_run){
//         if(unlink("gallery/".$photo)) {
//             $_SESSION['status'] = "Deleted Successfully";
//             header('Location: view-gallery.php');
//         } else {
//             $_SESSION['status'] = "Error deleting files";
//             header('Location: view-gallery.php');
//         }
//     } else {
//         $_SESSION['status'] = "Not Deleted Successfully";
//         header('Location: view-gallery.php');
//     }

?>