lop.php | searchcode

/quanlyktx/admincp/lop/lop.php

http://cn08b.googlecode.com/
PHP | 270 lines | 264 code | 3 blank | 3 comment | 17 complexity | e11116244578d8b4ac598a3034d877f2 MD5 | raw file

<?php 

	require_once("../config/config.php");

	ob_start();

?>



<div id="main_lop">

<?php 

if(!isset($_GET["thaydoi"]))

{

?>

	<form action="" method="post" name="form_lop">

    	<span style="float:right;">

    		&nbsp;&nbsp;&nbsp;Li?t Kę Danh Sách:&nbsp;&nbsp;&nbsp;

        	<select name="danhsach" onchange="form_lop.submit()" style="width:250px;text-align:center">

        		<option  value="1" <?php if((isset($_POST["danhsach"]))&&($_POST["danhsach"]==1)) echo "selected"; ?>>Khoa</option>

            	<option  value="2" <?php if((isset($_POST["danhsach"]))&&($_POST["danhsach"]==2)) echo "selected"; ?>>Khu</option>

            	<option  value="3" <?php if((!isset($_POST["danhsach"]))||($_POST["danhsach"]==3)) echo "selected"; ?>>L?p</option>

            	<option  value="4" <?php if((isset($_POST["danhsach"]))&&($_POST["danhsach"]==4)) echo "selected"; ?>>Phňng</option>

               <option  value="5" <?php if((isset($_POST["danhsach"]))&&($_POST["danhsach"]==5)) echo "selected"; ?>>Sinh Vien</option>

        	</select> 

    	</span><br/><br />

		<h1 style="text-align:center">Qu?n Lý Ký Túc Xá Theo L?p </h1>

<?php

		if(!isset($_POST["danhsach"]))

		{

			$khoa=mysql_query("select * from khoa",$quanlyktx);

?>			<span>Danh Sách C?a Khoa:

            <select name="khoa" onchange="form_lop.submit()" style="width:250px;text-align:center;">

            <option value="-1">&nbsp;&nbsp;&nbsp;Ch?n&nbsp;&nbsp;&nbsp;</option>

<?php		while($row_khoa=mysql_fetch_array($khoa))

			{

?>				<option  value="<?php echo $row_khoa["MA_KHOA"];?>" <?php if((isset($_POST["khoa"]))&&($_POST["khoa"]== $row_khoa["MA_KHOA"])) echo "selected"; ?>><?php echo $row_khoa["TEN_KHOA"];?></option>

<?php 		}

?>           </select>

            </span><br/><br />

            

<?php

			

		}

		elseif(isset($_POST["danhsach"]))

		{

			if($_POST["danhsach"]==1)

			{

				//header("location:khoa/listkhoa.php");

				echo "<script>window.location='khoa/listkhoa.php';</script>";

			}

			elseif($_POST["danhsach"]==2)

			{

				require_once("khu/_khu.php");

			}

			elseif($_POST["danhsach"]==3)

			{

				$khoa=mysql_query("select * from khoa",$quanlyktx);

?>				<span>Danh Sách C?a Khoa:

            	<select name="khoa" onchange="form_lop.submit()" style="width:250px;text-align:center;">

            		<option value="-1">&nbsp;&nbsp;&nbsp;Ch?n&nbsp;&nbsp;&nbsp;</option>

<?php				while($row_khoa=mysql_fetch_array($khoa))

					{

?>						<option  value="<?php echo $row_khoa["MA_KHOA"];?>" <?php if((isset($_POST["khoa"]))&&($_POST["khoa"]== $row_khoa["MA_KHOA"])) echo "selected"; ?>><?php echo $row_khoa["TEN_KHOA"];?></option>

<?php 				}

?>           	</select>

            	</span><br/>

<?php			if((isset($_POST["khoa"]))&&($_POST["khoa"]!=-1))

				{

					$lop="select * from lop where MA_KHOA= '".$_POST["khoa"]."'";

					$query_lop=mysql_query($lop,$quanlyktx);

					$stt=0;

?>				<table width="98%" border="1" cellspacing="0" cellpadding="3">

      			<tr>

        			<td align="center" valign="top" bgcolor="#00CCFF"><h1><strong>STT</strong></h1></td>

        			<td align="center" valign="top" bgcolor="#00CCFF"><h1><strong>Mă L?p</strong></h1></td>

        			<td align="center" valign="top" bgcolor="#00CCFF"><h1><strong>Tęn L?p</strong></h1></td>

        			<td align="center" valign="top" bgcolor="#00CCFF"><h1><strong>S? L??ng</strong></h1></td>

        			<td align="center" valign="top" bgcolor="#00CCFF"><h1>Giáo Vięn Ch? Nhi?m</h1></td>

                	<td align="center" valign="top" bgcolor="#00CCFF"><h1>&nbsp;</h1></td>

        		</tr>

<?php				while($row_lop=mysql_fetch_array($query_lop))

					{

?>		    	<tr>

        			<td><?php echo $stt++;?></td>

        			<td><?php echo $row_lop['MA_LOP'];?></td>

        			<td><?php echo $row_lop['TEN_LOP'];?></td>

        			<td><?php echo $row_lop['SOLUONG_SV'];?></td>

        			<td><?php echo $row_lop['GIAOVIEN_CN'];?></td>

                	<td><a href="index.php?chon=2&&ma_lop=<?php echo $row_lop['MA_LOP'];?>&&thaydoi=1">Edit</a></td>

      			</tr>

<?php 				}

?>				<tr>

					<td colspan="6" style="text-align:center;">

                    	<a href="index.php?chon=2&&thaydoi=2"><input type="button" value=" Thęm L?p" /></a>

                    </td>

				</tr>

				</table>

<?php

				}				

			}

			elseif($_POST["danhsach"]==4)

			{

				//header("location:index.php?chon=3");

				echo "<script>window.location='index.php?chon=3';</script>";

			}

			elseif($_POST["danhsach"]==5)

			{

				//header("location:sinhvien/quanlysinhvien.php");

				echo "<script>window.location='sinhvien/quanlysinhvien.php';</script>";

			}

		}

?>

	</form>

<?php	

}

elseif($_GET["thaydoi"]==1)

{

		if(isset($_GET["sua"]))

		{

			$query_update= "update lop set MA_LOP='".$_POST['malop']."',TEN_LOP='".$_POST['tenlop']."',SOLUONG_SV=".$_POST['soluong'].",GIAOVIEN_CN='".$_POST['giaovien']."',MA_KHOA='".$_POST['khoa']."' where MA_LOP='".$_GET["ma_lop"]."'";

			$bol=mysql_query($query_update,$quanlyktx);

			if($bol)

			{

				echo "S?a Thŕnh Công!<a href='#' onClick='history.go(-1)'>Nh?n Vŕo ?ây ?? Quay Tr? L?i</a>";

			}

			else

			{

				echo "Có L?i!Vui Lňng Lięn H? V?i Ng??i Qu?n Tr? ?? S?a L?i Nŕy";

			}

		}

		else

		{

    		$lop=mysql_query("select * from lop where MA_LOP='".$_GET["ma_lop"]."'",$quanlyktx);

			if($row_lop=mysql_fetch_array($lop))

			{

?>    		<form action="index.php?chon=2&&thaydoi=1&&sua=yes&&ma_lop=<?php echo $_GET["ma_lop"];?>" method="post" name="form_sua">

			<table width="589" height="76" border="0" align="center" style="font: 13px/1.5em Verdana;">                

       		<tr>

    			<td height="28">

        			Mă L?p:&nbsp;

       	 		</td>

        		<td>

        			<input type="text" value="<?php echo $_GET["ma_lop"];?>" name="malop" id="malop" size="25px" onFocus="form_lop.malop.value=''">

        		</td>  				   

  			</tr>

        	<tr>

        		<td>

            		Tęn L?p:&nbsp;

            	</td>

            	<td>

            		<input type="text" value="<?php echo $row_lop["TEN_LOP"];?>" name="tenlop" id="tenlop" size="25px" onFocus="form_lop.tenlop.value=''">

            	</td>

        	</tr>

        	<tr>

        		<td>

            		S? L??ng Sinh Vięn:&nbsp;

            	</td>

            	<td>

            		<input type="text" value="<?php echo $row_lop["SOLUONG_SV"];?>" name="soluong" id="soluong" size="25px" onFocus="form_lop.soluong.value=''">

            	</td>

        	</tr>

        	<tr>

        		<td>

            		Giáo Vięn Ch? Nhi?m:&nbsp;

            	</td>

            	<td>

            		<input type="text" value="<?php echo $row_lop["GIAOVIEN_CN"];?>" name="giaovien" id="giaovien" size="25px" onFocus="form_lop.giaovien.value=''">

            	</td>

         	</tr>

        	<tr>

        		<td>

            		Khoa:

            	</td>

            	<td>

<?php				$query_khoa=mysql_query("select * from khoa",$quanlyktx);

?>					<select name="khoa" style="width:250px;text-align:center;">

            			<option value="-1">&nbsp;&nbsp;&nbsp;Ch?n&nbsp;&nbsp;&nbsp;</option>

<?php					while($row_khoa=mysql_fetch_array($query_khoa))

						{

?>							<option  value="<?php echo $row_khoa["MA_KHOA"];?>" <?php if($row_lop["MA_KHOA"]==$row_khoa["MA_KHOA"]) echo "selected"; ?>><?php echo $row_khoa["TEN_KHOA"];?></option>

<?php 					}

?>           		</select>

            	</td>

        	</tr>

        	<tr>

        		<td colspan="2" style="text-align:center;padding:3px;">

            		<input type="submit" value="S?a L?p" name="abc">

                	<input type="button" value="Quay L?i" onClick="history.go(-1)">      

            	</td>

        	</tr>

        	</table>

        	</form>                        

<?php	

			}

	}

}

else

{

		if((isset($_GET["them"]))&&($_POST["malop"]!="")&&($_POST["tenlop"]!="")&&($_POST["soluong"]!="")&&($_POST["giaovien"]!="")&&($_POST["khoa"]!=-1))

		{

			$query_update= "insert into lop(MA_LOP,TEN_LOP,SOLUONG_SV,GIAOVIEN_CN,MA_KHOA) values('".$_POST['malop']."','".$_POST['tenlop']."',".$_POST['soluong'].",'".$_POST['giaovien']."','".$_POST['khoa']."')";

			if($ketqua=mysql_query($query_update,$quanlyktx))

			{

				echo "Thęm Thŕnh Công";

			}

			else

			{

				echo "Có l?i!Vui lňng lięn h? v?i ban qu?n tr? ?? s?a l?i nŕy!";

			}

		}

		else

		{

?>

			<form action="index.php?chon=2&&thaydoi=2&&them=yes" method="post" name="form_sua">

			<table width="589" height="76" border="0" align="center" style="font: 13px/1.5em Verdana;">                

       		<tr>

    			<td height="28">

        			Mă L?p:&nbsp;

       	 		</td>

        		<td>

        			<input type="text" name="malop" size="25px" value="">

        		</td>  				   

  			</tr>

        	<tr>

        		<td>

            		Tęn L?p:&nbsp;

            	</td>

            	<td>

            		<input type="text" name="tenlop" id="tenlop" size="25px" value="">

            	</td>

        	</tr>

        	<tr>

        		<td>

            		S? L??ng Sinh Vięn:&nbsp;

            	</td>

            	<td>

            		<input type="text" name="soluong" id="soluong" size="25px" value="">

            	</td>

        	</tr>

        	<tr>

        		<td>

            		Giáo Vięn Ch? Nhi?m:&nbsp;

            	</td>

            	<td>

            		<input type="text" name="giaovien" id="giaovien" size="25px" value="">

            	</td>

         	</tr>

        	<tr>

        		<td>

            		Khoa:

            	</td>

            	<td>

<?php				$query_khoa=mysql_query("select * from khoa",$quanlyktx);

?>					<select name="khoa" style="width:250px;text-align:center;">

            			<option value="-1">&nbsp;&nbsp;&nbsp;Ch?n&nbsp;&nbsp;&nbsp;</option>

<?php					while($row_khoa=mysql_fetch_array($query_khoa))

						{

?>							<option  value="<?php echo $row_khoa["MA_KHOA"];?>"><?php echo $row_khoa["TEN_KHOA"];?></option>

<?php 					}

?>           		</select>

            	</td>

        	</tr>

        	<tr>

        		<td colspan="2" style="text-align:center;padding:3px;">

            		<input type="submit" value="Thęm L?p" name="abc">

                	<input type="button" value="Quay L?i" onClick="history.go(-1)">      

            	</td>

        	</tr>

        	</table>

        	</form>  

<?php } 

	}

?>

</div>