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/news.php |
<?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>
AnonSec - 2021 | Recode By D7net