1#@!#!123s

: / home / probwael / public_html /
Filename : shop-list.php
back
<?php
session_cache_expire(120);
ini_set('session.gc_maxlifetime', 7200); 
@session_start();

include("conn.php");

$em=$_SESSION["em"];
$_SESSION["room"]=$room;
$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) { $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'];
}

$transid=$_SESSION['transid'];
if($transid=='') {
$transid=date('ymdHis');
$_SESSION['transid']=$transid;
}

$dcat=$_GET['cat'];
if($dcat=='') { $dcat=$_POST['cat']; }
$search=$_GET['search'];
if($search=='') { $search=$_POST['search']; }

//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);

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

?>

<!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>Shop List | LandMark &#8211; RealEstate HTML Template</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">
						<div class="row">
							<div class="col-md-9">
								<!--div class="toolbar-products">
									<div class="product-style-control">
										View: 
										<span class="view-grid"><a href="shop-grid.html"><i class="fa fa-th-large"></i></a></span>
										<span class="view-list active"><i class="fa fa-th-list"></i></span>
									</div>
									<form class="commerce-ordering">
										<label>Sort By:</label>
										<select name="orderby" class="orderby">
											<option value="" selected="selected">Default sorting</option>
											<option value="">Sort by popularity</option>
											<option value="">Sort by average rating</option>
											<option value="">Sort by newness</option>
											<option value="">Sort by price: low to high</option>
											<option value="">Sort by price: high to low</option>
										</select>
									</form>
									<form class="commerce-product_per">
										<label>Show:</label>
										<select name="product_per">
											<option value="" selected="selected">4</option>
											<option value="">12</option>
											<option value="">18</option>
											<option value="">24</option>
											<option value="">30</option>
											<option value="">36</option>
											<option value="">40</option>
											<option value="">46</option>
											<option value="">50</option>
										</select>
									</form>
								</div-->
								<div class="product-list">
<?
$page_name="shop-list"; 
  $start=$_GET['start'];// 
  if(!($start > 0)) { 
  $start = 0;
}
$eu = ($start - 0);
$limit = 12; // No of records to be shown per page.
$thi = $eu + $limit;
$back = $eu - $limit;
$next = $eu + $limit;
//:::::::::::::::::::::::::::::::::::;

$dcategory=$conn->real_escape_string(htmlentities($_GET['dcategory'],ENT_QUOTES));
$result = mysqli_query($conn, "SELECT id, sid, icategory, subcat, ititle, descr, rprice, iprice, iquantity, tprice, prneg, status, transid, dtime, iviews, featured FROM _dproducts where archived!='yes' and icategory like '%$dcategory%' and ititle like '%$search%' or archived!='yes' and icategory like '%$dcategory%' and descr like '%$search%' order by id desc limit $eu, $limit") or die(mysqli_error($conn));
$counter = mysqli_num_rows(mysqli_query($conn, "SELECT id, sid, icategory, subcat, ititle, descr, rprice, iprice, iquantity, tprice, prneg, status, transid, dtime, iviews, featured FROM _dproducts where archived!='yes' and icategory like '%$dcategory%' and ititle like '%$search%' or archived!='yes' and icategory like '%$dcategory%' and descr like '%$search%'"));

while($drow = $result->fetch_assoc()){
include("product_details.php");
?>									
									<div class="product-item-list">
										<div class="featured-item">
											<a href="view_product_detail?pid=<? echo $pid; ?>&ititle=<? echo $ititle; ?>">
												<img src="<? echo $photo; ?>" alt="<? echo $ititle; ?>" style="height:300px;" />
											</a>
										</div>
										<div class="info-item">
											<h2 class="product-title">
												<a href="view_product_detail?pid=<? echo $pid; ?>&ititle=<? echo $ititle; ?>"><? echo $ititle; ?></a>
											</h2>
											<div class="stars-rating">
												<span style="width: 100%"></span>
											</div>
											<span class="price">&#8358;<? echo str_replace('.00','',number_format($iprice,2,'.',',')); ?></span>
											<hr />
											<p><? echo substr(nl2br($descr),0,100); ?>...</p>
											<div class="action">
												<a href="view_product_detail?pid=<? echo $pid; ?>&ititle=<? echo $ititle; ?>" class="button add-cart">Add to cart</a>
												
												<a href="view_product_detail?pid=<? echo $pid; ?>&ititle=<? echo $ititle; ?>" class="button add-cart">Details</a>
											</div>
										</div>
									</div>
<?
}

if(mysqli_num_rows($result)==0) {
echo '<center><p><br><br><br>Nothing to display under selected category... Please check again in a week or two.</p></center>';
echo '<center><p><br><a href="product-listing" class="btn btn-success btn-lg"> Click Here to View Our Menu</a></p></center>'; 
}
?>									
									
								</div>
								<span class="pagination-loop">
									<!--a class="prev page-numbers" href="#"><i class="ion-ios-arrow-back"></i></a>
									<a class="page-numbers" href="#">01</a>
									<span class="page-numbers current">02</span>
									<a class="page-numbers" href="#">03</a>
									<a class="next page-numbers" href="#"><i class="ion-ios-arrow-forward"></i></a-->
									<?
									if($counter>$limit) { 
									$i=0;
									$l=1;
									for($i=0;$i < $counter;$i=$i+$limit){
									if($i <> $eu){
									echo "<a href='$page_name?start=$i&search={$search}&dcategory={$dcategory}' class='page-numbers' title='click to navigate to this page'>$l</a>";
									}
									else { echo " <a href='#' class='page-numbers current'>$l</a>";
									} 
									$l=$l+1;
									}
									}	
									?>
								</span>
							</div>
							<div class="col-md-3">
								<div class="sidebar">
									<div class="widget">
										<h3 class="widget-title">Search</h3>
										<form class="form-search" method="post" action="shop-list">
											<input type="search" name="search" class="form-control" value="<? echo $search; ?>" placeholder="Search..." />
										</form>
									</div>
									<div class="widget">
										<h3 class="widget-title">Categories</h3>
										<ul class="sidebar-list">
											<li><a href="shop-list">View All</a></li>
											<?
											$qcat= "SELECT * FROM _dcategories";
											$rcatt = mysqli_query($conn,$qcat);
											while($rw = $rcatt->fetch_assoc()){
											?>
											<li><a href="shop-list?dcategory=<? echo $rw['dcat']; ?>"><? echo $rw['dcat']; ?></a></li>
											<? 
											}
											?>
										</ul>
									</div>
									
								</div>
							</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']='';
?>