One Hat Cyber Team

Edit File Name : propertydetail.php

<?php
ini_set('session.cache_limiter', 'public');
session_cache_limiter(false);
session_start();
include("config.php");
include("functions.php");

?>
<!DOCTYPE html>
<html lang="en">

<head>
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <title>Home Property | Properties Details</title>

<link rel="shortcut icon" href="./frontend/img/riaprop_icon_logo.png" type="image/x-icon">

<link href="frontend/css/font-awesome.css" rel="stylesheet">
    
    <link href="frontend/css/bootstrap.css" rel="stylesheet">
    
    <link rel="stylesheet" type="text/css" href="frontend/css/slick.css">
    
    <link rel="stylesheet" type="text/css" href="frontend/css/nouislider.css">
    
    <link rel="stylesheet" href="frontend/css/jquery.fancybox.css" type="text/css" media="screen" />
    
    <link id="switcher" href="frontend/css/theme-color/default-theme.css" rel="stylesheet">

<link href="frontend/css/style.css" rel="stylesheet">

<link href='https://fonts.googleapis.com/css?family=Vollkorn' rel='stylesheet' type='text/css'>
    <link href='https://fonts.googleapis.com/css?family=Open+Sans' rel='stylesheet' type='text/css'>

</head>
<style>
    .icondetail i {
        font-size: 30px;
    }

.icondetail {
        text-align: center;
        margin-bottom: 20px;
    }
</style>

<section id="aa-property-header" style="background-image:url(images/dubai-banner-inner.jpg);">
        <div class="container">
            <div class="row">
                <div class="col-md-12">
                    <div class="aa-property-header-inner">
                        <h2>Properties Details</h2>
                        <ol class="breadcrumb">
                            <li><a href="#">HOME</a></li>
                            <li class="active">APPARTMENT TITLE</li>
                        </ol>
                    </div>
                </div>
            </div>
        </div>
    </section>

