Viewing file: InsertCom.php (4.33 KB) -rw-r--r-- Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) | ";
// echo " กรุณาทำการ Login ก่อน ";
// echo "";
// exit();
// }
//else {
/** Configuration */
require_once( "configuration.php" );
require_once( $_Config_absolute_path . "/includes/framework.php" );
require_once( "./includes/Function.php" );
require_once( "./includes/FunctionDB.php" );
/** Create Database Object */
$dbObj = new DBConn;
//=== SESSION
$Username = $valid_user;
$studentCode = htmlspecialchars(trim($studentCode));
$prefixName = htmlspecialchars(trim($prefixName));
$studentName = htmlspecialchars(trim($studentName));
$studentSurname = htmlspecialchars(trim($studentSurname));
//$Date = $_POST['mYear']."-".$_POST['mMonth']."-".$_POST['mDate'];
$DateToDB = dmyE2ymdT($_REQUEST['Date']);
$NotebookCode = htmlspecialchars(trim($NotebookCode));
$notebookName = htmlspecialchars(trim($notebookName));
$MaxAddress = htmlspecialchars(trim($MaxAddress));
/////////////////////// check Code //////////////////
//### user_tb
$checkid = 0;
$sql11 = " Select * From stu_notebook Where studentCode='$studentCode' ";
$result11 = mysql_query($sql11);
if (mysql_num_rows($result11)){
$sql = "update stu_notebook set acadYear =' ".$acadYear." ' , prefixName = ' ".$prefixName." ',studentName = '".$studentName."',studentSurname = '".$studentSurname."',Date = '".$DateToDB."', NotebookCode = '".$NotebookCode."',notebookName = '".$notebookName."' ,MaxAddress = '".$MaxAddress."' , date_updated = now() where studentCode = '".$studentCode."' ";
mysql_query($sql);
}
else InsertCom($studentCode, $acadYear ,$prefixName,$studentName,$studentSurname,$DateToDB, $NotebookCode,$notebookName,$MaxAddress);
?>
ข้อมูลทั่วไปบุคลากร - ข้อมูลงานวิจัย - เพิ่มประวัติผลงานวิจัย
freeresult($result0);
/** Close the Database */
$dbObj->disconn();
/** Unset Class */
unset($dbObj);
?> |