File Manager

Editing File: /home/quiczmwg/affordablerealtycorporation.com/admin/manage-rental.php

<?php 
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);
include 'head.php';
include 'header.php';

@session_start();
if (!isset($_SESSION['userid'])) {
    header("Location: ./login.php");
    exit();
}

if (!$conn) {
    die("Connection failed: " . mysqli_connect_error());
}

$status = $message = '';

if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $uploadDirectory = '../uploads/';
    if (!is_writable($uploadDirectory)) {
        die('Upload directory is not writable.');
    }

$advertisement_id = uniqid('ad_');
    $userid = $_SESSION['userid'];
    $bedrooms = $_POST['bedrooms'];
        $location = $_POST['location'];

$baths = $_POST['baths'];
    $units = $_POST['units'];
    $heights = $_POST['heights'];
    $description = $_POST['description'];
    $price = $_POST['price'];
    $country = $_POST['country'];
    $state = $_POST['state'];
    $agent = $_POST['agent'];
    $type = $_POST['type'];
    $email = $_POST['email'];
    $phone = $_POST['phone'];

$locationType = $_POST['location-type'] ?? ''; // Get selected type
$neighborhood = isset($_POST[$locationType]) ? trim($_POST[$locationType]) : ''; // Get actual input value

if (empty($neighborhood)) {
    $status = 'error';
    $message = 'Please enter a valid location.';
} else {
        $uploadedImages = [];
        $uploadedVideos = [];

$isImageUploaded = !empty(array_filter($_FILES['image']['name']));
        $isVideoUploaded = !empty(array_filter($_FILES['video']['name']));

if (!$isImageUploaded && !$isVideoUploaded) {
            $status = 'error';
            $message = 'Please upload at least one photo or video.';
        } else {
            if ($isImageUploaded) {
                foreach ($_FILES['image']['tmp_name'] as $key => $tmp_name) {
                    $fileName = basename($_FILES['image']['name'][$key]);
                    $targetPath = $uploadDirectory . $fileName;

if ($_FILES['image']['error'][$key] !== UPLOAD_ERR_OK) {
                        $status = 'error';
                        $message = 'File upload error: ' . $_FILES['image']['error'][$key];
                        break;
                    }

if (file_exists($targetPath)) {
                        $status = 'error';
                        $message = 'File already exists';
                        break;
                    } else {
                        if (!move_uploaded_file($tmp_name, $targetPath)) {
                            $status = 'error';
                            $message = 'Failed to upload file.';
                            break;
                        } else {
                            $uploadedImages[] = $fileName;
                        }
                    }
                }
            }

if ($isVideoUploaded && $status !== 'error') {
                foreach ($_FILES['video']['tmp_name'] as $key => $tmp_name) {
                    $videoName = basename($_FILES['video']['name'][$key]);
                    $videoPath = $uploadDirectory . $videoName;

if ($_FILES['video']['error'][$key] !== UPLOAD_ERR_OK) {
                        $status = 'error';
                        $message = 'Video upload error: ' . $_FILES['video']['error'][$key];
                        break;
                    }

if (file_exists($videoPath)) {
                        $status = 'error';
                        $message = 'Video file already exists';
                        break;
                    } else {
                        if (!move_uploaded_file($tmp_name, $videoPath)) {
                            $status = 'error';
                            $message = 'Failed to upload video file.';
                            break;
                        } else {
                            $uploadedVideos[] = $videoName;
                        }
                    }
                }
            }

if ($status !== 'error') {
                $imagesJson = json_encode($uploadedImages);
                $videosJson = json_encode($uploadedVideos);

$sql = "INSERT INTO advertisement (advertisement_id, userid, bedrooms, location, baths, units, heights, description, price, country, state, neighborhood, agent, type, images, videos, email, phone) 
                        VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";

if ($stmt = $conn->prepare($sql)) {
                    $stmt->bind_param("ssssssssssssssssss", $advertisement_id, $userid, $bedrooms, $location, $baths, $units, $heights, $description, $price, $country, $state, $neighborhood, $agent, $type, $imagesJson, $videosJson, $email, $phone);

if ($stmt->execute()) {
                        $status = 'success';
                        $message = 'Apartment added successfully with Advertisement ID: ' . $advertisement_id;
                    } else {
                        $status = 'error';
                        $message = 'Failed to add the apartment. SQL Error: ' . $stmt->error;
                    }

$stmt->close();
                } else {
                    $status = 'error';
                    $message = 'SQL prepare failed: ' . $conn->error;
                }
            }
        }
    }
}

