Saturday, 15 January 2022

PHP#19MySQL#15 - Loại tin, Thêm, Sửa, Xử lý

//connect.php

<?php 
	$link=@mysqli_connect("localhost","root","") or die("Không tìm thấy Sever");
	mysqli_select_db($link,"tintuc") or die("Không tồn tại DB");
	mysqli_query($link,"set names 'utf8'");
?>

//loaitin.php

<!doctype html>
<html>
<head>
<meta charset="utf-8">
<title>Loại Tin</title>
</head>

<body>
<?php
	include("../connect.php");
	if(isset($_GET['lang'])) $lang=$_GET['lang'];
	else $lang="vi";
?>
<form method="get" id="form1" name="form1">
  <p>
    <label for="loaitin">Chọn ngôn ngữ:</label>
    <select name="lang" id="lang" onChange="form1.submit();">
      <option value="vi">Việt</option>
      <option value="en"<?php if($lang=="en") echo "selected";?>>English</option>
    </select>
  </p>
  <p>
    <label for="theloai">Thể loại:</label>
    <select name="theloai" id="theloai" onChange="form1.submit();">
	<?php 
		$sl="select * from theloai where lang='$lang' order by ThuTu";
		$kq=mysqli_query($link,$sl);
		$idTL=0;
		while($d=mysqli_fetch_array($kq))
		{
			if($idTL==0) $idTL=$d['idTL'];
	?>
      <option value="<?php echo $d['idTL'];?>"<?php if(isset($_GET['theloai'])&&$_GET['theloai']==$d['idTL']) {echo "selected"; $idTL=$_GET['theloai'];}?>><?php echo $d['TenTL'];?></option>
      <?php }?>
    </select>
  </p>
</form>
<table width="700" border="1" cellspacing="0" cellpadding="0">
  <tbody>
    <tr>
      <th scope="col">Thứ tự</th>
      <th scope="col">Tên loại</th>
      <th scope="col">Tên không dấu</th>
      <th scope="col">Trạng thái</th>
      <th scope="col"><a href="loaitin_them.php?lang=<?php echo $lang;?>&idTL=<?php echo $idTL;?>">Thêm</a></th>
    </tr>
    <?php 
		$sl="select * from loaitin where idTL=$idTL order by ThuTu";
		$kq=mysqli_query($link,$sl);
		while($d=mysqli_fetch_array($kq)){
	?>
    <tr>
      <td><?php echo $d['ThuTu'];?></td>
      <td><?php echo $d['Ten'];?></td>
      <td><?php echo $d['Ten_KhongDau'];?></td>
      <td><?php if($d['AnHien']) echo "Hiện"; else echo "Ẩn";?></td>
      <td><a href="process.php?xoalt=<?php echo $d['idLT']?>&lang=<?php echo $lang;?>" onClick="return confirm('Bạn có muốn xóa thể loại này không?')";>Xóa</a>/<a href="loaitin_sua.php?idLT=<?php echo $d['idLT']?>&lang=<?php echo $lang;?>">Sửa</a></td>
    </tr>
    <?php }?>
  </tbody>
</table>

</body>
</html>


//loaitin_sua.php

<!doctype html>
<html>
<head>
<meta charset="utf-8">
<title>loaitin_sua</title>
</head>

<body>
<?php
if(isset($_GET['idLT']))
{
	$idLT=$_GET['idLT'];
	include("../connect.php");
	$kqlt=mysqli_query($link,"select * from loaitin where idLT=$idLT");
	$dlt=mysqli_fetch_array($kqlt);
	
	if(isset($_GET['lang'])) $lang=$_GET['lang'];
	else $lang=$dlt['lang'];
	
	$sl="select * from theloai where lang='$lang' order by ThuTu";
	$kq=mysqli_query($link,$sl);
?>
<form method="get" id="form1" name="form1" action="">
  <p>
  <label>Ngôn ngữ</label>
  <select name="lang" id="lang" onChange="form1.submit();">
    <option value="vi">Việt</option>
    <option value="en"<?php if($lang=="en") echo "selected";?>>English</option>
  </select>
  <input type="hidden" name="idLT" value="<?php echo $idLT;?>"
  </p>
</form>
<form method="post" id="form2" name="form2" action="process.php">
  <p>
  <label for="idTL">Thể loại</label>
  <select name="idTL" id="idTL">
  <?php 
  	while($d=mysqli_fetch_array($kq)){
  ?>
    <option value="<?php echo $d['idTL'];?>" <?php if($dlt['idTL']==$d['idTL']) echo "selected";?>><?php echo $d['TenTL'];?></option>
    <?php }?>
  </select>
  </p>
  <p>
    <label for="Ten">Tên loại:</label>
    <?php 
	
	?>
    <input type="text" name="Ten" id="Ten" value="<?php echo $dlt['Ten'];?>">
  </p>
  <p>
    <label for="Ten_KhongDau">Ten KD:</label>
    <input type="text" name="Ten_KhongDau" id="Ten_KhongDau" value="<?php echo $dlt['Ten_KhongDau'];?>">
  </p>
  <p>
    <label for="ThuTu">Thứ tự:</label>
    <input type="text" name="ThuTu" id="ThuTu" value="<?php echo $dlt['ThuTu'];?>">
  </p>
  <p>
    <label for="AnHien">Ẩn hiện:</label>
    <select name="AnHien" id="AnHien">
      <option value="0">Ẩn</option>
      <option value="1" <?php if($dlt['AnHien']) echo "selected";?>>Hiện</option>
    </select>
  </p>
  <p>
  <input type="hidden" name="lang" value="<?php echo $lang;?>">
  <input type="hidden" name="idLT" value="<?php echo $idLT;?>"/>
  <input type="submit" name="sua_lt" id="sua_lt" value="Cập nhật">
  </p>
</form>
<?php }?>
</body>
</html>



