<?php
$stmt=$conn->prepare("SELECT *,member.name AS nameCreator FROM news JOIN member ON member.id=news.creator WHERE news.id='".$_GET['id']."'");
$stmt->execute();
$news=$stmt->fetch(PDO::FETCH_ASSOC);
$date=date_create($news['dateInsert']); 
$dateInsert=date_format($date, 'd \T\h\á\n\g m Y'); 
?>
<div id="direct"><a href="index.php">Trang chủ</a> <span>></span> <a href="tintuc.php">Tin tức</a> <span>> <?php echo $news['title']; ?></span></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"><i><h2><?php echo $news['title']; ?></h2></i><span id="datePost"><?php echo $dateInsert; ?> | Đăng bởi: <?php echo $news['nameCreator']; ?></span></div>
		<div>
			<img width="100%" src="<?php echo $news['image'] ?>"><br><br>
			<?php echo nl2br($news['content']); ?>
		</div>
</div>