File Explorer

<?php include('includes/db_config.php'); 
$record_per_page = 10;
$page = '';
if(isset($_GET["page"]))
{
 $page = $_GET["page"];
}
else
{
 $page = "1";
}
$sts="Active";
$start_from = ($page-1)*$record_per_page;
if(is_numeric($_GET['type'])){
  $type=intval($_GET['type']);   
  $propertyfor=($_GET['property-for']);   
  $status="Active";
 $sqlpt="select es_property.*,es_property_type.types from es_property join es_property_type on es_property.property_type=es_property_type.id join area on es_property.area_location=area.id where es_property.property_type='".$type."' and es_property.property_for=".$propertyfor." and es_property.status='".$status."' order by es_property.id DESC LIMIT " .$start_from. "," . $record_per_page; 
}elseif($_GET['area']){
  $area=intval($_GET['area']);   
    $propertyfor=($_GET['property-for']);   
  $status="Active";
 $sqlpt="select es_property.*,es_property_type.types from es_property join es_property_type on es_property.property_type=es_property_type.id join area on es_property.area_location=area.id where area.id='".$area."' and es_property.property_for=".$propertyfor." and es_property.status='".$status."' order by es_property.id DESC LIMIT " .$start_from. "," . $record_per_page; 
}elseif($_GET['price']){
   $price=($_GET['price']);   
  $names_str = explode("-",$price);
  $prange1=$names_str[0];
  $prange2=$names_str[1];
  $status="Active";
    $propertyfor=($_GET['property-for']);   
 $sqlpt="select es_property.*,es_property_type.types from es_property join es_property_type on es_property.property_type=es_property_type.id join area on es_property.area_location=area.id where (es_property.price >= ".$prange1." and es_property.price <= ".$prange2.")  and es_property.property_for=".$propertyfor." and es_property.status='".$status."' order by es_property.id DESC LIMIT " .$start_from. "," . $record_per_page; 
}

$resultp=mysqli_query($conn,$sqlpt); ?>
<!DOCTYPE html>
<html class="no-js" lang="zxx">

<head>
    <meta http-equiv="content-type" content="text/html; charset=UTF-8">
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0, user-scalable=0">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta content="" name="description">
    <meta content="" name="author">
    <meta name="keywords" content="">
    <link rel="shortcut icon" type="image/x-icon" href="https://www.feet2yards.com/img/favicon.png">
    <title>Feet 2 Yards</title>
    <?php include("includes/css.php");?>
</head>

<body class="main-body">
    <div class="horizontalMenucontainer">
        <?php include("includes/header.php");?>
        <div class="cover-image sptb-1 bg-background" data-image-src="https://www.feet2yards.com/img/banner1.jpg" style="background:  url(https://www.feet2yards.com/img/banner1.jpg) repeat scroll center center;">
            <div class="header-text1 mb-0">
                <div class="container">
                    <div class="row">
                        <div class="col-xl-8 col-lg-12 col-md-12 d-block mx-auto">
                            <div class="text-center text-white text-property">
                                <h1>Available Properties </h1>
                            </div> 
                        </div>
                    </div>
                </div>
            </div>
        </div>
        <div class="bg-white border-bottom">
            <div class="container">
                <div class="page-header">
                    <h4 class="page-title"> Property</h4>
                    <ol class="breadcrumb">
                        <li class="breadcrumb-item"><a href="https://www.feet2yards.com/">Home</a></li>
                        <li class="breadcrumb-item"><a href="#">Property</a></li>
                    </ol>
                </div>
            </div>
        </div>

