Viewing file: AddConFaculty.php (10.48 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;
/** Chart */
/** Config Table for This Page */
$myTable = "faculty_tb";
$myTable1 = "facultycon_tb";
$myTableFK = "conId";
$sql = "Select * From $myTable Where Faculty_code='$Faculty_code'";
$result = mysql_query($sql) or die(" Error").mysql_error();
$rss = mysql_fetch_array($result);
/////////////////////////////////
$sql = "Select * From $myTable1 Where Faculty_code='$Faculty_code'";
$result1= mysql_query($sql) or die(" Error").mysql_error();
$num = $dbObj->_numrows;
$row = mysql_fetch_array($result1);
/** Botton Name Action */
$action = $_REQUEST['action'];
$id = $_REQUEST['id'];
/*if( isset($action) && !empty($action) ) {
switch($action) {
case "Delete" :
$num = count($id);
for( $i=0; $i<$num; $i++ ) {
//--- tech_plan_tb
$qrySel = " SELECT * FROM $myTable1 WHERE $myTableFK='$id[$i]' ";
$resultSel = $dbObj->execQuery($qrySel);
$rsSel = $dbObj->fetchObject($resultSel);
$Faculty_code = $rsSel->Faculty_code;
$qryDel = " DELETE FROM $myTable1 WHERE $myTableFK='$id[$i]' ";
$resultDel = $dbObj->runQuery($qryDel);
$dbObj->freeresult($resultDel);
}
break;
} # switch
} # if*/
if(isset($_REQUEST['action'])){
switch($_REQUEST['action']){
case "saveAdd" :
$sql = "INSERT INTO facultycon_tb(Faculty_code, Group_name, Group_nameE) VALUES ('".$_REQUEST['Faculty_code']."', '".$_REQUEST['Group_name']."', '".$_REQUEST['Group_nameE']."')";
mysql_query($sql);
$message = "เพิ่มข้อมูลกลุ่มงานเรียบร้อยแล้ว";
break;
case "saveEdit" :
$sql = "UPDATE facultycon_tb SET Faculty_code = '".$_REQUEST['Faculty_code']."', Group_name = '".$_REQUEST['Group_name']."', Group_nameE = '".$_REQUEST['Group_nameE']."' WHERE conId = '".$_REQUEST['conId']."'";
mysql_query($sql);
$message = "แก้ไขข้อมูลกลุ่มงานเรียบร้อยแล้ว";
break;
case "delete" :
$sql = "DELETE FROM facultycon_tb WHERE conId = '".$_REQUEST["conId"]."'";
mysql_query($sql);
$message = "ลบข้อมูลกลุ่มงานเรียบร้อยแล้ว";
break;
}
}
} # else
?>
=$_Config_sitename;?>
| |