Tra Từ Điển

Thời gianTiếtThứ 2Thứ 3Thứ 4Thứ 5Thứ 6
8g40 - 9g101Tiếng Việt
Tiếng Anh
Tiếng Việt
Tiếng Việt
9g10 - 9g302Nghỉ giải lao
Tiếng Anh
Nghỉ giải lao
Nghỉ giải lao
9g30 - 10g3Toán
Toán
Toán

Saturday, January 22, 2022

PHP#22MySQL#18 - Xóa, Sửa TIN & admin index (thể loại, loại tin)

//tin.php

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>

<body>
<?php
if(isset($_GET['lang'])) $lang=$_GET['lang'];
  else $lang="vi";
?>
<form id="form1" name="form1" method="get" action="">
  <p>
    <label for="lang">Ngon ngu:</label>
    <select name="lang" id="lang" onchange="form1.submit()">
      <option value="vi">Viet</option>
      <option value="en" <?php if($lang=="en") echo "selected";?>>English</option>
    </select>
  </p>
  <p>
    <label for="idTL">The loai:</label>
    <select name="idTL" id="idTL" onchange="form1.submit()">
 <?php
  include("../connect.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['idTL'])&&$_GET['idTL']==$d['idTL']){echo "selected";$idTL=$_GET['idTL'];}?>><?php echo $d['TenTL'] ?></option>
<?php }?>
    </select>
  </p>
  <p>
    <label for="idLT">Loai tin:</label>
    <select name="idLT" id="idLT" onchange="form1.submit()">>
       <?php
  $sl="select * from loaitin where idTL=$idTL order by ThuTu";
  $kq=mysqli_query($link,$sl);
$idLT=0;
  while($d=mysqli_fetch_array($kq)){
  if($idLT==0) $idLT=$d['idLT'];
  ?>
       <option value="<?php echo $d['idLT']; ?>" <?php if(isset($_GET['idLT'])&&$_GET['idLT']==$d['idLT']){echo "selected";$idLT=$_GET['idLT'];}?>><?php echo $d['Ten']; ?></option>
<?php }?>
    </select>
  </p>
</form>
<table width="1000" border="1">
  <tr>
    <td width="40">STT</td>
    <td width="215">Tieu de</td>
    <td width="264">Tom Tat</td>
     <td width="150">Hinh Mo Ta</td>
      <td width="125">Ngay</td>
    <td width="87">Trang Thai</td>
    <td width="73"><a href="tin_them.php?lang=<?php echo $lang;?>&idTL=<?php echo $idTL;?>&idLT=<?php echo $idLT; ?>">Them</a></td>
  </tr>
  <?php
$sltin="select * from tin where idLT=$idLT order by idTin DESC limit 0,5";
$kqtin=mysqli_query($link,$sltin);
while($dtin=mysqli_fetch_array($kqtin))
{ ?>
  <tr>
    <td>1</td>
    <td><?php echo $dtin['TieuDe'];?></td>
    <td><?php echo $dtin['TomTat'];?></td>
    <td><img src="<?php echo $dtin['urlHinh'];?>" width="150" height="100"/></td>
    <td><?php echo date("d-m-Y h:i:s",strtotime($dtin['Ngay']));?></td>
    <td><?php if($dtin['AnHien']) echo "Hiện"; else echo "Ẩn";?></td>
    <td><a href="process.php?xoatin=<?php echo $dtin['idTin'];?>&lang=<?php echo $lang;?>&idTL=<?php echo $idTL;?>&idLT=<?php echo $idLT; ?>" onClick="return confirm('Bạn có chắc chắn xóa tin này không?');">Xoa </a>/ <a href="tin_sua.php?idTin=<?php echo $dtin['idTin'];?>&idTL=<?php echo $idTL;?>">Sua</a></td>
  </tr>
  <?php }?>
</table>
<p>Trang: <a href="#">1</a> &nbsp;</p>
</body>
</html>


//tin_sua.php
<!doctype html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
<script type="text/javascript" src="ckeditor/ckeditor.js"></script>
</head>

<body>
<?php
if(isset($_GET['idTin']))
{
$idTin=$_GET['idTin'];
include("../connect.php");
$kqtin=mysqli_query($link,"select * from tin where idTin=$idTin");
$dtin=mysqli_fetch_array($kqtin);
if(isset($_GET['lang'])) $lang=$_GET['lang'];
else $lang=$dtin['lang'];
?>
<form id="form1" name="form1" method="get" action="">
  <p>
    <label for="lang">Ngon ngu:</label>
    <select name="lang" id="lang" onchange="form1.submit();">
      <option value="vi">Viet</option>
      <option value="en" <?php if($lang=='en') echo "selected='selected'";?>>Anh</option>
    </select>
 
    <label for="idTL">The loai:</label>
    <select name="idTL" id="idTL" onchange="form1.submit();">
    <?php
  $kq=mysqli_query($link,"select * from theloai where lang='$lang' order by ThuTu");
  $idTL=0;
  while($d=mysqli_fetch_array($kq)){
  if($idTL==0) $idTL=$d['idTL'];
  ?>
      <option value="<?php echo $d['idTL'];?>" <?php if(isset($_GET['idTL'])&&$d['idTL']==$_GET['idTL']){ echo "selected='selected'"; $idTL=$_GET['idTL'];}?>><?php echo $d['TenTL'];?></option>
 <?php }?>
    </select>
  </p>
 <input type="hidden" name="idTin" value="<?php echo $dtin['idTin'];?>"/>
</form>


<form action="process.php" method="post" enctype="multipart/form-data" name="form2" id="form2">
 <p>
    <label for="idLT">Loai tin:</label>
    <select name="idLT" id="idLT" >
    <?php
$kqlt=mysqli_query($link,"select * from loaitin where idTL=$idTL order by ThuTu");
while($dlt=mysqli_fetch_array($kqlt)){
?>  
      <option value="<?php echo $dlt['idLT'];?>" <?php if($dtin['idLT']==$dlt['idLT']) echo "selected='selected'";?>><?php echo $dlt['Ten'];?></option>
<?php }?>
    </select>
  </p>
  <p>
    <label for="TieuDe">Tieu de:</label>
    <input type="text" name="TieuDe" id="TieuDe" value="<?php echo $dtin['TieuDe'];?>" />
  </p>
  <p>
    <label for="TieuDe_KhongDau">Tieu de KD:</label>
    <input type="text" name="TieuDe_KhongDau" id="TieuDe_KhongDau" value="<?php echo $dtin['TieuDe_KhongDau'];?>" />
  </p>
  <p>
    <label for="TomTat">Tom tat:</label>
    <textarea name="TomTat" id="TomTat" cols="45" rows="5"><?php echo $dtin['TomTat'];?></textarea>
  </p>
  <p>
    <label for="ufile">Chon hinh:</label>
    <input type="file" name="ufile" id="ufile" /> <img src="<?php echo $dtin['urlHinh'];?>" width="100"/>
  </p>
  <p>
    <label for="idSK">Su kien:</label>
    <select name="idSK" id="idSK">
    <?php
$kqsk=mysqli_query($link,"select * from sukien where lang='$lang' order by ThuTu");
while($dsk=mysqli_fetch_array($kqsk)){
?>
      <option value="<?php echo $dsk['idSK'];?>"  <?php if($dtin['idSK']==$dsk['idSK']) echo "selected='selected'";?>><?php echo $dsk['MoTa'];?></option>
      <?php }?>
    </select>
  </p>
  <p>
    <label for="Content">Noi dung:</label>
    <textarea name="Content" id="Content" cols="45" rows="5" class="ckeditor"><?php echo $dtin['Content'];?></textarea>
  </p>
  <p>
    <input type="checkbox" name="TinNoiBat" id="TinNoiBat" <?php if($dtin['TinNoiBat']) echo "checked='checked'";?>/>
    <label for="TinNoiBat">Noi bat</label>
  </p>
   <p><label>Trang thai:</label>
    <select name="AnHien">
    <option value="0">An</option>
    <option value="1" <?php if($dtin['AnHien']) echo "selected='selected'";?>>Hien</option>
    </select>
  </p>
  <p>
  <input type="hidden" name="lang" value="<?php echo $lang;?>"/>
  <input type="hidden" name="idTL" value="<?php echo $idTL;?>"/>
  <input type="hidden" name="idTin" value="<?php echo $dtin['idTin'];?>"/>
    <input type="submit" name="suatin" id="suatin" value="Cap nhat tin" />
    <br />
  </p>
</form>
<p>&nbsp;</p>
<?php }?>
</body>
</html>


