D7net Mini Sh3LL v1
Current File : C:/Domains/maymaytinson.com/httpdocs/lib/images/13/../10/../7/../16/../activity/../JUKI/../15/../zip_food/../18/../17/../2/../21/../20/../22/../5/../11/../7/../5/../22/../22/../../../upload/../upload/../conn/../include/collections.php |
<div id="direct"><a href="index.php">Trang chủ</a> <span>></span> Tất cả sản phẩm</div>
<div id="collection">
<div id="leftContent">
<div>DANH MỤC HÀNG HÓA<img align="center" src="lib/icons/menu.png"></div>
<div>
<ul id="category">
<!-- <li class="category"><a>Thương hiệu</a> <span class="arrow"><img src="lib/icons/down.png" align="center"><img src="lib/icons/up.png" align="center" hidden></span>
<ul class="subCategory1">
<?php
$stmt=$conn->prepare("SELECT id,name FROM trademark");
$stmt->execute();
$trademark=$stmt->fetchAll(PDO::FETCH_ASSOC);
$stt=1;
foreach ($trademark as $trademark) { ?>
<li class="category1"><a><?php echo $stt.". ".$trademark['name'];$stt++ ?></a> <span class="arrow"><img src="lib/icons/down.png" align="center"><img src="lib/icons/up.png" align="center" hidden></span>
<ul class="subCategory2">
<?php
$stmt=$conn->prepare("SELECT type.id as id,type.name as type FROM product JOIN type ON product.type=type.id WHERE trademark='".$trademark['id']."' GROUP BY type");
$stmt->execute();
$type=$stmt->fetchAll(PDO::FETCH_ASSOC);
foreach ($type as $type) { ?>
<li class="category2"><a href="?type=<?php echo $type['id'] ?>&trademark=<?php echo $trademark['id'] ?>&page=1"><?php echo $type['type'] ?></a></li>
<?php }
?>
</ul></li>
<?php }
?>
</ul>
</li> -->
<li class="category"><a>Sản phẩm</a> <span class="arrow"><img src="lib/icons/down.png" align="center"><img src="lib/icons/up.png" align="center" hidden></span>
<ul class="subCategory1">
<?php
$stmt=$conn->prepare("SELECT type.id as id,type.name as type FROM product JOIN type ON product.type=type.id GROUP BY type ASC");
$stmt->execute();
$type=$stmt->fetchAll(PDO::FETCH_ASSOC);
foreach ($type as $type) { ?>
<li class="category2"><a href="?type=<?php echo $type['id'] ?>&page=1"><?php echo $type['type'] ?></a></li>
<?php } ?>
</ul>
</li>
</ul>
</div>
</div>
<div id="rightContent">
<div id="slide">
<?php
$stmt=$conn->prepare("SELECT * FROM slide WHERE type=1 ORDER BY image DESC");
$stmt->execute();
$slide=$stmt->fetchAll(PDO::FETCH_ASSOC);
$count=count($slide);
?>
<input id="slideAmount" type='text' value='<?php echo $count; ?>' hidden>
<?php
foreach($slide as $slide){
?>
<img id="slide<?php echo $count;$count--; ?>" class="slide" src="<?php echo $slide['image'] ?>" width="100%">
<?php } ?>
<!-- <div id="prev"><</div>
<div id="next">></div> -->
</div>
<div id="rightTitle"><?php if(isset($_GET['type'])){
$stmt=$conn->prepare("SELECT id,name FROM type WHERE id='".$_GET['type']."'");
$stmt->execute();
$type=$stmt->fetch(PDO::FETCH_ASSOC);
echo $type['name'];
}if(isset($_GET['trademark'])){
$stmt=$conn->prepare("SELECT id,name FROM trademark WHERE id='".$_GET['trademark']."'");
$stmt->execute();
$trademark=$stmt->fetch(PDO::FETCH_ASSOC);
echo " ".$trademark['name'];
}if(!isset($_GET['type']) && !isset($_GET['trademark'])){
echo "Tất cả sản phẩm";
} ?></div>
<form id="sortForm">
<div id="sort">Sắp xếp: <select id="selectSort">
<option>-Vui lòng chon-</option>
<option value="0">Mặc định</option>
<option value="1">Giá tăng dần</option>
<option value="2">Giá giảm dần</option>
<option value="3">Từ A-Z</option>
<option value="4">Từ Z-A</option>
<option value="5">Mới đến cũ</option>
<option value="6">Cũ đến mới</option>
</select></div>
</form>
<br>
<?php
if(isset($_GET['keyword'])){
$wherek=" AND del=0 ";
$where=" WHERE del=0 ";
}if(!isset($_GET['keyword']) || isset($_GET['type'])){
$wherek=" WHERE del=0";
$where=" WHERE del=0";
}
if(isset($_GET['trademark'])){
$wherek.=" AND trademark='".$_GET['trademark']."'";
$where.=" AND trademark='".$_GET['trademark']."'";
if(isset($_GET['type'])){
$wherek.=" AND type='".$_GET['type']."'";
$where.=" AND type='".$_GET['type']."'";
}
}
if(!isset($_GET['trademark'])){
if(isset($_GET['type'])){
$wherek=" AND type='".$_GET['type']."'";
$where=" WHERE type='".$_GET['type']."'";
}
}else{
}
// $stmt=$conn->prepare("SELECT COUNT(id) as count FROM product ");
// $stmt->execute();
// $page=$stmt->fetch(PDO::FETCH_ASSOC);
// echo $page['count'];
if(!isset($_GET['sort'])){
$sort=0;
}else{
$sort=$_GET['sort'];
}
if($sort==0){
$orderby="";
}if($sort==1){
$orderby=" ORDER BY price ASC";
}if($sort==2){
$orderby=" ORDER BY price DESC";
}if($sort==3){
$orderby=" ORDER BY name ASC";
}if($sort==4){
$orderby=" ORDER BY name DESC";
}if($sort==5){
$orderby=" ORDER BY name ASC";
}if($sort==6){
$orderby=" ORDER BY name ASC";
}
if(!isset($_GET['page']) || $_GET['page']==1){
$limit=" LIMIT 0,12";
}else{
$_GET['page'];
$end=$_GET['page']*12;
$start=$end-12;
$limit=" LIMIT ".$start.",12";
}
if(isset($_GET['keyword'])){
$page=$conn->prepare("SELECT COUNT(id) AS count FROM product WHERE name LIKE '%".$_GET['keyword']."%'".$wherek);
$page->execute();
$pages=$page->fetch(PDO::FETCH_ASSOC);
$pages['count'];
$amountPages=$pages['count']/12;
$amountPages=floor($amountPages);
if($pages['count']%12 > 0){
$amountPages++;
}
$stmt=$conn->prepare("SELECT * FROM product WHERE name LIKE '%".$_GET['keyword']."%'".$wherek.$orderby.$limit);
}else{
$page=$conn->prepare("SELECT COUNT(id) AS count FROM product ".$where);
$page->execute();
$pages=$page->fetch(PDO::FETCH_ASSOC);
$pages['count'];
$amountPages=$pages['count']/12;
$amountPages=floor($amountPages);
if($pages['count']%12 > 0){
$amountPages++;
}
$stmt=$conn->prepare("SELECT * FROM product ".$where.$orderby.$limit);
}
$stmt->execute();
$product=$stmt->fetchAll(PDO::FETCH_ASSOC);
foreach ($product as $product) {
if($product['del']==0){
if(substr_count($product['image'], ".")>1){
$endDotHot=stripos($product['image'],".")+4;
}else{
$endDotHot=stripos($product['image'],".")+5;
}
$linkImageHot=substr($product['image'],0,$endDotHot);
?>
<a href="product.php?id=<?php echo $product['id']; ?>&direct=<?php echo $product['name']; ?>">
<div class="product">
<div class="detailProduct">
<div class="hinh"><img src="<?php echo $linkImageHot; ?>" height="100%"></div>
<div class="info"><?php if(strlen($product['name'])<60){ echo $product['name']; }else{ echo mb_substr($product['name'],0,50)."...";} ?></div>
<div class="price">
<?php if($product['discount']>0){?>
<span class="discount"><?php } ?>
<?php if(is_numeric($product['price'])){ echo number_format($product['price'])." đ";}
if($product['discount']>0){ echo "
</span>";$product['price']-=$product['discount'];echo number_format($product['price'])." đ";
}if(!is_numeric($product['price'])){ echo "Liên Hệ"; } ?></div>
</div>
</div>
</a>
<?php }}?>
<div id="page">
<?php if(isset($_GET['page'])){
$startUrl=strrpos($_SERVER['REQUEST_URI'], "/")+1;
$endUrl=(strrpos($_SERVER['REQUEST_URI'], "=")+1)-$startUrl;
$url=substr($_SERVER['REQUEST_URI'],$startUrl,$endUrl);
if($_GET['page']>1){ ?>
<a href="<?php echo $url.($_GET['page']-1); ?>"><img src="lib/icons/prev.png" align="center"></a>
<?php } for ($i=$_GET['page']-1; $i <= $_GET['page']+4; $i++) {if($i>0 && $i<=$amountPages){ ?>
<a class='page' id="p<?php echo $i; ?>" href="<?php echo $url ?><?php echo $i; ?>"><?php echo $i; ?></a>
<?php }}if(($i-1)<$amountPages){ ?><a>...</a><?php }if($_GET['page']<$amountPages){ ?>
<a href="<?php echo $url.($_GET['page']+1); ?>"><img src="lib/icons/next.png" align="center"></a>
<?php }} ?>
</div>
</div>
</div>
AnonSec - 2021 | Recode By D7net