<section id="aa-properties">
        <div class="container">
            <div class="row">
                <div class="col-md-8">
                    <div class="aa-properties-content">
                        
                        <div class="aa-properties-details">
                            <?php
                            $id = $_REQUEST['pid'];
                            $query = mysqli_query($con, "SELECT property.*, user.*, state.sname, city.cname FROM `property`,`user`,state,city WHERE property.uid=user.uid and pid='$id' and state.sid=property.state and city.cid=property.city");
                            while ($row = mysqli_fetch_assoc($query)) {
                                /* echo '<pre>';
                        echo print_r($row);
                        echo '</pre>'; */
                            ?>
                                <div class="aa-properties-details-img">
                                    <?php if ($row['pimage'] != '') { ?>
                                        <img src="admin/property/<?php echo $row['pimage']; ?>" alt="img">
                                    <?php } ?>
                                    <?php if ($row['pimage1'] != '') { ?>
                                        <img src="admin/property/<?php echo $row['pimage1']; ?>" alt="img">
                                    <?php } ?>
                                    <?php if ($row['pimage2'] != '') { ?>
                                        <img src="admin/property/<?php echo $row['pimage2']; ?>" alt="img">
                                    <?php } ?>
                                    <?php if ($row['pimage3'] != '') { ?>
                                        <img src="admin/property/<?php echo $row['pimage3']; ?>" alt="img">
                                    <?php } ?>
                                    <?php if ($row['pimage4'] != '') { ?>
                                        <img src="admin/property/<?php echo $row['pimage4']; ?>" alt="img">
                                    <?php } ?>
                                </div>
                                <div class="aa-properties-info">
                                    <h2><?php echo $row['title']; ?></h2>
                                    <span class="aa-price"><?php echo $rowCurrency['currency'] . ' ' . $row['price']; ?></span>
                                    <div class="row icondetail">
                                        <div class="col-sm-3" style="border-right:1px solid">
                                            <i class="fa fa-bed" aria-hidden="true"></i><br>
                                            <?php echo $row['bedroom']; ?> Bedrooms
                                        </div>
                                        <div class="col-sm-3" style="border-right:1px solid">
                                            <i class="fa fa-tint" aria-hidden="true"></i><br>
                                            <?php echo $row['bathroom']; ?> Bathrooms
                                        </div>
                                        <div class="col-sm-3">
                                            <i class="fa fa-area-chart" aria-hidden="true"></i><br>
                                            <?php echo $row['size']; ?> sqft
                                        </div>
                                    </div>
                                    <?php echo $row['pcontent']; ?>
                                    
                                    <hr>
                                    <h4>Propery Details</h4>
                                    <div class="col-sm-12">
                                        <div class="col-sm-6" style="padding:0px;">
                                            <ul>
                                                <li>Property Type : <?php echo ucfirst($row['type']); ?></li>
                                                <li>Selling Type : <?php echo ucfirst($row['stype']); ?></li>
                                                <li>Bathroom : <?php echo $row['bathroom']; ?></li>
                                                <li>Kitchen : <?php echo $row['kitchen']; ?></li>
                                                <li>BHK : <?php echo $row['bhk']; ?></li>

</ul>
                                        </div>
                                        <div class="col-sm-6" style="padding:0px;">
                                            <ul>
                                                <li>Bedroom : <?php echo $row['bedroom']; ?></li>
                                                <li>Balcony : <?php echo $row['balcony']; ?></li>
                                                <li>Hall : <?php echo $row['hall']; ?></li>
                                                <li>Floor : <?php echo $row['floor']; ?></li>
                                                <li>Total Floor : <?php echo $row['totalfloor']; ?></li>
                                            </ul>
                                        </div>

</div>
                                    
                                </div>
                                
                                
                            <?php } ?>
                            
                            <div class="aa-nearby-properties">
                                <div class="aa-title">
                                    <h2>Recently Added Property</h2>
                                    <span></span>
                                </div>
                                <div class="aa-nearby-properties-area">
                                    <div class="row">
                                        <?php
                                        $query = mysqli_query($con, "SELECT * FROM `property` WHERE approval='approved' and status='available' ORDER BY date DESC LIMIT 2");
                                        while ($row = mysqli_fetch_assoc($query)) {
                                        ?>
                                            <div class="col-md-6">
                                                <article class="aa-properties-item">
                                                    <?php $image = ($row['pimage'] != '') ? 'admin/property/' . $row['pimage'] : 'images/houseplaceholder.png'; ?>
                                                    <a class="aa-properties-item-img" href="#">
                                                        <img alt="img" src="<?php echo $image; ?>">
                                                    </a>
                                                    <div class="aa-tag for-sale">
                                                        For <?php echo ucfirst($row['stype']); ?>
                                                    </div>
                                                    <div class="aa-properties-item-content">
                                                        <div class="aa-properties-info">
                                                            
                                                            <span><i class="fa fa-bed" aria-hidden="true"></i> <?php echo $row['bedroom']; ?> Bedroom</span>
                                                            <span><i class="fa fa-tint" aria-hidden="true"></i> <?php echo $row['bathroom']; ?> Bathroom</span>
                                                            <span><i class="fa fa-area-chart" aria-hidden="true"></i> <?php echo $row['size']; ?> sqft</span>
                                                        </div>
                                                        <div class="aa-properties-about">
                                                            <h3><a href="#"><?php echo $row['title']; ?></a></h3>
                                                            <p><?php echo get_excerpt($row['pcontent'], 10); ?></p>
                                                        </div>
                                                        <div class="aa-properties-detial">
                                                            <span class="aa-price">
                                                                <?php echo $rowCurrency['currency'] . ' ' . $row['price']; ?>
                                                            </span>
                                                            <a class="aa-secondary-btn" href="propertydetail.php?pid=<?php echo $row['pid']; ?>">View Details</a>
                                                        </div>
                                                    </div>
                                                </article>
                                            </div>
                                        <?php } ?>
                                    </div>
                                </div>

</div>

