Thursday, 16 December 2021

PHP#9MySQL#5 - locSP( b1.php, b2.php, b3.php) - Lọc sản phẩm

//connect.php
<?php
//Kết nối đến server DB:
	$link=@mysqli_connect("localhost","root","") or die("Không thể kết nối đến Server!");
	//Chọn database cần thao tác:
	mysqli_select_db($link,"webtintuc") or die("Không tồn tại DB này!");
	mysqli_query($link,"set names 'utf8'");
?>

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

<body>
<form id="form1" name="form1" method="get">
  <p>
    <label for="chungloai">Chủng loai sp:</label>
    <select name="chungloai" id="chungloai">
     <?php
		include("connect.php");
		$sl="select * from webtm_chungloaisp";
		$kq=mysqli_query($link,$sl);
		while($d=mysqli_fetch_array($kq)){
		?>
      <option value="<?php echo $d['idCL'];?>"><?php echo $d['TenCL'];?></option>
      <?php }?>
    </select>
    <input type="submit" name="thuchien" id="thuchien" value="loc">
  </p>
 <?php
	if(isset($_GET['chungloai']))
	{
		$idCL=$_GET['chungloai'];
		$slloai="select * from webtm_loaisp where idCL=$idCL";
		$kqloai=mysqli_query($link,$slloai);
	?>
  <p>
    <label for="loaisp">Loại sp::</label>
    <select name="loaisp" id="loaisp">
     <?php
		while($dloai=mysqli_fetch_array($kqloai))
		{
		?>
      <option value="<?php echo $dloai['idLoai'];?>"><?php echo $dloai['TenLoai'];?></option>
      <?php }?>
    </select>
  </p>
  <?php }?>
</form>
</body>
</html>

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

<body>
<form id="form1" name="form1" method="get">
  <p>
    <label for="chungloai">Chủng loai sp:</label>
    <select name="chungloai" id="chungloai" onChange="form1.submit();">
	<?php
		include("connect.php");
		$sl="select * from webtm_chungloaisp";
		$kq=mysqli_query($link,$sl);
		while($d=mysqli_fetch_array($kq)){
		?>
      <option value="<?php echo $d['idCL'];?>" <?php if(isset($_GET['chungloai'])&&$_GET['chungloai']==$d['idCL']) echo "selected";?>><?php echo $d['TenCL'];?></option>
      <?php }?>
    </select>
  </p>
 <?php
	if(isset($_GET['chungloai']))
	{
		$idCL=$_GET['chungloai'];
		$slloai="select * from webtm_loaisp where idCL=$idCL";
		$kqloai=mysqli_query($link,$slloai);
	?>
  <p>
    <label for="loaisp">Loại sp::</label>
    <select name="loaisp" id="loaisp">
     <?php
		while($dloai=mysqli_fetch_array($kqloai))
		{
		?>
      <option value="<?php echo $dloai['idLoai'];?>"><?php echo $dloai['TenLoai'];?></option>
      <?php }?>
    </select>
  </p>
  <?php }?>
</form>
</body>
</html>

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

<body>
<form id="form1" name="form1" method="get">
  <p>
    <label for="chungloai">Chủng loai sp:</label>
    <select name="chungloai" id="chungloai" onChange="form1.submit();">
	<?php
		include("connect.php");
		$sl="select * from webtm_chungloaisp";
		$kq=mysqli_query($link,$sl);
		$idCL=0;
		while($d=mysqli_fetch_array($kq))
		{
			if($idCL==0)$idCL=$d['idCL']; //giữ lại idCL của option đầu tiên
		?>
      <option value="<?php echo $d['idCL'];?>" <?php if(isset($_GET['chungloai'])&&$_GET['chungloai']==$d['idCL']) echo "selected";?>><?php echo $d['TenCL'];?></option>
      <?php }?>
    </select>
  </p>
 <?php
	if(isset($_GET['chungloai'])) $idCL=$_GET['chungloai']; //Gán lại giá trị cho $idCL khi người dùng chọn chủng loại khác (submit form)
	
		$slloai="select * from webtm_loaisp where idCL=$idCL";
		$kqloai=mysqli_query($link,$slloai);
	?>
  <p>
    <label for="loaisp">Loại sp::</label>
    <select name="loaisp" id="loaisp">
     <?php
		while($dloai=mysqli_fetch_array($kqloai))
		{
		?>
      <option value="<?php echo $dloai['idLoai'];?>"><?php echo $dloai['TenLoai'];?></option>
      <?php }?>
    </select>
  </p>
 
</form>
</body>
</html>

1 comment: