System Manager v8.0

Editing: save-page.php

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

if ($_SERVER['REQUEST_METHOD'] == 'POST') {
    $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 as JSON
    $services = isset($_POST['services']) ? json_encode($_POST['services']) : json_encode([]);
    
    // Handle featured image upload
    $featured_image = '';
    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 = $file_name;
        }
    }
    
    // Insert page
    $query = "INSERT INTO pages (title, slug, city, heading, featured_image, content, services, google_map_link, meta_title, meta_description, status) 
              VALUES ('$title', '$slug', '$city', '$heading', '$featured_image', '$content', '$services', '$google_map_link', '$meta_title', '$meta_description', '$status')";
    
    if (mysqli_query($conn, $query)) {
        $page_id = mysqli_insert_id($conn);
        
        // Handle gallery images
        if (!empty($_FILES['gallery_images']['name'][0])) {
            $gallery_images = [];
            $captions = json_decode($_POST['gallery_captions'] ?? '{}', true);
            
            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', $i)";
                        mysqli_query($conn, $gallery_query);
                        $gallery_images[] = $file_name;
                    }
                }
            }
            
            // Update page with gallery images JSON
            $gallery_json = json_encode($gallery_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: add-page.php?error=' . urlencode(mysqli_error($conn)));
    }
}
?>

Cancel