Friday, 24 December 2021

Kết hợp LỌC + PHÂN TRANG chungloaisp, loaisp, sanpham

<!doctype html>

<html>
<head>
<meta charset="utf-8">
<title>Untitled Document</title>
<style>
	.ht{ font-size:20px; color:#F40408; font-weight:bold;}
</style>
</head>

<body>
<form method="get" id="form1" name="form1">
<p>
<label>Chủng loại sp: </label>
<select name="chungloai" id="chungloai" onChange="form1.submit();">
<?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'");
	$sl="select * from webtm_chungloaisp";
	$kq=mysqli_query($link,$sl);
	$idCL=0;
	if(isset($_GET['chungloai'])) $idCL=$_GET['chungloai'];
	while($d=mysqli_fetch_array($kq))
	{
		if($idCL==0) $idCL=$d['idCL'];
?>
  <option value="<?php echo $d['idCL']?>" <?php if($idCL==$d['idCL']) echo "selected";?>><?php echo $d['TenCL']?></option>
  <?php }?>
</select>
</p>
<p>
<label>Loại sp: </label>
<select name="loaisp" id="loaisp" onChange="form1.submit();">
<?php
	$slloai="select * from webtm_loaisp where idCL=$idCL";
	$kqloai=mysqli_query($link,$slloai);
	$idLoai=0;
	//if(isset($_GET['loaisp'])) $idLoai=$_GET['loaisp'];
	while($dloai=mysqli_fetch_array($kqloai))
	{
		if($idLoai==0) $idLoai=$dloai['idLoai'];
?>
  <option value="<?php echo $dloai['idLoai'];?>" <?php if(isset($_GET['loaisp'])&&$_GET['loaisp']==$dloai['idLoai']) { echo "selected"; $idLoai=$_GET['loaisp'];} ?>><?php echo $dloai['TenLoai'];?></option>
  <?php }?>
</select>
</p>
</form>
<?php 
	$slsp="select TenSP, UrlHinh, Gia from webtm_sanpham where idLoai=$idLoai";
	$kqsp=mysqli_query($link,$slsp);
	$sp=5;
	$tsp=mysqli_num_rows($kqsp);
	$tst=ceil($tsp/$sp);
	if(isset($_GET['p'])) $p=$_GET['p'];
	else $p=1;
	$vt=($p-1)*$sp;
?>
<table width="500" border="1" cellspacing="0" cellpadding="0">
  <tbody>
    <tr>
      <th scope="col">STT</th>
      <th scope="col">Tên sản phẩm</th>
      <th scope="col">Hình</th>
      <th scope="col">Giá</th>
    </tr>
    <?php 
		$slsp2="select TenSP, UrlHinh, Gia from webtm_sanpham where idLoai=$idLoai limit $vt,$sp";
		$kqsp2=mysqli_query($link,$slsp2);
		$stt=1;
		while($dsp2=mysqli_fetch_array($kqsp2))
		{
	?>
    <tr>
      <td><?php echo $stt++;?></td>
      <td><?php echo $dsp2['TenSP'];?></td>
      <td><img src="<?php echo $dsp2['UrlHinh'];?>" width="70" alt=""/></td>
      <td><?php echo $dsp2['Gia'];?></td>
    </tr>
    <?php }?>
  </tbody>
</table>
<p>Trang 
<?php
for($i=1;$i<=$tst;$i++)
{
	if($i==$p) echo "<span class='ht'>".$i."</span>";
	else{
?>
<a href="loc_phantrang.php?p=<?php echo $i?>&chungloai=<?php echo $idCL;?>&loaisp=<?php echo $idLoai;?>"><?php echo $i;?></a> <?php }}?></p>
</body>
</html>
Database: https://drive.google.com/file/d/16mUt4iNR-FOraT1NAjtpXkPJVh3tPaiY/view
Hình ảnh: https://drive.google.com/file/d/19hJroj8BNEVV4_osAo2eXHspMciJb6LA/view

1 comment: