System Manager v8.0

Editing: update-page.php

<?php
include 'includes/db.php';
include 'includes/auth.php';

if ($_SERVER['REQUEST_METHOD'] == 'POST') {
    $action = $_POST['action'] ?? 'update';

if ($action == 'remove_gallery') {
        $gallery_id = (int)$_POST['gallery_id'];
        
        // Get image filename
        $result = mysqli_query($conn, "SELECT image FROM page_gallery WHERE id = $gallery_id");
        $gallery = mysqli_fetch_assoc($result);
        
        // Delete file
        if ($gallery && !empty($gallery['image'])) {
            $file_path = 'uploads/page-images/' . $gallery['image'];
            if (file_exists($file_path)) {
                unlink($file_path);
            }
        }
        
        // Delete from database
        mysqli_query($conn, "DELETE FROM page_gallery WHERE id = $gallery_id");
        echo 'success';
        exit;
    }

if ($action == 'update_caption') {
        $gallery_id = (int)$_POST['gallery_id'];
        $caption = mysqli_real_escape_string($conn, $_POST['caption']);
        
        mysqli_query($conn, "UPDATE page_gallery SET caption = '$caption' WHERE id = $gallery_id");
        echo 'success';
        exit;
    }

// Main Update Logic
    if ($action == 'update') {
        $page_id = (int)$_POST['page_id'];
        $title = mysqli_real_escape_string($conn, $_POST['title']);
        $slug = mysqli_real_escape_string($conn, $_POST['slug']);
        $city = mysqli_real_escape_string($conn, $_POST['city']);
        $heading = mysqli_real_escape_string($conn, $_POST['heading']);
        $content = mysqli_real_escape_string($conn, $_POST['content']);
        $meta_title = mysqli_real_escape_string($conn, $_POST['meta_title']);
        $meta_description = mysqli_real_escape_string($conn, $_POST['meta_description']);
        $status = mysqli_real_escape_string($conn, $_POST['status']);
        $google_map_link = mysqli_real_escape_string($conn, $_POST['google_map_link']);
        
        $services = isset($_POST['services']) ? json_encode($_POST['services']) : json_encode([]);
        
        // Handle featured image upload
        $featured_image_update = '';
        if (!empty($_FILES['featured_image']['name'])) {
            $file = $_FILES['featured_image'];
            $file_name = time() . '_featured_' . basename($file['name']);
            $upload_dir = 'uploads/page-images/';
            
            if (!is_dir($upload_dir)) {
                mkdir($upload_dir, 0755, true);
            }
            
            if (move_uploaded_file($file['tmp_name'], $upload_dir . $file_name)) {
                $featured_image_update = ", featured_image = '$file_name'";
            }
        }
        
        $query = "UPDATE pages SET 
                  title = '$title',
                  slug = '$slug',
                  city = '$city',
                  heading = '$heading',
                  content = '$content',
                  services = '$services',
                  google_map_link = '$google_map_link',
                  meta_title = '$meta_title',
                  meta_description = '$meta_description',
                  status = '$status'
                  $featured_image_update
                  WHERE id = $page_id";
        
        if (mysqli_query($conn, $query)) {
            // Handle new gallery images
            if (!empty($_FILES['gallery_images']['name'][0])) {
                $gallery_images = [];
                $captions = json_decode($_POST['gallery_captions'] ?? '{}', true);
                
                // Get current highest sort order
                $result = mysqli_query($conn, "SELECT MAX(sort_order) as max_order FROM page_gallery WHERE page_id = $page_id");
                $row = mysqli_fetch_assoc($result);
                $sort_order = ($row['max_order'] ?? -1) + 1;
                
                for ($i = 0; $i < count($_FILES['gallery_images']['name']); $i++) {
                    if ($_FILES['gallery_images']['error'][$i] == 0) {
                        $file_name = time() . '_' . $i . '_' . basename($_FILES['gallery_images']['name'][$i]);
                        $upload_dir = 'uploads/page-images/';
                        
                        if (move_uploaded_file($_FILES['gallery_images']['tmp_name'][$i], $upload_dir . $file_name)) {
                            $caption = isset($captions[$i]) ? mysqli_real_escape_string($conn, $captions[$i]) : '';
                            $gallery_query = "INSERT INTO page_gallery (page_id, image, caption, sort_order) VALUES ($page_id, '$file_name', '$caption', $sort_order)";
                            mysqli_query($conn, $gallery_query);
                            $gallery_images[] = $file_name;
                            $sort_order++;
                        }
                    }
                }
                
                // Update page with gallery images JSON
                if (!empty($gallery_images)) {
                    // Get existing gallery images
                    $existing = mysqli_query($conn, "SELECT GROUP_CONCAT(image) as images FROM page_gallery WHERE page_id = $page_id");
                    $existing_data = mysqli_fetch_assoc($existing);
                    $all_images = array_merge($gallery_images, explode(',', $existing_data['images'] ?? ''));
                    $gallery_json = json_encode(array_filter($all_images));
                    mysqli_query($conn, "UPDATE pages SET gallery_images = '$gallery_json' WHERE id = $page_id");
                }
            }
            
            header('Location: page-list.php?success=1');
        } else {
            header('Location: edit-page.php?id=' . $page_id . '&error=' . urlencode(mysqli_error($conn)));
        }
    }
}
?>

Cancel