Viewing file:  InsertGrade.php (4.37 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
session_start();
if (session_is_registered("valid_user"))
{
$Username = $valid_user;
include("../include/FunctionDB.php");
ConnectDB();
//code Student_id Class Term Unit Tb Tp Total Gpa Total_Unit Total_Gpa
$Flag = true;
$Class = htmlspecialchars(trim($_POST['Class']));
$Term = htmlspecialchars(trim($_POST[Term]));
$Tb = htmlspecialchars(trim($_POST[Tb]));
$Tp = htmlspecialchars(trim($_POST[Tp]));
$Total = htmlspecialchars(trim($_POST[Tb]));
$Tb = htmlspecialchars(trim($_POST[Tb]));
$Gpa = Trim($_POST[Gpa]);
//////////////////////////////////////////
$sql = "Select * From grade_tb Where Class='$Class' AND Term='$Term' AND Student_id='$Student_id'";
$result = mysql_query($sql) or die("Error".mysql_error());
$row = mysql_num_rows($result);
if ($row > 0)
{
$msg .="<li>ข้อมูลมีอยู่แล้ว โปรดตรวจสอบ";
$button ="<input type=\"button\" value=\"Back to Edit\" onclick=\"history.back();\" style=\"font-weight:bold;color:#FFF;background-color:#036;border-style:outset;border-color:#69F;font-family:Tohoma;\">";
$Flag = false;
}
///////////////////// check name
if ($Class =="")
{
$msg .="<li>กรุณากรอก ชั้นปี";
$button ="<input type=\"button\" value=\"Back to Edit\" onclick=\"history.back();\" style=\"font-weight:bold;color:#FFF;background-color:#036;border-style:outset;border-color:#69F;font-family:Tohoma;\">";
$Flag = false;
}
///////// check period time long or short
if ($Term =="")
{
$msg .="<li>กรุณากรอก ภาคการศึกษา";
$button ="<input type=\"button\" value=\"Back to Edit\" onclick=\"history.back();\" style=\"font-weight:bold;color:#FFF;background-color:#036;border-style:outset;border-color:#69F;font-family:Tohoma;\">";
$Flag = false;
}
///////// check period time long or short
if ($Tb =="")
{
$msg .="<li>กรุณาเลือก จำนวนหน่วยกิตทฤษฏี";
$button ="<input type=\"button\" value=\"Back to Edit\" onclick=\"history.back();\" style=\"font-weight:bold;color:#FFF;background-color:#036;border-style:outset;border-color:#69F;font-family:Tohoma;\">";
$Flag = false;
}
/////////////////// Check Branch
if ($Tp =="")
{
$msg .="<li>กรุณากรอก จำนวนหน่วยกิตปฏิบัติและทดลอง";
$button ="<input type=\"button\" value=\"Back to Edit\" onclick=\"history.back();\" style=\"font-weight:bold;color:#FFF;background-color:#036;border-style:outset;border-color:#69F;font-family:Tohoma;\">";
$Flag = false;
}
/////////////////// Check Branch
if ($Gpa =="")
{
$msg .="<li>กรุณากรอก G.P.A";
$button ="<input type=\"button\" value=\"Back to Edit\" onclick=\"history.back();\" style=\"font-weight:bold;color:#FFF;background-color:#036;border-style:outset;border-color:#69F;font-family:Tohoma;\">";
$Flag = false;
}
/////////////////////// Check Address
if( $Flag)
{
InsertGrade($Student_id,$Class,$Term,$Tb,$Tp,$Total,$Gpa,$Total_unit,$Total_gpa);
$msg.="<li>ระบบจัดเก็บข้อมูลเรียบร้อยแล้ว";
echo"<meta http-equiv=\"refresh\" content=\"2;URL=GradeList.php?Student_id=$Student_id\">\n";
}
CloseDB();
?>
<html>
<head>
<title>Inserting Gpa and Unit</title>
<link rel="stylesheet" href="../../../css/style1.css" type="text/css">
<meta http-equiv="Content-Type" content="text/html; charset=windows-874"></head>
<body bgcolor="#FFFFFF" leftmargin="0" topmargin="0"marginwidth="0"marginheight="0">
<form>
<br>
<table width="68%" border="0" cellspacing="0"cellpadding="2"align="center">
<tr>
<td><div align="center"><span><b><font color="#000000" size="3" face="Tahoma">::ฟอร์มการเพิ่มข้อมูลผลการเรียน::</font></b></span></div></td>
</tr>
<tr>
<td>
<table width="81%" border="0" cellspacing="1"cellpadding="2"align="center"bordercolor="#0B62D9" class="table">
<tr>
<td bgcolor="#336699"> <div align="center"><b><font color="#FFFFFF" size="3" face="Tahoma">ระบบแจ้งการทำงาน</font></b></div></td>
</tr>
<tr>
<td bgcolor="#000000"> <table width="104%" border="0" cellspacing="0"cellpadding="2"align="center">
<tr>
<td><font color="#FFFF33" size="3" face="Tahoma"><strong><span><?php echo $msg;?></span></strong></font></td>
</tr>
</table></td>
</tr>
<tr>
<td bgcolor="#336699"> <div align="center"><b><font color="#CCFF00"><?php echo $button;?></font></b></div></td>
</tr>
</table>
</td>
</tr>
</table>
<br>
<br>
</form>
</body>
</html>
<?php
}
else
{
echo"<meta http-equiv=\"refresh\" content=\"3;URL=../../login.php\">\n";
echo"Please Login ";
}
?>
|