</div>
                    </div>
                </div>
                
                <div class="col-md-4">
                    <aside class="aa-properties-sidebar">
                        
                        <div class="aa-properties-single-sidebar">
                            <h3>Properties Search</h3>
                            <form method="get" action="property.php">
                                <div class="aa-single-advance-search">
                                    <select class="form-control" name="type">
                                        <option value="">Select Type</option>
                                        <option value="Apartment">Apartment</option>
                                        <option value="Villa">Villa</option>
                                        <option value="Townhouse">Townhouse</option>
                                        <option value="Penthouse">Penthouse</option>
                                        <option value="Compound">Compound</option>
                                        <option value="Duplex">Duplex</option>
                                        <option value="Full floor">Full floor</option>
                                        <option value="Whole Building">Whole Building</option>
                                        <option value="Bulk Rent Unit">Bulk Rent Unit</option>
                                        <option value="Bunglow">Bunglow</option>
                                        <option value="Hotel & Hotel Apartment">Hotel & Hotel Apartment</option>
                                    </select>
                                </div>
                                <div class="aa-single-advance-search">
                                    <select class="form-control" name="stype">
                                        <option value="">Select Status</option>
                                        <option value="Rent">Rent</option>
                                        <option value="Buy">Buy</option>
                                        <option value="Commercial Rent">Commercial Rent</option>
                                        <option value="Commercial Buy">Commercial Buy</option>
                                        <option value="New Projects">New Projects</option>
                                    </select>
                                </div>
                                <div class="aa-single-advance-search">
                                    <select class="form-control" name="state" id="state">
                                        <option value="">Select Emirate</option>
                                        <?php
                                        $query = mysqli_query($con, "select * from state");
                                        while ($row = mysqli_fetch_assoc($query)) {
                                        ?>
                                            <option value="<?php echo $row['sid'] ?>"><?php echo $row['sname'] ?></option>
                                        <?php } ?>
                                    </select>
                                </div>
                                <div class="aa-single-advance-search">
                                    <select class="form-control" name="city" id="city">
                                        <option value="">Select Location</option>
                                    </select>
                                </div>
                                
                                <div class="aa-single-advance-search">
                                    <input type="submit" value="Search" class="aa-search-btn">
                                </div>
                            </form>
                        </div>
                        
                        <div class="aa-properties-single-sidebar">
                            <h3>Featured Property</h3>
                            <?php
                            $query = mysqli_query($con, "SELECT * FROM `property` WHERE isFeatured = 1 and approval='approved' and status='available' ORDER BY date DESC LIMIT 3");
                            while ($row = mysqli_fetch_assoc($query)) {
                                /* echo '<pre>';
                                echo print_r($row);
                                echo '</pre>'; */
                            ?>
                                <div class="media">
                                    <div class="media-left">
                                        <?php $image = ($row['pimage'] != '') ? 'admin/property/' . $row['pimage'] : 'images/houseplaceholder.png'; ?>
                                        <a href="propertydetail.php?pid=<?php echo $row['pid']; ?>">
                                            <img class="media-object" src="<?php echo $image; ?>" alt="img">
                                        </a>
                                    </div>
                                    <div class="media-body">
                                        <h4 class="media-heading"><a href="propertydetail.php?pid=<?php echo $row['pid']; ?>"><?php echo $row['title']; ?></a></h4>
                                        <p><?php echo get_excerpt($row['pcontent'], 10); ?></p>
                                        <span><?php echo $rowCurrency['currency'] . ' ' . $row['price']; ?></span>
                                    </div>
                                </div>
                            <?php } ?>
                        </div>
                    </aside>
                </div>
            </div>
        </div>
    </section>

<?php include("include/footer.php"); ?>

<script src="frontend/js/jquery.min.js"></script>
    
    <script src="frontend/js/bootstrap.js"></script>
    
    <script type="text/javascript" src="frontend/js/slick.js"></script>
    
    <script type="text/javascript" src="frontend/js/nouislider.js"></script>
    
    <script type="text/javascript" src="frontend/js/jquery.mixitup.js"></script>
    
    <script type="text/javascript" src="frontend/js/jquery.fancybox.pack.js"></script>
    
    <script src="frontend/js/custom.js"></script>

</html>