<div id="direct"><a href="index.php">Trang chủ</a> <span>></span> Thông tin, hướng dẫn, đánh giá máy may công nghiệp</div>
<div id="news">
	<div id="leftNews">
		<div class="leftNewsTitle">
			<div id="leftTitle"><a>Sản phẩm bán chạy</a></div>
<?php
$stmt=$conn->prepare("SELECT * FROM product LIMIT 4");
$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="productNews">
				<table width="100%">
					<tr>
						<td rowspan="2" width="30%"><img src="<?php echo $linkImageHot ?>" width="100%"></td>
						<td><?php echo $product['name']; ?></td>
					</tr>
					<tr>
						<td class="price"><?php echo number_format($product['price'])." đ"; ?></td>
					</tr>
				</table>
			</div></a>
<?php }?>			
		</div>
		<div class="leftNewsTitle">
			<div id="leftTitle"><a>Tin tức nổi bật</a></div>
<?php
$stmt=$conn->prepare("SELECT * FROM news WHERE del=0 LIMIT 0,4");
$stmt->execute();
$hots=$stmt->fetchAll(PDO::FETCH_ASSOC);
			foreach ($hots as $hots) { 
				$dates=date_create($hots['dateInsert']); 
				$dateInserts=date_format($dates, 'd \T\h\á\n\g m Y'); 
			?>
			<a href="news.php?id=<?php echo $hots['id'] ?>"><div class="News">
				<table width="100%">
					<tr>
						<td rowspan="2" width="40%"><img src="<?php echo $hots['image'] ?>" width="100%"></td>
						<td><?php echo mb_substr($hots['title'],0,20)."..."; ?></td>
					</tr>
					<tr>
						<td><?php echo $dateInserts; ?></td>
					</tr>
				</table>
			</div></a>
			<?php }?>
		</div><br>
		<div>
			<img src="//bizweb.dktcdn.net/100/322/718/themes/672827/assets/banner_sidebar_collection.png?1551235004055" width="100%">
		</div>
	</div>
	<div id="rightNews">
		<div id="rightTitle"><a>Thông tin, hướng dẫn, đánh giá máy may công nghiệp</a></div>
		<?php
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 news");
$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 news WHERE del=0 ".$limit);
$stmt->execute();
$news=$stmt->fetchAll(PDO::FETCH_ASSOC);
			foreach ($news as $news) { 
				$date=date_create($news['dateInsert']); 
				$dateInsert=date_format($date, 'd \T\h\á\n\g m Y'); 
			?>
		<div class="rightNewsContent">
			<div class="leftNews"><img src="<?php echo $news['image'] ?>" width="100%"></div>
			<div class="rightNews">
				<div>
					<a href="news.php?id=<?php echo $news['id'] ?>"><?php echo $news['title']; ?></a><br>
					<span><?php echo $dateInsert; ?> |</span>
					<div class="infoNews"><?php echo mb_substr($news['content'],0,450)."..."; ?></div>
				</div>
				<a href="news.php?id=<?php echo $news['id'] ?>">Đọc tiếp »</a>
			</div>
		</div>
			<?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>