<!doctype html>
<html>
<head>
<meta charset="utf-8">
<title>Mới Nhất, Xem Nhiều</title>
<style>
#ds_sp{ width:620px; margin:auto;}
.sanpham{ width:120px; float:left; border:1px #2802E9 solid; margin-right:2px; margin-bottom:2px;}
.tieude{ font-size:20px; font-weight:bold; background-color: #230DE0; color:#F5EFEF; margin-top:10px; margin-bottom:10px;}
.ht{ font-size:20px; color:#E0070B; font-weight:bold;}
</style>
</head>
<body>
<?php
$link=@mysqli_connect("localhost","root","") or die("Không tìm thấy Sever");
mysqli_select_db($link,"webtintuc") or die("Không tồn tại DB");
mysqli_query($link,"set names 'utf8'");
$sp=5*4;
$sn=5;
$sl="select TenSP, UrlHinh, Gia from webtm_sanpham";
$kq=mysqli_query($link,$sl);
$tsp=mysqli_num_rows($kq);
$tst=ceil($tsp/$sp);
$tsn=ceil($tst/$sn);
if(isset($_GET['p'])){$p=$_GET['p']; $n=ceil($p/$sn);}
else if(isset($_GET['n'])){$n=$_GET['n']; $p=($n-1)*$sn+1;}
else $p=$n=1;
$vt=($p-1)*$sp;
?>
<div id="ds_sp">
<div class="tieude">Sản Phẩm Mới</div>
<?php
$slspm="select TenSP, UrlHinh, Gia from webtm_sanpham ORDER BY idSP DESC LIMIT 0,10";
$kqspm=mysqli_query($link,$slspm);
while($dspm=mysqli_fetch_array($kqspm))
{
?>
<div class="sanpham">
<p><img src="<?php echo $dspm['UrlHinh'];?>" width="120" height="180" alt=""/></p>
<p><?php echo $dspm['TenSP'];?><br/><?php echo $dspm['Gia'];?></p>
</div><?php }?>
<div class="tieude" style="clear:left;">Sản Phẩm Xem Nhiều</div>
<?php
$slspxn="select TenSP, UrlHinh, Gia from webtm_sanpham ORDER BY SoLanXem DESC LIMIT 0,5";
$kqspxn=mysqli_query($link,$slspxn);
while($dspxn=mysqli_fetch_array($kqspxn))
{
?>
<div class="sanpham">
<p><img src="<?php echo $dspxn['UrlHinh']?>" width="120" height="180" alt=""/></p>
<p><?php echo $dspxn['TenSP']?><br/><?php echo $dspxn['Gia']?></p>
</div><?php }?>
<div class="tieude" style="clear:left;">Tất cả sản phẩm</div>
<?php
$slsp="select TenSP, UrlHinh, Gia from webtm_sanpham limit $vt,$sp";
$kqsp=mysqli_query($link,$slsp);
while($dsp=mysqli_fetch_array($kqsp))
{
?>
<div class="sanpham">
<p><img src="<?php echo $dsp['UrlHinh'];?>" width="120" height="180" alt=""/></p>
<p><?php echo $dsp['TenSP'];?><br/><?php echo $dsp['Gia'];?></p>
</div>
<?php }?>
</div>
<div>
<p style="clear:left; text-align:center;">Trang
<?php if($n>1){?><a href="?n=<?php echo $n-1?>"><<</a><?php }?>
<?php
$dau=($n-1)*$sn+1;
$cuoi=$n*$sn;
if($cuoi>$tst) $cuoi=$tst;
for($i=$dau;$i<=$cuoi;$i++)
{
if($i==$p) echo "<span class='ht'>".$i."</span>";
else{
?>
<a href="?p=<?php echo $i;?>"><?php echo $i;?></a><?php }}?>
<?php if($n<$tsn){?><a href="?n=<?php echo $n+1?>">>></a><?php }?>
</p>
</div>
</body>
</html>
0 comments:
Post a Comment