//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> </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> </p>
<?php }?>
</body>
</html>