//process.php

<?php
include("../connect.php");
date_default_timezone_set("Asia/Ho_Chi_Minh");
//Xử lý thêm 1 thể loại mới:
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:index.php?key=tl&lang=".$_POST['lang']);
else echo $sl;
}
//Xử lý cập nhật 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(mysqli_query($link,$sl))
header("location:index.php?key=tl&lang=".$_POST['lang']);
else echo $sl;
}

// Xử lý xóa 1 thể loai
if(isset($_GET['xoatl']))
{
//Xóa các tin thuộc thể loại đó
// ==>  delete from tin where idLT in (select idLT from loaitin where idTL=$_GET['xoatl'])
//Xóa các loại tin thuộc thể loại đó:
//Xóa thể loại:
$sl="delete from theloai where idTL=".$_GET['xoatl'];
if(mysqli_query($link,$sl))
header("location:index.php?key=tl&lang=".$_GET['lang']);
else echo $sl;
}

//Xử lý thêm 1 loại tin mới:
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:index.php?key=lt&lang=".$_POST['lang']."&theloai=".$_POST['idTL']);
else echo $sl;
}

//Xử 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(mysqli_query($link,$sl))
header("location:index.php?key=lt&lang=".$_POST['lang']."&theloai=".$_POST['idTL']);
else echo $sl;
}

//Xử lý xóa 1 loại tin:
if(isset($_GET['xoalt']))
{
//Xóa các tin của loại tin này:
//delete from tin where idLT=$_GET['xoalt']
//Xóa loại tin:
$sl="delete from loaitin where idLT=".$_GET['xoalt'];
if(mysqli_query($link,$sl))
header("location:index.php?key=lt&lang=".$_GET['lang']."&theloai=".$_GET['idTL']);
else echo $sl;
}
//Xử lý thêm 1 tin mới:
if(isset($_POST['themtin']))
{
//Xử lý upfile:
if(isset($_FILES['ufile']))
{
$target="../dataupload/images/";
$filename=basename($_FILES['ufile']['name']);
$target.=$filename;
if(move_uploaded_file($_FILES['ufile']['tmp_name'],$target))
{
$url="/tintuc/dataupload/images/".$filename;
$ngay=date("Y-m-d h:i:s",time());
if(isset($_POST['TinNoiBat'])&&$_POST['TinNoiBat']=="on")
$tnb=1;
else $tnb=0;
//thêm dữ liệu vào bảng tin:
$sl="insert into tin values(NULL, '{$_POST['lang']}', '{$_POST['TieuDe']}', '{$_POST['TieuDe_KhongDau']}', '{$_POST['TomTat']}', '$url', '$ngay', 1, {$_POST['idSK']}, '{$_POST['Content']}', {$_POST['idLT']}, 0, $tnb, {$_POST['AnHien']})";
if(mysqli_query($link,$sl))
header("location:tin.php?lang=".$_POST['lang']."&idTL=".$_POST['idTL']."&idLT=".$_POST['idLT']);
else
{echo $sl; unlink($target);}
}
else echo "upload thất bại!";
}
}

//Xu ly cap nhat tin:

