Tuesday, 28 December 2021

Sản phẩm mới, Sản phẩm xem nhiều, Tất cả sản phẩm, Phân trang-Phân nhóm 

<!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?>">&lt;&lt;</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?>">&gt;&gt;</a><?php }?>
    </p>
</div>
</body>
</html>

0 comments:

Post a Comment