//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>
onChange="form1.submit();"
ReplyDelete