if(isset($_POST['suatin']))
{
if(isset($_POST['TinNoiBat'])&&$_POST['TinNoiBat']=="on") $tnb=1; else $tnb=0;
if(isset($_FILES['ufile'])&&$_FILES['ufile']['name']!="")
{
//Co chon file anh moi
$target="../dataupload/images/";
$tenfile=basename($_FILES['ufile']['name']);
$target.=$tenfile;
$urlhinh="/tintuc/dataupload/images/".$tenfile;
if(move_uploaded_file($_FILES['ufile']['tmp_name'],$target))
{
$sl="update tin set lang='{$_POST['lang']}', TieuDe='{$_POST['TieuDe']}', TieuDe_KhongDau='{$_POST['TieuDe_KhongDau']}', TomTat='{$_POST['TomTat']}', urlHinh='$urlhinh', idSK={$_POST['idSK']}, Content='{$_POST['Content']}', idLT={$_POST['idLT']}, TinNoiBat=$tnb, AnHien={$_POST['AnHien']} where idTin={$_POST['idTin']}";
//Select urlHinh from tin where idTin={$_POST['idTin']}
if(mysqli_query($link,$sl)) {
//Xóa ảnh cũ: tự viết.
header("location:tin.php?lang=".$_POST['lang']."&idTL=".$_POST['idTL']."&idLT=".$_POST['idLT']);
}
else {echo $sl;unlink($target);}
}
else echo "Upfile that bai";
}
else
{
//Khong chon file anh moi
$sl="update tin set lang='{$_POST['lang']}', TieuDe='{$_POST['TieuDe']}', TieuDe_KhongDau='{$_POST['TieuDe_KhongDau']}', TomTat='{$_POST['TomTat']}', idSK={$_POST['idSK']}, Content='{$_POST['Content']}', idLT={$_POST['idLT']}, TinNoiBat=$tnb, AnHien={$_POST['AnHien']} where idTin={$_POST['idTin']}";
if(mysqli_query($link,$sl)) header("location:tin.php?lang=".$_POST['lang']."&idTL=".$_POST['idTL']."&idLT=".$_POST['idLT']);
else {echo $sl;}
}
}
//Xử lý xóa 1 tin:
if(isset($_GET['xoatin']))
{
$sl="delete from tin where idTin=".$_GET['xoatin'];
if(mysqli_query($link,$sl)) header("location:tin.php?lang=".$_GET['lang']."&idTL=".$_GET['idTL']."&idLT=".$_GET['idLT']);
else {echo $sl;}
}
?>


//index.php

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Dashboard - Admin Template</title>
<link rel="stylesheet" type="text/css" href="css/theme1.css" />
<link rel="stylesheet" type="text/css" href="css/style.css" />
<script>
   var StyleFile = "theme" + document.cookie.charAt(6) + ".css";
   document.writeln('<link rel="stylesheet" type="text/css" href="css/' + StyleFile + '">');
</script>
<!--[if IE]>
<link rel="stylesheet" type="text/css" href="css/ie-sucks.css" />
<![endif]-->

</head>

<body>
<div id="container">
    <?php
if(isset($_GET['key']))
$key=$_GET['key'];
else $key="";
?>
    <!--menu-->
    <div id="header">
        <h2>TRUNG TÂM ĐÀO TẠO MẠNG MÁY TÍNH NHẤT NGHỆ</h2>
    <div id="topmenu">
            <ul>
                <li <?php if($key=="") echo 'class="current"';?>><a href="index.php">TRANG CHỦ</a></li>
                    <li <?php if($key=="tl" || $key=="tlt"||$key=="tls") echo 'class="current"';?>><a href="?key=tl">THỂ LOẠI</a></li>
                    <li <?php if($key=="lt" || $key=="ltt"||$key=="lts") echo 'class="current"';?>><a href="?key=lt">LOẠI TIN</a></li>
                    <li><a href="#">TIN TỨC</a></li>
                    <li><a href="#">USERS</a></li>

              </ul>
    </div>
</div>
    <!--//menu-->
        <div id="wrapper">
            <div id="content">
                <?php 
switch($key)
{
case "tl": include("theloai.php");break;
case "tlt": include("theloai_them.php");break;
case "tls": include("theloai_sua.php");break;
case "lt": include("loaitin.php");break;
case "ltt": include("loaitin_them.php");break;
case "lts": include("loaitin_sua.php");break;
default:include("main.php");
}
?>
          </div>
        </div>
     
<!--footer-->
     <div id="footer">
        <div id="credits">
    Thiết kế bởi teo@yahoo.com</a>
        </div>
        <div id="styleswitcher">
            <ul>
                <li><a href="javascript: document.cookie='theme='; window.location.reload();" title="Default" id="defswitch">d</a></li>
                <li><a href="javascript: document.cookie='theme=1'; window.location.reload();" title="Blue" id="blueswitch">b</a></li>
                <li><a href="javascript: document.cookie='theme=2'; window.location.reload();" title="Green" id="greenswitch">g</a></li>
                <li><a href="javascript: document.cookie='theme=3'; window.location.reload();" title="Brown" id="brownswitch">b</a></li>
                <li><a href="javascript: document.cookie='theme=4'; window.location.reload();" title="Mix" id="mixswitch">m</a></li>
            </ul>
        </div><br />

 </div>
     <!--//footer-->
</div>
</body>
</html>


//loaitin.php


<p>
<?php
if(isset($_GET['lang'])) $lang=$_GET['lang'];
  else $lang="vi";
?>
 <form id="form1" name="form1" method="get" action="">
  <label for="lang">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>
  <input type="hidden" name="key" value="tl" />
</form>
</p>
<table width="700" border="1" cellspacing="0" cellpadding="0">
  <tbody>
    <tr>
      <th width="64" scope="col">Thứ tự</th>
      <th width="209" scope="col">Tên Thể loại</th>
      <th width="169" scope="col">Tên không dấu</th>
      <th width="140" scope="col">Trạng thái</th>
      <th width="106" scope="col"><a href="?key=tlt&lang=<?php echo $lang;?>">Thêm</a></th>
    </tr>
    <?php
  include("../connect.php");
  $sl="select * from theloai where lang='$lang' 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['TenTL'];?></td>
      <td><?php echo $d['TenTL_KhongDau'];?></td>
      <td><?php if($d['AnHien']) echo "Hiện"; else echo "Ẩn";?></td>
<td><a href="process.php?xoatl=<?php echo $d['idTL'];?>&lang=<?php echo $lang;?>" onClick="return confirm('Bạn có chắn chắn muốn xóa thể loại này không?');">Xóa</a> / <a href="?key=tls&idTL=<?php echo $d['idTL'];?>">Sửa</a></td>
    </tr>
    <?php }?>
  </tbody>
</table>



//loaitin.php

<p>
<?php
if(isset($_GET['lang'])) $lang=$_GET['lang'];
  else $lang="vi";
?>
 <form id="form1" name="form1" method="get" action="">
   <p>
     <label for="lang">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>
     <input type="hidden" name="key" value="lt" />
   </p>
   <p>
     <label for="theloai">Thể loại:</label>
     <select name="theloai" id="theloai"  onChange="form1.submit()">
      <?php
  include("../connect.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>
</p>
<table width="700" border="1" cellspacing="0" cellpadding="0">
  <tbody>
    <tr>
      <th width="64" scope="col">Thứ tự</th>
      <th width="209" scope="col">Tên Loại tin</th>
      <th width="169" scope="col">Tên không dấu</th>
      <th width="140" scope="col">Trạng thái</th>
<th width="106" scope="col"><a href="?key=ltt&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;?>&idTL=<?php echo $idTL;?>" onClick="return confirm('Bạn có chắc chắn xóa loại tin này?')" >Xóa</a> / <a href="?key=lts&idLT=<?php echo $d['idLT'];?>">Sửa</a></td>
    </tr>
    <?php }?>
  </tbody>
</table>

0 comments:

Post a Comment