1#@!#!123s

32759 1#@!#!123s
: / proc / thread-self / root / home / aissorg / www / admin / php /
Filename : room-pooja-sec-crud.php
back
<?php
header("Content-Type: application/json");

// Database connection
include('../include/config.php');

$action = $_GET['action'] ?? '';

switch ($action) {
    case 'read':
        $id = $_GET['id'] ?? null;

        if ($id) {
            $query = "SELECT * FROM room_pooja_sec WHERE id = ? AND is_active = 1 AND deleted_at IS NULL";
            $stmt = $con->prepare($query);
            $stmt->bind_param("i", $id);
        } else {
            $query = "SELECT * FROM room_pooja_sec WHERE is_active = 1 AND deleted_at IS NULL";
            $stmt = $con->prepare($query);
        }

        $stmt->execute();
        $result = $stmt->get_result();
        $about_entries = [];

        while ($row = $result->fetch_assoc()) {
            // Fetch related images from about_images table
            $images_query = "SELECT image_path FROM about_images WHERE about_id = ?";
            $images_stmt = $con->prepare($images_query);
            $images_stmt->bind_param("i", $row['id']);
            $images_stmt->execute();
            $images_result = $images_stmt->get_result();
            $images = [];

            while ($image_row = $images_result->fetch_assoc()) {
                $images[] = $image_row['image_path'];
            }

            $row['images'] = $images;
            $about_entries[] = $row;
        }

        echo json_encode(['success' => true, 'data' => $id ? ($about_entries[0] ?? null) : $about_entries]);
        break;

    case 'create':
        $title = $_POST['title'] ?? '';
        $description = $_POST['description'] ?? '';
        $description2 = $_POST['description2'] ?? ''; // New field
        $single_image = null;

        // Directory for uploads
        $target_dir = "../assets/img/about/";

        // Handle single image upload
        if (!empty($_FILES['single_image']['name'])) {
            $single_image = time() . '_' . basename($_FILES['single_image']['name']);
            $target_file = $target_dir . $single_image;
            move_uploaded_file($_FILES['single_image']['tmp_name'], $target_file);
        }

        // Insert main about data
        $query = "INSERT INTO room_pooja_sec (title, description, description2, single_image, is_active) VALUES (?, ?, ?, ?, 1)";
        $stmt = $con->prepare($query);
        $stmt->bind_param("ssss", $title, $description, $description2, $single_image); // Updated bind_param

        if ($stmt->execute()) {
            $about_id = $stmt->insert_id;

            // Handle multiple images upload
            if (!empty($_FILES['multiple_images']['name'][0])) {
                foreach ($_FILES['multiple_images']['name'] as $key => $image_name) {
                    if (!empty($image_name)) {
                        $image_name = time() . '_' . basename($image_name);
                        $target_file = $target_dir . $image_name;

                        if (move_uploaded_file($_FILES['multiple_images']['tmp_name'][$key], $target_file)) {
                            $image_query = "INSERT INTO about_images (about_id, image_path) VALUES (?, ?)";
                            $image_stmt = $con->prepare($image_query);
                            $image_stmt->bind_param("is", $about_id, $image_name);
                            $image_stmt->execute();
                        }
                    }
                }
            }

            echo json_encode(['success' => true, 'message' => 'About entry added successfully']);
        } else {
            echo json_encode(['success' => false, 'error' => $stmt->error]);
        }
        break;

    case 'update':
        $id = $_POST['id'] ?? 0;
        $title = $_POST['title'] ?? '';
        $description = $_POST['description'] ?? '';
        $description2 = $_POST['description2'] ?? ''; // New field
        $single_image = $_POST['existing_image'] ?? null;

        // Directory for uploads
        $target_dir = "../assets/img/about/";

        // Handle single image update
        if (!empty($_FILES['single_image']['name'])) {
            $single_image = time() . '_' . basename($_FILES['single_image']['name']);
            $target_file = $target_dir . $single_image;
            move_uploaded_file($_FILES['single_image']['tmp_name'], $target_file);
        }

        // Update main about data
        $query = "UPDATE room_pooja_sec SET title=?, description=?, description2=?, single_image=?, updated_at=NOW() WHERE id=?";
        $stmt = $con->prepare($query);
        $stmt->bind_param("ssssi", $title, $description, $description2, $single_image, $id); // Updated bind_param

        if ($stmt->execute()) {
            // Fetch existing images from the database
            $existing_images_query = "SELECT image_path FROM about_images WHERE about_id = ?";
            $existing_images_stmt = $con->prepare($existing_images_query);
            $existing_images_stmt->bind_param("i", $id);
            $existing_images_stmt->execute();
            $existing_images_result = $existing_images_stmt->get_result();
            $existing_images = [];

            while ($row = $existing_images_result->fetch_assoc()) {
                $existing_images[] = $row['image_path'];
            }

            // Handle new multiple images upload
            $new_images = [];
            if (!empty($_FILES['multiple_images']['name'][0])) {
                foreach ($_FILES['multiple_images']['name'] as $key => $image_name) {
                    if (!empty($image_name)) {
                        $image_name = time() . '_' . basename($image_name);
                        $target_file = $target_dir . $image_name;

                        if (move_uploaded_file($_FILES['multiple_images']['tmp_name'][$key], $target_file)) {
                            $new_images[] = $image_name;
                        }
                    }
                }
            }

            // Combine existing and new images
            $all_images = array_merge($existing_images, $new_images);

            // Ensure no more than 3 images are stored
            if (count($all_images) > 3) {
                echo json_encode(['success' => false, 'error' => 'You can only upload up to 3 images in total.']);
                return;
            }

            // Insert only new images into the database
            foreach ($new_images as $image_name) {
                $image_query = "INSERT INTO about_images (about_id, image_path) VALUES (?, ?)";
                $image_stmt = $con->prepare($image_query);
                $image_stmt->bind_param("is", $id, $image_name);
                $image_stmt->execute();
            }

            echo json_encode(['success' => true, 'message' => 'About entry updated successfully']);
        } else {
            echo json_encode(['success' => false, 'error' => $stmt->error]);
        }
        break;

        case 'delete_image':
            $imageName = $_GET['image'] ?? '';
    
            if (!empty($imageName)) {
                // Delete the image from the about_images table
                $query = "DELETE FROM about_images WHERE image_path = ?";
                $stmt = $con->prepare($query);
                $stmt->bind_param("s", $imageName);
    
                if ($stmt->execute()) {
                    // Define the path to the image on the server
                    $imagePath = "../assets/img/about/" . basename($imageName);
    
                    // Optionally delete the image file from the server
                    if (file_exists($imagePath)) {
                        unlink($imagePath); // Delete the file
                    }
    
                    echo json_encode(['success' => true, 'message' => 'Image deleted successfully.']);
                } else {
                    echo json_encode(['success' => false, 'error' => 'Error deleting image from database.']);
                }
            } else {
                echo json_encode(['success' => false, 'error' => 'Invalid request.']);
            }
            break;
    
        case 'delete':
            $id = $_GET['id'] ?? 0;
    
            // Soft delete
            $query = "UPDATE room_pooja_sec SET is_active = 0, deleted_at = NOW() WHERE id=?";
            $stmt = $con->prepare($query);
            $stmt->bind_param("i", $id);
    
            if ($stmt->execute()) {
                // Also delete related images
                $image_delete_query = "DELETE FROM about_images WHERE about_id = ?";
                $image_stmt = $con->prepare($image_delete_query);
                $image_stmt->bind_param("i", $id);
                $image_stmt->execute();
    
                echo json_encode(['success' => true, 'message' => 'About entry deleted successfully']);
            } else {
                echo json_encode(['success' => false, 'error' => $stmt->error]);
            }
            break;
    default:
        // No changes needed here
        break;
}
?>