Sunday, 19 December 2021

Cách 2: LỌC SẢN PHẨM: Chủng Loại --->Loại-->Sản Phẩm

Database: https://drive.google.com/file/d/16mUt4iNR-FOraT1NAjtpXkPJVh3tPaiY/view

Hình ảnh: https://drive.google.com/file/d/19hJroj8BNEVV4_osAo2eXHspMciJb6LA/view

<!doctype html>

<html>
<head>
<meta charset="utf-8">
<title>Untitled Document</title>
</head>

<body>
<form method="get" id="form1" name="form1">
  <p>
    <label for="loaisp">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;
		while($d=mysqli_fetch_array($kq))
		{
			if($idCL==0) $idCL=$d['idCL'];
	?>
      <option value="<?php echo $d['idCL'];?>" <?php if(isset($_GET['chungloai'])&&$_GET['chungloai']==$d['idCL']) {echo "selected";$idCL=$_GET['chungloai'];}?>><?php echo $d['TenCL'];?></option>
      <?php }?>
    </select>
  </p>
  <p>
    <label for="loaisp">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;
		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);
	?>
<table width="800" border="1">
  <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
		$stt=1;
		while($dsp=mysqli_fetch_array($kqsp)){
		?>
    <tr>
      <td><?php echo $stt++; ?></td>
      <td><?php echo $dsp['TenSP']; ?></td>
      <td><img src="<?php echo $dsp['UrlHinh']; ?>" width="100" alt=""/></td>
      <td><?php echo $dsp['Gia']; ?></td>
    </tr>
    <?php }?>
  </tbody>
</table>

</body>
</html>

1 comment:

  1. AnonymousSaturday, April 09, 2022 7:35:00 pm

    Merkur Slots Machines - SEGATIC PLAY - Singapore
    Merkur Slot wooricasinos.info Machines. 5 star rating. https://septcasino.com/review/merit-casino/ The goyangfc.com Merkur Casino game was poormansguidetocasinogambling the first to feature video slots in the worrione entire casino,

    ReplyDelete