]]jkjjgdjffksdkdxmnvbcbcvbvcbbbbbbbbbvcbcbvcbmnmbnwqeqwewqskfgj

<?php require('inc/header.php'); //$prop = "SELECT * FROM property ORDER BY prop_id DESC"; $prop = "SELECT * FROM property INNER JOIN admin ON property.user_id COLLATE utf8mb4_unicode_ci = admin.id COLLATE utf8mb4_unicode_ci"; $run = mysqli_query($conn, $prop); $count = mysqli_num_rows($run); ?> <div class="main-wrapper"> <div class="main"> <div class="main-inner"> <div class="content-title"> <div class="content-title-inner"> <div class="container"> <h1>Properties</h1> <ol class="breadcrumb"> <li><a href="index.php">Home</a></li> <li><a href="property.php">Properties</a></li> </ol> </div> </div> </div> <div class="content"> <div class="container"> <div class="filter filter-gray push-bottom"> <form method="POST"> <div class="row"> <div class="col-md-3"> <div class="form-group"> <label>Location</label> <select class="form-control" required> <option>New York</option> <option>Washington</option> </select> </div> <!-- /.form-group --> </div> <!-- /.col-* --> <div class="col-md-3"> <div class="form-group"> <label>Keyword</label> <input type="text" class="form-control" required> </div> <!-- /.form-group --> </div> <!-- /.col-* --> <div class="col-md-2"> <div class="form-group"> <label>Price From</label> <input type="text" class="form-control" required> </div> <!-- /.form-group --> </div> <!-- /.col-* --> <div class="col-md-2"> <div class="form-group"> <label>Price To</label> <input type="text" class="form-control" required> </div> <!-- /.form-group --> </div> <!-- /.col-* --> <div class="col-md-2"> <div class="form-group-btn form-group-btn-placeholder-gap"> <button type="submit" class="btn btn-primary btn-block">Filter</button> </div> <!-- /.form-group --> </div> <!-- /.col-* --> </div> <!-- /.row --> <div class="row filter-options"> <div class="col-sm-6"> <div class="filter-sort"> <strong>Sort By</strong> <div class="checkbox-inline"> <label><input type="checkbox" name="filter-form-order" checked="checked"> Price</label> </div> <!-- /.checkbox --> <div class="checkbox-inline"> <label><input type="checkbox" name="filter-form-order" checked="checked"> Published</label> </div> <!-- /.checkbox --> </div> <!-- /.filter-sort --> </div> <!-- /.row --> <div class="col-sm-6"> <div class="filter-order"> <strong>Order By</strong> <div class="checkbox-inline"> <label><input type="radio" name="filter-form-order" checked="checked"> Asc</label> </div> <!-- /.checkbox --> <div class="checkbox-inline"> <label><input type="radio" name="filter-form-order"> Desc</label> </div> <!-- /.checkbox --> </div> <!-- /.filter-order --> </div> <!-- /.col-* --> </div> <!-- /.row --> </form> </div> <!-- /.filter --> <div class="row"> <div class="col-md-8 col-lg-9"> <div class="row"> <?php if($count > 0){ while($row = mysqli_fetch_assoc($run)){ ?> <div class="col-md-6 col-lg-4"> <div class="listing-box"> <div class="listing-box-image" style="background-image: url('realestate_admin/uploads/<?php echo $row['file'];?>')"> <div class="listing-box-image-label">Featured</div> <!-- /.listing-box-image-label --> <span class="listing-box-image-links"> <a href="javascript:void(0)"><i class="fa fa-heart"></i> <span>Add to favorites</span></a> <a href="property-details.php?propid=<?php echo $row['prop_id']?>"><i class="fa fa-search"></i> <span>View detail</span></a> <a href="javascript:void(0)"><i class="fa fa-balance-scale"></i> <span>Compare property</span></a> </span> </div> <!-- /.listing-box-image --> <div class="listing-box-title"> <h2><a href="property-details.php?propid=<?php echo $row['user_id']?>"><?php echo $row['property_name'];?></a></h2> <h3><?php echo $row['property_price'];?></h3> </div> <!-- /.listing-box-title --> <div class="listing-box-content"> <dl> <dt>Type</dt> <dd>House</dd> <dt>Location</dt> <dd><?php echo $row['property_location'];?></dd> <dt>Area</dt> <dd><?php echo $row['property_square'];?> sq</dd> </dl> </div> <!-- /.listing-box-cotntent --> </div> <!-- /.listing-box --> </div> <?php } }?> </div> <!-- /.row --> <div class="pagination-wrapper"> <ul class="pagination"> <li class="page-item disabled"> <a class="page-link" href="#" aria-label="Previous"> <span aria-hidden="true">&laquo;</span> <span class="sr-only">Previous</span> </a> </li> <li class="page-item"> <a class="page-link" href="#">1</a> </li> <li class="page-item"><a class="page-link" href="#">2</a></li> <li class="page-item active"><a class="page-link" href="#">3 <span class="sr-only">(current)</span></a></li> <li class="page-item"><a class="page-link" href="#">4</a></li> <li class="page-item"><a class="page-link" href="#">5</a></li> <li class="page-item"> <a class="page-link" href="#" aria-label="Next"> <span aria-hidden="true">&raquo;</span> <span class="sr-only">Next</span> </a> </li> </ul> <!-- /.pagination --> </div> <!-- /.pagination-wrapper --> </div> <!-- /.col-sm-* --> <div class="col-md-4 col-lg-3"> <div class="widget"> <h3 class="widgettitle">Best Agents</h3> <?php $prop = "SELECT * FROM property INNER JOIN admin ON property.user_id COLLATE utf8mb4_unicode_ci = admin.id COLLATE utf8mb4_unicode_ci"; $run = mysqli_query($conn, $prop); $count = mysqli_num_rows($run); if($count > 0){ while($ag = mysqli_fetch_assoc($run)){ ?> <div class="listing-small"> <div class="listing-small-inner"> <div class="listing-small-image"> <a href="javascript:void(0)" style="background-image: url('realestate_admin/uploads/<?php echo $ag['image'];?>');"></a> </div> <!-- /.listing-small-image --> <div class="listing-small-content"> <h3><a href="javascript:void(0)"><?php echo $ag['name'];?></a></h3> <h4><a href="mailto:<?php echo $ag['email'];?>"><?php echo $ag['email'];?></a></h4> </div> <!-- /.listing-small-content --> </div> <!-- /.listing-small-inner --> </div> <!-- /.listing-small --> <?php } } ?> </div> <!-- /.widget --> <div class="widget"> <ul class="nav nav-pills nav-stacked nav-style-secondary"> <li class="nav-item"><a href="#" class="nav-link"><i class="fa fa-download"></i> Download Footprints</a></li> <li class="nav-item"><a href="#" class="nav-link"><i class="fa fa-file-text"></i> PDF Version</a></li> <li class="nav-item"><a href="#" class="nav-link"><i class="fa fa-file"></i> Legal Document</a></li> </ul> <!-- /.menu --> </div> <!-- /.widget --> <div class="widget"> <h2 class="widgettitle">Contact Information</h2> <table class="contact"> <tbody> <tr> <th>Address:</th> <td>2300 Main Ave.<br>Lost Angeles, CA 23123<br>United States<br></td> </tr> <tr> <th>Phone:</th> <td>+0-123-456-789</td> </tr> <tr> <th>E-mail:</th> <td><a href="mailto:info@example.com">info@example.com</a></td> </tr> <tr> <th>Skype:</th> <td>your.company</td> </tr> </tbody> </table> </div> <!-- /.widget --> </div> <!-- /.col-* --> </div> <!-- /.row --> </div> <!-- /.container --> </div> </div> </div> </div> <div class="container"> <div class="call-to-action"> <div class="call-to-action-inner"> <div class="call-to-action-title"> <h1>Get in Touch With Us</h1> <h2>Interested in publishing your property on our website?</h2> </div> <!-- /.call-to-action-title --> <a href="#" class="btn btn-primary">Contact Us</a> </div> <!-- /.call-to-action-inner --> </div> <!-- /.call-to-action --> </div> <?php require('inc/footer.php'); ?>