//loaitin_them.php
<!doctype html>
<html>
<head>
<meta charset="utf-8">
<title>loaitin_them</title>
</head>

<body>
<?php 
	if(isset($_GET['lang'])) $lang=$_GET['lang'];
	else $lang="vi";
	include("../connect.php");
	$sl="select * from theloai where lang='$lang' order by ThuTu";
	$kq=mysqli_query($link,$sl);
?>
<form method="get" id="form1" name="form1" action="">
  <p>
  <label>Ngôn ngữ</label>
  <select name="lang" id="lang" onChange="form1.submit();">
    <option value="vi">Việt</option>
    <option value="en"<?php if($lang=="en") echo "selected";?>>English</option>
  </select>
  </p>
</form>
<form method="post" id="form2" name="form2" action="process.php">
  <p>
  <label>Thể loại</label>
  <select name="idTL" id="idTL">
  <?php 
  	while($d=mysqli_fetch_array($kq)){
  ?>
    <option value="<?php echo $d['idTL'];?>" <?php if(isset($_GET['idTL'])&&$_GET['idTL']==$d['idTL']) echo "selected";?>><?php echo $d['TenTL'];?></option>
    <?php }?>
  </select>
  </p>
  <p>
    <label for="Ten">Tên loại:</label>
    <input type="Ten" name="Ten" id="Ten">
  </p>
  <p>
    <label for="Ten_KhongDau">Ten KD:</label>
    <input type="Ten_KhongDau" name="Ten_KhongDau" id="Ten_KhongDau">
  </p>
  <p>
    <label for="ThuTu">Thứ tự:</label>
    <input type="ThuTu" name="ThuTu" id="ThuTu">
  </p>
  <p>
    <label for="AnHien">Ẩn hiện:</label>
    <select name="AnHien" id="AnHien">
      <option value="0">Ẩn</option>
      <option value="1">Hiện</option>
    </select>
  </p>
  <p>
  <input type="hidden" name="lang" value="<?php echo $lang;?>">
  <input type="submit" name="them_lt" id="them_lt" value="Thêm">
  </p>
</form>
</body>
</html>


//process.php
<?php 
	include("../connect.php");
	if(isset($_POST['themtl']))
	{
		$sl="insert into theloai values(NULL,'{$_POST['lang']}', '{$_POST['TenTL']}', '{$_POST['TenTL_KhongDau']}', {$_POST['ThuTu']}, {$_POST['AnHien']})";
		if(mysqli_query($link,$sl))
			header("location:theloai.php?lang=".$_POST['lang']);
		else echo $sl;
	}
	//Xửa lý sửa 1 thể loại:
	if(isset($_POST['suatl']))
	{
		$sl="update theloai set lang='{$_POST['lang']}', TenTL='{$_POST['TenTL']}', TenTL_KhongDau='{$_POST['TenTL_KhongDau']}',
		ThuTu={$_POST['ThuTu']}, AnHien={$_POST['AnHien']} where idTL={$_POST['idTL']}";
		if($kq=mysqli_query($link,$sl))
			header("location:theloai.php?lang=".$_POST['lang']);
		else echo $sl;
	}
	//Xử lý xóa 1 thể loại:
	if(isset($_GET['xoatl']))
	{
		$sl="delete from theloai where idTL=".$_GET['xoatl'];
		if($kq=mysqli_query($link,$sl))
			header("location:theloai.php?lang=".$_GET['lang']);
		else echo $sl;
	}
	//Xửa lý thêm 1 loại tin:
	if(isset($_POST['them_lt']))
	{
		$sl="insert into loaitin values(NULL,'{$_POST['lang']}', '{$_POST['Ten']}', '{$_POST['Ten_KhongDau']}', {$_POST['ThuTu']}, {$_POST['AnHien']}, {$_POST['idTL']})";
		if(mysqli_query($link,$sl))
			header("location:loaitin.php?lang=".$_POST['lang']."&theloai=".$_POST['idTL']);
		else echo $sl;
	}
	//sửa lý cập nhật 1 loại tin
	if(isset($_POST['sua_lt']))
	{
		{
		$sl="update loaitin set lang='{$_POST['lang']}', Ten='{$_POST['Ten']}', Ten_KhongDau='{$_POST['Ten_KhongDau']}',
		ThuTu={$_POST['ThuTu']}, AnHien={$_POST['AnHien']}, idTL={$_POST['idTL']} where idLT={$_POST['idLT']}";
		if($kq=mysqli_query($link,$sl))
			header("location:loaitin.php?lang=".$_POST['lang']."&theloai=".$_POST['idTL']);
		else echo $sl;
	}
	}
?>

0 comments:

Post a Comment