<section class="sptb">
            <div class="container">
                <div class="row">
                  
                    <div class="col-xl-12 col-lg-12 col-md-12">
                        
                        <div class=" mb-lg-0">
                            <div class="">
                                <div class="item2-gl ">
                                    <div class="tab-content">
                                        <div class="tab-pane active" id="tab-11">
                                <?php  while($respt= mysqli_fetch_array($resultp)){ 
                                $sqlimg=mysqli_fetch_array(mysqli_query($conn,"SELECT * from es_property_image where property_id=".$respt['id']));
                               $uid=$respt['property_added'];
                               $idd=$respt['id'];
                             $resus=mysqli_fetch_array(mysqli_query($conn,"select * from es_property_user where id=".$uid));
                             $sqlcrt=mysqli_fetch_array(mysqli_query($conn,"select pricing_package_cart.*,plan_pricing.plan_name from pricing_package_cart join plan_pricing on pricing_package_cart.plan_id=plan_pricing.id where pricing_package_cart.puser_id=".$uid));
                             $plan_name = strtolower(str_replace(" ", "-", $sqlcrt['plan_name']));
                             $propt_name = strtolower(str_replace(" ", "-", $respt['property_name']));
                             $sql3= mysqli_fetch_array(mysqli_query($conn,"SELECT AVG(rating) AS myAvg FROM dproperty_enquiry WHERE property_id='$idd' GROUP BY property_id"));
                              ?>
                                            <div class="card overflow-hidden">
                                                <div class="d-md-flex">
                                                    <div class="item-card9-img">
                                                        <div class="arrow-ribbon bg-primary">₹ <?= $respt['price'];?></div>
                                                        <div class="item-card9-imgs"> <a href="https://www.feet2yards.com/property-services/<?= "$propt_name" ?>"></a> <img src="https://www.feet2yards.com/admin/product/image/<?= $sqlimg['images']; ?>" alt="img" class="cover-image"> </div>

<div class="item-tags">
                                                            <div class="bg-success tag-option">For <?= $respt['property_for'];?> </div>
                                                            <div class="bg-pink tag-option">Open </div>
                                                        </div>
                                                        <div class="item-trans-rating">
                                                            <div class="rating-stars block"> <input type="number" readonly="readonly" class="rating-value star" name="rating-stars-value" value="3">
                                                                <div class="rating-stars-container">
                                                                    <?php if($resrw['rating']==1){ ?> <div class="rating-star sm is--active"> <i class="fa fa-star"></i> </div>  <div class="rating-star sm "> <i class="fa fa-star"></i> </div><div class="rating-star sm "> <i class="fa fa-star"></i> </div>  <div class="rating-star sm "> <i class="fa fa-star"></i> </div>
                                                                    <div class="rating-star sm "> <i class="fa fa-star"></i> </div><?php }elseif($resrw['rating']==2){ ?> <div class="rating-star sm is--active"> <i class="fa fa-star"></i> </div> <div class="rating-star sm is--active"> <i class="fa fa-star"></i> </div>  <div class="rating-star sm "> <i class="fa fa-star"></i> </div><div class="rating-star sm "> <i class="fa fa-star"></i> </div><?php }elseif($resrw['rating']==3){ ?> <div class="rating-star sm is--active"> <i class="fa fa-star"></i> </div> <div class="rating-star sm is--active"> <i class="fa fa-star"></i> </div> <div class="rating-star sm is--active"> <i class="fa fa-star"></i> </div>  <div class="rating-star sm "> <i class="fa fa-star"></i> </div><div class="rating-star sm "> <i class="fa fa-star"></i> </div><?php }elseif($resrw['rating']==4){ ?> <div class="rating-star sm is--active"> <i class="fa fa-star"></i> </div> <div class="rating-star sm is--active"> <i class="fa fa-star"></i> </div> <div class="rating-star sm is--active"> <i class="fa fa-star"></i> </div> <div class="rating-star sm is--active"> <i class="fa fa-star"></i> </div>  <div class="rating-star sm "> <i class="fa fa-star"></i> </div><?php }elseif($resrw['rating']==5){ ?> <div class="rating-star sm is--active"> <i class="fa fa-star"></i> </div> <div class="rating-star sm is--active"> <i class="fa fa-star"></i> </div> <div class="rating-star sm is--active"> <i class="fa fa-star"></i> </div> <div class="rating-star sm is--active"> <i class="fa fa-star"></i> </div> <div class="rating-star sm is--active"> <i class="fa fa-star"></i> </div><?php } ?>
                                                                </div>
                                                            </div>
                                                        </div>
                                                    </div>
                                                    <div class="card border-0 mb-0" <?php if($plan_name != 'free-plan'){ echo "style='background-color:#dce2fa;'"; } ?>>
                                                        <div class="card-body ">
                                                            <div class="item-card9"> <a href="https://www.feet2yards.com/property-services/<?= "$propt_name" ?>" class="text-black mr-4">
                                                                    <h4 class="font-weight-bold mt-1"><i class="fa fa-tag mr-1"></i>  <?= $respt['property_name'];?></h4>
                                                                </a>
                                                                <div class="mb-2"> <a href="#" class="icons text-muted mr-4"><i class="fa fa-arrows-alt text-muted mr-1"></i> <?= $respt['area']." /". $respt['area_in'];?></a> <a href="#" class="icons text-muted mr-4"><i class="fa fa-bed text-muted mr-1"></i> <?= $respt['room'];?> Beds</a> <a href="#" class="icons text-muted mr-4"><i class="fa fa-bath text-muted mr-1"></i> <?= $respt['bathrooms'];?> Bath</a> <a href="#" class="icons text-muted mr-4"><i class="fa fa-car text-muted mr-1"></i> <?= $respt['garages'];?> Car</a> </div>
                                                                <p class="mb-0 leading-tight"><?php $string = html_entity_decode($respt['desp']); echo substr($string, 0, 200) .((strlen($string) > 200) ? '' : ''); ?></p>
                                                            </div>
                                                        </div>
                                                        <div class="card-footer pt-4 pb-4">
                                                            <div class="item-card9-footer d-flex">
                                                                <div class="item-card9-cost"> <a href="#" class="mr-4"><span class=""><i class="fa fa-map-marker text-muted mr-1"></i> <?= $respt['city'].",". $respt['state'];?></span></a> <a href="#" class=""><span class=""><i class="fa fa-user text-muted mr-1"></i> <?= $resus['personal_type']; ?></span></a> </div>
                                                                <div class="ml-auto"> <a href="#" class=""><span class=""><i class="fa fa-calendar-o text-muted mr-1"></i>
                                                                    <?php $now = new DateTime();
                                                                    $future_date = new DateTime($respt['created_now']);
                                                                    $interval = $future_date->diff($now);
                                                                    echo $interval->format("%a days"); ?> days ago</span></a> </div>
                                                            </div>
                                                        </div>
                                                    </div>
                                                </div>
                                            </div><?php } ?>
                                         
                                        </div>
                                    </div>
                                </div>
                                <div class="center-block text-center">
                                    <ul class="pagination mb-5 mb-lg-0">
                                <?php $sts="Active"; 
                                $page_query = "select es_property.*,es_property_type.types from es_property join es_property_type on es_property.property_type=es_property_type.id where es_property.status='".$sts."' order by es_property.id DESC";
                                $page_result = mysqli_query($conn, $page_query);
                                $total_records = mysqli_num_rows($page_result);
                                $total_pages = ceil($total_records/$record_per_page);
                                $start_loop = $page;
                                $difference = $total_pages - $page;
                                if($difference <= 1)
                                {
                                  $start_loop = $total_pages - 10;
                                }
                                 $end_loop = $start_loop + 9;
                                if($page > 1)
                                {
                                 echo "<a class='textpage' href='index.php?page=1&id=".$id."'>First</a>";
                                 echo "<a class='textpage' href='index.php?page=".($page - 0)."&id=".$id."'><<</a>";
                                }
                                for($i=$start_loop; $i<=$end_loop; $i++)
                                {     
                                  if($i > 0){
                                 echo "<a  class='textpage' href='index.php?page=".$i."&id=".$id."'>".$i."</a>";
                                }
                                }
                                if($page <= $end_loop)
                                {
                                 echo "<a class='textpage' href='index.php?page=".($page + 1)."&id=".$id."'>>></a>";
                                 echo "<a class='textpage' href='index.php?page=".$total_pages."&id=".$id."'>Last</a>";
                                }
                                ?>

</ul>
                                </div>
                            </div>
                        </div>
                        
                    </div>
                    
                </div>
            </div>
        </section>
        <?php include("includes/footer.php");?>
        <?php include("includes/js.php");?>
    </div>
</body>
</html>

Editing File: search-property.php