D0R4H4X0R SH3LL

Current File : /home/equalcompa/domains/equalcompassion.org/public_html/admin-portal/update_project.php

<?php 
include('ant.php');
 

// Check the connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}
  

// Get the blog ID and old cover image from the request
$blogId = $_POST['project_id'];
$oldCoverImage = $_POST['old_cover_image'];

// Retrieve form data
$title = $_POST['fname'];
$brief = $_POST['phone'];
$paragraphs = json_encode($_POST['paragraphs']);

// Check if a new cover image was uploaded
if (!empty($_FILES['cimage']['name'])) {
    $coverImagePath = 'uploads/' . $_FILES['cimage']['name'];
    move_uploaded_file($_FILES['cimage']['tmp_name'], $coverImagePath);
} else {
    $coverImagePath = $oldCoverImage;
}

// Manage gallery images
$galleryImages = array_filter($_POST['existing_images'] ?? []); // Existing images that are not marked for removal

// Handle newly uploaded gallery images
if (!empty($_FILES['galleryImages']['name'][0])) {
    foreach ($_FILES['galleryImages']['name'] as $key => $name) {
        $filePath = 'uploads/' . $name;
        if (move_uploaded_file($_FILES['galleryImages']['tmp_name'][$key], $filePath)) {
            $galleryImages[] = $filePath;
        }
    }
}

// JSON-encode the gallery images array for storage
$galleryImagesJson = json_encode($galleryImages);

// Update query
$updateQuery = "UPDATE projects SET 
    title = ?, 
    brief = ?, 
    paragraphs = ?, 
    cover_image = ?, 
    gallery_images = ? 
    WHERE id = ?";
$stmt = $conn->prepare($updateQuery);
$stmt->execute([$title, $brief, $paragraphs, $coverImagePath, $galleryImagesJson, $blogId]);

echo json_encode(["status" => "success", "message" => "Project updated successfully"]);
?>