Viewing file:  FrmEditSubject.php (9.86 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
session_start();
if (session_is_registered("valid_user")&&session_is_registered("Priority")&&session_is_registered("password") )
{
include("../include/FunctionDB.php");
include("admin_menu.php");
include("../include/Function.php");
ConnectDB();
$sql = "Select * From subject_tb Where Subject_no='$Subject_no'";
$result1= mysql_query($sql) or die("Error".mysql_error());
$row = mysql_fetch_array($result1);
?>
<meta http-equiv="Content-Type" content="text/html; charset=TIS-620">
<table width="843" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="843" ><br>
<fieldset>
<legend><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_3"]; ?>"><a href="Edu_Menu.php">หน้าหลัก</a> <img src="../picture/ico3.gif" width="10" height="10" border="0" align="absmiddle"><a href="SubjectList.php">ข้อมูลรายวิชา</a> <img src="../picture/ico3.gif" width="10" height="10" border="0" align="absmiddle"><a href="EditSubCateList.php"> แก้ไขข้อมูลหมวดวิชา</a></font></legend>
<label>
<form id="form1" name="form1" method="post" action="EditSubject.php">
<table width="84%" border="0" align="center" cellpadding="0" cellspacing="1" bordercolor="#006699" bgcolor="#EEEEEE">
<tr bgcolor="#E4EEFA">
<td colspan="3"><div align="center"><strong><font color="#FF0000" size="4" face="Tahoma">แก้ไข</font><font color="#003366" size="4" face="Tahoma"> ข้อมูลรายวิชา</font></strong></div></td>
</tr>
<tr bgcolor="#EEEEEE">
<td><div align="center"><font color="#003366" size="2" face="Tahoma">หลักสูตร</font></div></td>
<td bordercolor="#006699"> </td>
<td bordercolor="#006699"><font color="#003366" size="2" face="Tahoma">
<select name="Course_code" class="input1" id = "Course_code">
<?php
$Course_code = $row[Course_code];
$strSQL1 = "SELECT * FROM course_tb Where Course_code='$Course_code'";
$result1= mysql_query($strSQL1);
$strSQL2 = "SELECT * FROM course_tb Order By Course_code";
$result2= mysql_query($strSQL2);
while( $rss1 = mysql_fetch_array($result1))
{
echo"<option value=\"$rss1[Course_code]\"><b>$rss1[Course_name]</b></option>\n";
while( $rss2 = mysql_fetch_array($result2))
{
echo"<option value=\"$rss2[Course_code]\"><b>$rss2[Course_name]</b></option>\n";
}
}
?>
</select>
</font></td>
</tr>
<tr bgcolor="#EEEEEE">
<td><div align="center"><font color="#003366" size="2" face="Tahoma">หมวดวิชา</font></div></td>
<td bordercolor="#006699"> </td>
<td bordercolor="#006699"><font color="#003366" size="2" face="Tahoma">
<select name="SubCate_code" class="input1" id="SubCate_code">
<?php
$SubCate_code = $row[SubCate_code];
$strSQL3 = "SELECT * FROM subject_category_tb Where SubCate_code='$SubCate_code'";
$result3= mysql_query($strSQL3) or die("Error".mysql_error());
$strSQL4 = "SELECT * FROM subject_category_tb Order By SubCate_code";
$result4= mysql_query($strSQL4);
while( $rs3 = mysql_fetch_array($result3))
{
echo"<option value=\"$rs3[SubCate_code]\"><b>$rs3[Cate_name]</b></option>\n";
while( $rs4 = mysql_fetch_array($result4))
{
echo"<option value=\"$rs4[SubCate_code]\"><b>$rs4[Cate_name]</b></option>\n";
}
}
?>
</select>
</font></td>
</tr>
<tr bgcolor="#EEEEEE">
<td><div align="center"><font color="#003366" size="2" face="Tahoma">กลุ่มวิชา</font></div></td>
<td bordercolor="#006699"> </td>
<td bordercolor="#006699"><select name="Subject_group" id="select2" class="input1">
<?php
$Subject_group = $row[Subject_group];
$strSQL5 = "SELECT * FROM subject_group_tb Where Subject_group='$Subject_group'";
$result5= mysql_query($strSQL5) or die("Error".mysql_error());
$strSQL6 = "SELECT * FROM subject_group_tb Order By Subject_group";
$result6= mysql_query($strSQL6);
while( $rs5 = mysql_fetch_array($result5))
{
echo"<option value=\"$rs5[Subject_group]\"><b>$rs5[Short_name]</b></option>\n";
while( $rs6 = mysql_fetch_array($result6))
{
echo"<option value=\"$rs6[Subject_group]\"><b>$rs6[Short_name]</b></option>\n";
}
}
?>
</select></td>
</tr>
<tr bgcolor="#EEEEEE">
<td width="26%"><div align="center"><font color="#003366" size="2" face="Tahoma">รหัสวิชา</font></div></td>
<td width="2%" bordercolor="#006699"> </td>
<td width="72%" bordercolor="#006699"><input name="Subject_code" type="text" class="input1" id="Subject_code" value="<? echo $row[Subject_code]?>" size="10" />
<font color="#000066" size="2" face="Tahoma">ชื่อวิชา
<input name="Subject_name" type="text" class="input1" id="Subject_name" value="<? echo $row[Subject_name]?>" size="60" />
</font></td>
</tr>
<tr bgcolor="#EEEEEE">
<td><div align="center"><font color="#003366" size="2" face="Tahoma">หน่วยกิต</font></div></td>
<td bordercolor="#006699"> </td>
<td bordercolor="#006699"><input name="Unit" type="text" class="input1" id="Unit" value="<? echo $row[Unit]?>" size="10" />
</td>
</tr>
<tr bgcolor="#EEEEEE">
<td><div align="center"><font color="#003366" size="2" face="Tahoma">ภาคการเรียน</font></div></td>
<td bordercolor="#006699"> </td>
<td bordercolor="#006699"><font size="2" face="Tahoma">
<input type="radio" name="Term" <?php if (!(strcmp("$row[Term]","1"))) {echo "checked";} ?> value="1" />
</font><font color="#003366" size="2" face="Tahoma">ภาคที่</font><font size="2" face="Tahoma"> 1
<input type="radio" name="Term" <?php if (!(strcmp("$row[Term]","2"))) {echo "checked";} ?> value="2" />
</font><font color="#003366" size="2" face="Tahoma">ภาคที่</font><font size="2" face="Tahoma"> 2
<input type="radio" name="Term" value="3" <?php if (!(strcmp("$row[Term]","3"))) {echo "checked";} ?> />
</font><font color="#003366" size="2" face="Tahoma">ภาค</font><font color="#003366" size="2" face="Tahoma">ฤดูร้อน</font></td>
</tr>
<tr bgcolor="#EEEEEE">
<td><div align="center"><font color="#003366" size="2" face="Tahoma">จำนวนชั่วโมงทั้งหมด</font></div></td>
<td bordercolor="#006699"> </td>
<td bordercolor="#006699"><input name="Total_hour" type="text" class="input1" id="Total_hour" value="<? echo $row[Total_hour]?>" size="10" />
<font color="#003366" size="2" face="Tahoma">ชั่วโมง</font></td>
</tr>
<tr bgcolor="#EEEEEE">
<td><div align="center"><font color="#003366" size="2" face="Tahoma">ชั้นปีที่</font></div></td>
<td bordercolor="#006699"> </td>
<td bordercolor="#006699"><font size="2" face="Tahoma">
<input type="radio" name="Class_level" <?php if (!(strcmp("$row[Class_level]","1"))) {echo "checked";} ?> value="1" />
</font><font color="#003366" size="2" face="Tahoma">ชั้นปีที่</font><font size="2" face="Tahoma"> 1
<input type="radio" name="Class_level" <?php if (!(strcmp("$row[Class_level]","2"))) {echo "checked";} ?> value="2" />
</font><font color="#003366" size="2" face="Tahoma">ชั้นปีที่</font><font size="2" face="Tahoma"> 2
<input type="radio" name="Class_level" <?php if (!(strcmp("$row[Class_level]","3"))) {echo "checked";} ?> value="3" />
</font><font color="#003366" size="2" face="Tahoma">ชั้นปีที่</font> <font size="2" face="Tahoma">3
<input type="radio" name="Class_level" <?php if (!(strcmp("$row[Class_level]","4"))) {echo "checked";} ?> value="4" />
</font><font color="#003366" size="2" face="Tahoma">ชั้นปีที่</font><font size="2" face="Tahoma"> 4</font></td>
</tr>
<tr bgcolor="#EEEEEE">
<td><div align="center"><font color="#003366" size="2" face="Tahoma">วัตถุประสงค์</font></div></td>
<td bordercolor="#006699"> </td>
<td bordercolor="#006699"><textarea name="Objective" cols="60" rows="5" id="Objective" class="input1"><? echo $row[Objective]?></textarea></td>
</tr>
<tr bgcolor="#EEEEEE">
<td><div align="center"><font color="#003366" size="2" face="Tahoma">ลักษณะวิชา</font></div></td>
<td bordercolor="#006699"> </td>
<td bordercolor="#006699"><textarea name="Detail" cols="60" rows="10" class="input1"><? echo $row[Detail]?></textarea></td>
</tr>
<tr bgcolor="#EEEEEE">
<td><div align="center"><font color="#003366" size="2" face="Tahoma">การตอบสนองสมรรถนะชั้นปี</font></div></td>
<td bordercolor="#006699"> </td>
<td bordercolor="#006699"><textarea name="Class_Affect" cols="60" rows="10" class="input1" id="Class_Affect"><? echo $row[Class_Affect]?></textarea></td>
</tr>
<tr bgcolor="#EEEEEE">
<td><div align="center"><font color="#003366" size="2" face="Tahoma">การตอบสนองสมรรถนะรายวิชา</font></div></td>
<td bordercolor="#006699"> </td>
<td bordercolor="#006699"><textarea name="Affect_sub" cols="60" rows="5" class="input1" id="Affect_sub"><? echo $row[Affect_sub]?></textarea></td>
</tr>
<tr bgcolor="#E4EEFA">
<td colspan="3"><div align="center">
<input type="hidden" name="Subject_no" value="<? echo $row[Subject_no]?>" />
<input type="submit" name="Submit3" value=" บันทึก " />
</div></td>
</tr>
</table>
</form>
</fieldset>
<br>
<font color="<?php echo $GLOBALS["COLOR_FONT_3"];?>" size="2"><b>หมายเหตุ :</b> ใช้เมาส์คลิกที่ชื่อ<br>
</font></td>
</tr>
</table>
<?php
}
else
{
echo"<meta http-equiv=\"refresh\" content=\"3;URL=../login.php\">\n";
echo"Please Login ";
}
?>
|