include 'sidebar.php';   
?>

<body class="skin-default fixed-layout">
    <div id="main-wrapper">
        <div class="page-wrapper">
            <div class="container-fluid">
                <?php include 'nav.php'; ?>
                <div class="container">
                    <div class="text-right my-3">
                        <button type="button" class="btn btn-success" data-toggle="modal" data-target="#myModal">
                            <i class="bi bi-plus"></i> Add Apartment
                        </button>
                    </div>
                </div>

<div class="modal fade" id="myModal">
                    <div class="modal-dialog">
                        <div class="modal-content">
                            
                            <div class="modal-header">
                                <h4 class="modal-title">Add Apartment</h4>
                                <button type="button" class="close" data-dismiss="modal">&times;</button>
                            </div>
                            
                            <div class="modal-body">
                                <form id="rentalForm" action="<?php echo htmlspecialchars($_SERVER["PHP_SELF"]); ?>" method="post" enctype="multipart/form-data">
                                    <input type="hidden" name="userid" value="<?php echo $_SESSION['userid']; ?>">
                                    
                                    <?php
                        // Display status message
                        if ($status) {
                            echo '<div style="color: ' . ($status === 'success' ? 'green' : 'red') . ';">' . $message . '</div>';
                        }
                    ?>
                        <div class="row">
                            <div class="col-md-6 my-2">
                                <label for="bedrooms">Select Bedroom:</label>
                                <select id="bedrooms" name="bedrooms" class="form-control" required>
                                    <option value="Studio">Studio</option>
                                    <option value="1">1 Bedroom</option>
                                    <option value="2">2 Bedroom</option>
                                    <option value="3">3 Bedroom</option>
                                    <option value="4">4 Bedroom</option>
                                    <option value="5">5 Bedroom</option>
                                    <option value="6">6 Bedroom</option>
                                </select>
                            </div>
                            <div class="col-md-6 my-2">
                                <div class="form-group">
                                    <label for="location">Enter apartment Location:</label>
                                    <input type="text" name="location" class="form-control my-2" required>
                                </div>
                            </div>
                        </div>

<div class="row">
                            <div class="col-md-6 my-2">
                                <label for="baths">Select Number of Bathrooms:</label>
                                <select id="baths" name="baths" class="form-control" required>
                                    <option value="1">1</option>
                                    <option value="2">2</option>
                                    <option value="3">3</option>
                                    <option value="4">4</option>
                                </select>
                            </div>
                            <div class="col-md-6 my-2">
                                <div class="form-group">
                                    <label for="height">Enter apartment Size:</label>
                                    <input type="text" name="heights" class="form-control my-2" required>
                                </div>
                            </div>
                        </div>

<div class="row">
                            <div class="col-md-6 my-2">
                                <div class="form-group">
                                    <label for="description">Enter apartment Description:</label>
                                    <textarea name="description" cols="30" rows="5" class="form-control my-2" required></textarea>
                                </div>
                            </div>
                            <div class="col-md-6 my-2">
                                <div class="form-group">
                                    <label for="price">Enter apartment Price:</label>
                                    <input type="number" id="price" name="price" class="form-control my-2" required>
                                </div>
                            </div>
                        </div>

<div class="row">
                            <div class="col-md-6 my-2">
                                <div class="form-group">
                                    <label for="Country">Enter apartment Country:</label>
                                    <input type="text" name="country" class="form-control my-2" required>
                                </div>
                            </div>
                            <div class="col-md-6 my-2">
                                <div class="form-group">
                                    <label for="state">Enter apartment state:</label>
                                    <input type="text" name="state" class="form-control my-2" required>
                                </div>
                            </div>
                        </div>
                          <div class="row">
    <div class="col-md-6 my-2">
        <div class="form-group">
            <label for="location-type">Select Location Type:</label>
            <select id="location-type" name="location-type" class="form-control my-2">
                <option value="">-- Select --</option>
                <option value="neighborhood">Neighborhood</option>
                <option value="city">City</option>
                <option value="district">District</option>
                <option value="county">County</option>
            </select>
        </div>
    </div>

