File "manage-rental-process.php"

Full Path: /home/quiczmwg/lightspringdigitals.com/admin-20260114051102/functions/manage-rental-process.php
File size: 3.79 KB
MIME-type: text/x-php
Charset: utf-8

<?php
include_once("../_db.php");

// Initialize variables
$status = $message = '';

if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['update_rental'])) {
    $rental_id = $_POST['rental_id'];
    $bedrooms = $_POST['bedrooms'];
    $baths = $_POST['baths'];
    $location = $_POST['location'];
    $heights = $_POST['heights'];
    $price = $_POST['price'];
    $description = $_POST['description'];
    $type = $_POST['type'];
    $country = $_POST['country'];
    
    // Check if all fields are filled
    if (empty($rental_id) || empty($bedrooms) || empty($baths) || empty($location) || empty($heights) || empty($price) || empty($description) || empty($type) || empty($country)) {
        $status = 'error';
        $message = 'Please fill all fields';
    } else {
        // Prepare update query
        $updateQuery = "UPDATE rentals SET bedroom_category=?, baths=?, location=?, heights=?, price=?, description=?, type=?, country=? WHERE rental_id=?";
        $updateStmt = $conn->prepare($updateQuery);

        // Check if prepare() was successful
        if ($updateStmt) {
            $updateStmt->bind_param("sssssssss", $bedrooms, $baths, $location, $heights, $price, $description, $type, $country, $rental_id);

            if ($updateStmt->execute()) {
                $status = 'success';
                $message = 'Rental updated successfully';

                // Check if a new image is uploaded
                if (!empty($_FILES['nft_img']['name'])) {
                    $uploadDirectory = '../rental/';
                    $fileName = basename($_FILES['nft_img']['name']);
                    $targetPath = $uploadDirectory . $fileName;

                    // Check if file already exists
                    if (file_exists($targetPath)) {
                        $status = 'error';
                        $message = 'File already exists';
                    } else {
                        // Upload file
                        if (!move_uploaded_file($_FILES['nft_img']['tmp_name'], $targetPath)) {
                            $status = 'error';
                            $message = 'Failed to upload file';
                        } else {
                            // Update image path in database
                            $updateImageQuery = "UPDATE rentals SET nft_img=? WHERE rental_id=?";
                            $updateImageStmt = $conn->prepare($updateImageQuery);

                            if ($updateImageStmt) {
                                $updateImageStmt->bind_param("ss", $fileName, $rental_id);
                                if ($updateImageStmt->execute()) {
                                    $status = 'success';
                                    $message = 'Rental and image updated successfully';
                                } else {
                                    $status = 'error';
                                    $message = 'Failed to update image path in database: ' . $updateImageStmt->error;
                                }
                            } else {
                                $status = 'error';
                                $message = 'Failed to prepare image update SQL statement: ' . $conn->error;
                            }
                        }
                    }
                }
            } else {
                $status = 'error';
                $message = 'Failed to execute update query: ' . $updateStmt->error;
            }
        } else {
            $status = 'error';
            $message = 'Failed to prepare SQL statement: ' . $conn->error;
        }
    }

    // Redirect to a different page or display status message
    // echo '<div style="color: ' . ($status === 'success' ? 'green' : 'red') . ';">' . $message . '</div>';
    header("Location: manage-rentals.php?status=$status&message=$message");
    exit();
}
?>