File Manager

Editing File: /home/quiczmwg/solixproperties.org/fetch_apartments.php

<?php
// Assuming you have a database connection established in your main PHP file

@session_start();

include_once ("include/header.php");

// Check if the bedrooms parameter is set and not empty
if(isset($_GET['bedrooms']) && !empty($_GET['bedrooms'])) {
    $bedrooms = $_GET['bedrooms'];

// Perform a query to fetch apartments based on the number of bedrooms
    $query = "SELECT * FROM rentals WHERE bedroom_category = $bedrooms";

$result = mysqli_query($conn, $query);

// Check if there are any rows returned
    if(mysqli_num_rows($result) > 0) {
        // Start building HTML markup for displaying apartments
        while($row = mysqli_fetch_assoc($result)) {
            // Generate HTML markup for each apartment
            echo '<div class="col-lg-6 col-md-6 wow fadeInUp" data-wow-delay="0.1s">';
            echo '<div class="property-item rounded overflow-hidden">';
            echo '<div class="position-relative overflow-hidden">';
            echo '<a href=""><img class="img-fluid" src="img/property-1.jpg" alt=""></a>';
            echo '<div class="bg-primary rounded text-white position-absolute start-0 top-0 m-4 py-1 px-3">For Rent</div>';
            echo '<div class="bg-white rounded-top text-primary position-absolute start-0 bottom-0 mx-4 pt-1 px-3">Apartment</div>';
            echo '</div>';
            echo '<div class="p-4 pb-0">';
            echo '<h5 class="text-primary mb-3">$' . number_format($row['price']) . '</h5>';
            echo '<a class="d-block h5 mb-2" href="">Apartment For Rent</a>';
            echo '<p><i class="fa fa-map-marker-alt text-primary me-2"></i>123 Street, New York, USA</p>';
            echo '</div>';
            echo '<div class="d-flex border-top">';
            echo '<small class="flex-fill text-center border-end py-2"><i class="fa fa-ruler-combined text-primary me-2"></i>' . html_entity_decode($row['heights']) . ' Sqft</small>';
            echo '<small class="flex-fill text-center border-end py-2"><i class="fa fa-bed text-primary me-2"></i>' . html_entity_decode($row['bedroom_category']) . ' Bed</small>';
            echo '<small class="flex-fill text-center py-2"><i class="fa fa-bath text-primary me-2"></i>' . html_entity_decode($row['baths']) . ' Bath</small>';
            echo '</div>';
            echo '</div>';
            echo '</div>';
        }
    } else {
        // If no apartments are found, you can display a message
        echo '<p>No apartments found.</p>';
    }
} else {
    // If the bedrooms parameter is not set or empty, you can display a message
    echo '<p>Please select the number of bedrooms.</p>';
}

// Close the database connection if needed
mysqli_close($conn);
?>

Back to Directory File Manager