<div class="col-md-6 my-2" id="location-input-container" style="display: none;">
        <div class="form-group">
            <label id="location-label" for="location">Enter apartment location:</label>
            <input type="text" id="location" class="form-control my-2" required>
        </div>
    </div>
</div>

<div class="row">
    <div class="col-md-6 my-2">
        <div class="form-group">
            <label for="units">Enter Number of Units:</label>
            <input type="number" id="units" name="units" class="form-control my-2" required>
        </div>
    </div>
</div>

<div class="row">
                            <div class="col-md-6 my-2">
                                <div class="form-group">
                                    <label for="email">Enter your Email:</label>
                                    <input type="email" name="email" class="form-control my-2" required>
                                </div>
                            </div>
                            <div class="col-md-6 my-2">
                                <div class="form-group">
                                    <label for="phone">Enter your Phone:</label>
                                    <input type="tel" name="phone" class="form-control my-2" required>
                                </div>
                            </div>
                        </div>

<div class="row">
                            <div class="col-md-6 my-2">
                                <label for="type">Type:</label>
                                <select id="type" name="type" required>
                                    <option value="For Rent">For Rent</option>
                                    <option value="For Sale">For Sale</option>
                                </select>
                            </div>
                            <div class="col-md-6 my-2">
                                <label for="image[]">Select Image:</label>
                                <input type="file" name="image[]" class="form-control my-2" accept="image/png, image/jpeg, image/webp" multiple>
                                
                            </div>
                        </div>
                        
<div class="row">
    <div class="col-md-6 my-2">
        <label for="video[]">Select Video:</label>
        <input type="file" name="video[]" class="form-control my-2" accept="video/mp4, video/webm, video/ogg" multiple>
    </div>
</div>

<button type="submit" name="add_rental" class="btn btn-success">Submit</button>
                                    <button type="button" class="btn btn-danger" data-dismiss="modal">Close</button>
                                </form>
                            </div>
                        </div>
                    </div>
                </div>

<section>
    <div class="container-fluid">
        <div class="card">
            <div class="card-body">
                <div class="table-responsive">
                    <table class="table">
                        <thead>
                            <tr>
                                <th>#</th>
                                <th>Rental Media</th>
                                <th>Bedrooms</th>
                                <th>Location</th>
                                <th>Price</th>
                                <th>Action</th>
                            </tr>
                        </thead>
                        <tbody>
                            <?php 
                                $select_rentals = mysqli_query($conn, "SELECT * FROM advertisement");
                                if (mysqli_num_rows($select_rentals) > 0) {
                                    $num = 1;
                                    while ($row = mysqli_fetch_assoc($select_rentals)) {
                            ?>
                            <tr>
                                <td><?php echo $num++; ?></td>
                                <td>
                                    <?php
                                    // Decode the images and videos JSON
                                    $images = json_decode($row['images'], true);
                                    $videos = json_decode($row['videos'], true);
                                    
                                    // Display the first image if available
                                    if (!empty($images)) {
                                        echo '<img src="../rental/' . htmlspecialchars($images[0]) . '" height="100" alt="Rental Image">';
                                    } else {
                                        echo 'No image available';
                                    }

// Display the first video if available
                                    if (!empty($videos)) {
                                        echo '<br><video height="100" controls>
                                                <source src="../rental/' . htmlspecialchars($videos[0]) . '" type="video/mp4">
                                                Your browser does not support the video tag.
                                              </video>';
                                    } else {
                                        echo '<br>No video available';
                                    }
                                    ?>
                                </td>
                                <td><?php echo htmlspecialchars($row['bedrooms']); ?></td>
                                <td><?php echo htmlspecialchars($row['location']); ?></td>
                                <td>$<?php echo number_format($row['price']); ?></td>
                                <td>
                                    <a href="rental-details.php?advertisement_id=<?php echo $row['advertisement_id']; ?>" class="btn btn-info btn-sm"><i class="bi bi-eye-fill" style="font-size: 20px;"></i></a>
                                </td>
                            </tr>
                            <?php 
                                    }
                                } 
                            ?> 
                        </tbody>
                    </table>
                </div>
            </div>
        </div>
    </div>
</section>

</div>
        </div>
    </div>  
    <?php include 'footer.php'; ?>
</body>

Back to Directory File Manager