<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="collections.php?type=<?php echo $type['id'] ?>&page=1"><?php echo $type['type'] ?></a></li>
						<?php } ?>
					</ul>
				</li>
			</ul>
		</div>
	</div>

	<div id="rightContent">
		<div id="rightTitle">Phụ tùng, linh kiện máy may công nghiệp và gia đình</div>
		<div id="rightDetail">Máy may Tín Sơn chuyên cung cấp linh phụ kiện, phụ tùng máy may công nghiệp và gia đình với tiêu chí linh kiện chất lượng và giá tốt nhất cho cá nhân và xưởng may.</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>
		<br>
<?php
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";
}
$page=$conn->prepare("SELECT COUNT(id) AS count FROM product WHERE type='4'");
$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 del=0 AND type='4'".$orderby.$limit);
$stmt->execute();
$product=$stmt->fetchAll(PDO::FETCH_ASSOC);
foreach ($product as $product) {
	$endDotHot=stripos($product['image'],".")+4;
	$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>
</div>