1#@!#!123s

: / home / probwael / www /
Filename : property_listings.php
back
<?php
session_cache_expire(120);
ini_set('session.gc_maxlifetime', 7200); 
@session_start();

include("conn.php");

$em=$_SESSION["em"];
$_SESSION["loginto"]=$_SERVER["REQUEST_URI"];

$result=mysqli_query($conn, "select * from _register where email='$em' and status='online'") or die(mysqli_error($conn));
			  $crow = $result->fetch_assoc();
              $fullname=$crow['fullname'];
              $phone=$crow['phone'];
			  $postal=$crow['postal'];
			  $dbalance=$crow['dbalance'];

if (mysqli_num_rows($result)==0) 
{
$_SESSION["msg"]="<font color=red><b><a href='signup'><u>Click here to register</u></a> or login below to upload your property.</b></font>";
header("location: login");
}
else {

//used for menu			  
if (mysqli_num_rows($result)>0) { $online='yes'; } else { $online='no'; }

//get settings
$dsett = mysqli_query($conn, "select * FROM _security where id='1'") or die(mysqli_error($conn));
while($irow = $dsett->fetch_assoc()){
$dcompany=$irow['dcompany'];
$dlogo=$irow['dlogo'];
$dcomm_address=$irow['address'];
$dcomm_phone=$irow['dphone'];
$dcomm_phone2=$irow['dphone2'];
$dcomm_email=$irow['demail'];
$currency=$irow['icurrency'];
$web_title=$irow['dtitle'];
//social urls
$sfb=$irow['social_fb'];
$stw=$irow['social_tw'];
$sin=$irow['social_in'];
$sgp=$irow['social_gp'];
$slk=$irow['social_lk'];
}

$trid=$_GET['transid'];

//get product details
$gcart = mysqli_query($conn, "SELECT tprice FROM _dcart where transid='$transid'") or die(mysqli_error($conn));
$gcart2 = mysqli_query($conn, "SELECT tprice FROM _dcart where transid='$transid' group by transid") or die(mysqli_error($conn));
while($crow = $gcart->fetch_assoc()) {
$cprice=$crow['tprice'];
$ctprice=$ctprice+$cprice;
}
$ccount=mysqli_num_rows($gcart2);

$search=$conn->real_escape_string(htmlentities($_POST["search"],ENT_QUOTES));
if($search=='') {
$search=$conn->real_escape_string(htmlentities($_GET["search"],ENT_QUOTES));
}
?>

<!doctype html>
<html lang="en-US">
	
<!-- Mirrored from tk-themes.net/html-landmark/shop-list.html by HTTrack Website Copier/3.x [XR&CO'2014], Fri, 22 Jun 2018 15:45:11 GMT -->
<head>
		<meta http-equiv="Content-Type" content="text/html; charset=UTF-8"/>
		<meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=0"/>
		<link rel="shortcut icon" href="images/favicon.ico"/>
		<title>Add Property | SNSO</title>

		<link rel="stylesheet" href="css/bootstrap.min.css" type="text/css" media="all"/>
		<link rel="stylesheet" href="css/font-awesome.min.css" type="text/css" media="all"/>
		<link rel="stylesheet" href="css/ionicons.min.css" type="text/css" media="all" />
		<link rel="stylesheet" href="css/icon-moon.css" type="text/css" media="all" />
		<link rel="stylesheet" href="css/magnific-popup.min.css">
		<link rel="stylesheet" href="css/animate.css">
		<link rel="stylesheet" href="css/owl.carousel.css" type="text/css" media="all"/>
		<link rel="stylesheet" href="css/owl.theme.css" type="text/css" media="all"/>
		<link rel="stylesheet" href="css/style.css" type="text/css" media="all"/>
		<link rel="stylesheet" href="css/custom.css" type="text/css" media="all"/>
		<link rel="stylesheet" href="css/landmark-map.css" media="all"/>
		<link href="../../fonts.googleapis.com/cssa3ff.css?family=Poppins:100,100i,200,200i,300,300i,400,400i,500,500i,600,600i,700,700i,800,800i,900,900i%7CExo:100,100i,200,200i,300,300i,400,400i,500,500i,600,600i,700,700i,800,800i,900,900i" rel="stylesheet">

		<!-- HTML5 Shim and Respond.js IE8 support of HTML5 elements and media queries -->
		<!-- WARNING: Respond.js doesn't work if you view the page via file:// -->
		<!--[if lt IE 9]>
			<script src="https://oss.maxcdn.com/html5shiv/3.7.2/html5shiv.min.js"></script>
			<script src="https://oss.maxcdn.com/respond/1.4.2/respond.min.js"></script>
		<![endif]-->
	</head>
	<body>
		<div class="site">
			<? include("menu.php"); ?>
			<div id="main">
				<div class="section pt-7 pb-7">
					<div class="container" style="margin-top:-30px;">
						<h3>MANAGE PROPERTIES</h3>
						<hr>
						<div class="row">
							
							<div class="col-md-3">
							<? include("sidebar.php"); ?>
							</div>
							
							<div class="col-md-9">
								<b><? echo $_SESSION['msg']; ?></b>
			  					
							
							
							
							
<p>
<form method="post" action="property_listings" name="fs">
<div class="row">
<div class="col-md-8">
<input type="text" value="<? echo $search; ?>" name="search" placeholder="Enter search... you can search by Listing id, category or title." class="form-control">
</div>
<div class="col-md-3"><input type="submit" value=" Find " class="btn btn-success"></div>
</div>
</form>
</p>
<hr>
<?
$page_name="property_listings"; 
$start=$_GET['start'];
if(strlen($start) > 0 and !is_numeric($start)){
echo "Data Error";
exit;
}
$eu = ($start - 0); 
$limit = 20;// No of records to be shown per page.
$this1 = $eu + $limit; 
$back = $eu - $limit; 
$next = $eu + $limit; 
//:::::::::::::::::::::::::::::::::::;

$result = mysqli_query($conn, "SELECT * FROM _dlistings where demail='$em' and sid like '%$search%' and archived!='yes' or demail='$em' and ititle like '%$search%' and archived!='yes' order by id desc limit $eu, $limit") or die(mysqli_error($conn));
$counter = mysqli_query($conn, "SELECT * FROM _dlistings where demail='$em' and sid like '%$search%' and archived!='yes' or demail='$em' and ititle like '%$search%' and archived!='yes'") or die(mysqli_error($conn));
$nume=mysqli_num_rows($counter);

if($nume==0) {
echo "Nothing to display...";
}
else {

while($drow = $result->fetch_assoc()){
$qid=$drow['id'];
$sid=$drow['sid'];
$icategory=$drow['icategory'];
$subcat=$drow['subcat'];
$ititle=$drow['ititle'];
$descr=$drow['descr'];
$rprice=$drow['rprice'];
$dbeds=$drow['dbeds'];
$dbath=$drow['dbath'];
$dgarage=$drow['dgarage'];
$dsqm=$drow['dsqm'];
$dstate=$drow['dstate'];
$dlocation=$drow['dlocation'];

$prneg=$drow['prneg'];
$status=$drow['status'];
$transid=$drow['transid'];
$dtime=$drow['dtime'];
$iviews=$drow['iviews'];
$featured=$drow['featured'];
$dstatus=$drow['dstatus'];
//get default image
$quer=mysqli_query($conn, "select id, picid FROM _dpics where sid='$sid' and transid='$transid' order by status desc limit 1") or die(mysqli_error($conn));
if(mysqli_num_rows($quer)==0) {
$photo='images/nopic.gif';
}
else {
$prow = $quer->fetch_assoc();
$picid=$prow['picid'];
$photo='webcontrol/items/'.$picid.'.jpg';
}
?>					
						<!-- Property Main Box -->
						<div class="row">
							<div class="col-md-4">
								<a title="<? echo $ititle; ?>" href="#"><img src="<? echo $photo; ?>" alt="<? echo $ititle; ?>" style="height:180px; width:100%;  margin-bottom:10px;"></a>
							</div>
							<div class="col-md-6">
								<div class="property-details">
									<a title="<? echo $ititle; ?>" href="#"><b><? echo $ititle; ?> </b></a>
									<p><? echo substr($descr, 0, 60); ?>...<br>Product ID: <? echo $sid; ?></p>
									<p>Listing Fee: <? echo $rprice; ?></p>
									<p>Location: <? echo $dlocation; ?> <? echo $dstate; ?></p>
									<p><b>Status: <? echo $dstatus; ?></b><br></p>
								</div>
							</div>
							<div class="col-md-2">
								<p><a href="property_listing_edit?post=<? echo $qid; ?>" class="btn btn-primary btn-block">Edit</a> </p>
								<p><a href="property_listing_images?post=<? echo $qid; ?>" class="btn btn-primary btn-block">Images</a> </p>
								<p><a href="property_listing_delete?post=<? echo $qid; ?>" class="btn btn-primary btn-block"  onClick="return confirm('Are you sure that you want to DELETE <? echo $ititle; ?> completely ?')">Delete</a></p>
							</div>
						</div><!-- Property Main Box /- -->
						<hr>
<?
}
}
?>					
					
					<!-- Pagination -->
					<div class="listing-pagination">
						<ul class="pagination">
<?
if($nume>$limit) { 
$i=0;
$l=1;
for($i=0;$i < $nume;$i=$i+$limit){
if($i <> $eu){
echo " <li><a href='$page_name?start=$i&search={$search}&dcat={$dcat}' title='click to navigate to this page'>$l</a></li> ";
}
else { echo " <li  class='active'><a href='#'>$l</a></li>";
} 
$l=$l+1;
}
}	
?>						
						</ul>
					</div><!-- Pagination /- -->
					
					
												
							
							
							
							
							
							</div>
							
						</div>
					</div>
				</div>
			</div>
			<? include("footer.php"); ?>
		</div>
		<div id="go-to-top" class="go-to-top">
			<i class="fa fa-angle-up"></i>
		</div>
		
		<script src="js/jquery.min.js"></script>
		<script src="js/jquery-migrate.min.js"></script>
		<script src="js/bootstrap.min.js"></script>
		<script src="js/modernizr-2.7.1.min.js"></script>
		<script src="js/owl.carousel.min.js"></script>
		<script src="js/off-cavnass.js"></script>
		<script src="js/jquery.magnific-popup.min.js"></script>
		<script src="js/script.js"></script>

		<script src="js/core.min.js"></script>
		<script src="js/widget.min.js"></script>
		<script src="js/mouse.min.js"></script>
		<script src="js/slider.min.js"></script>
		<script src="js/jquery.ui.touch-punch.js"></script>
		<script src="js/price-slider.js"></script>
	</body>

<!-- Mirrored from tk-themes.net/html-landmark/shop-list.html by HTTrack Website Copier/3.x [XR&CO'2014], Fri, 22 Jun 2018 15:45:11 GMT -->
</html>
<?
$_SESSION['msg']='';
}
?>