Viewing file:  FrmConFaculty.php (8.14 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
session_start();
/** Define Validate Access */
define( '_VALID_ACCESS', 1 );
/** Check Session User Login */
if (! session_is_registered("valid_user") &&session_is_registered("Priority") ) {
echo "<meta http-equiv=\"Content-Type\" content=\"text/html; charset=windows-874\" />";
echo "<p style=padding-top:115px><p align=center><br /><font color=red><strong>กรุณาทำการ Login ก่อน</strong></font></p></p>";
echo "<meta http-equiv=\"refresh\" content=\"1; URL=../login.php\" />";
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 conId='$conId' and Faculty_code='$Faculty_code' ";
$result1= mysql_query($sql) or die(" Error").mysql_error();
$num = $dbObj->_numrows;
$row = mysql_fetch_array($result1);
$query5 = " UPDATE $myTable1 SET Group_name='$Group_name', Group_nameE='$Group_nameE' Where conId='$conId' and Faculty_code='$Faculty_code' ";
$result5 = $dbObj->runQuery($query5);
$dbObj->freeresult($result5);
/** 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
} # else
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-874" />
<title>Edit Password</title>
<link href="../css/default.css" rel="stylesheet" type="text/css" />
</head>
<table width="454" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="440" height="135">
<fieldset>
<form id="form1" name="form1" method="post" action=" <?=$PHP_SELF;?>?Faculty_code=<?=$Faculty_code;?>&conId=<?=$conId;?>" >
<table width="98%" border="0" align="center" cellpadding="0" cellspacing="0" style="background-color:#eeeeee; border:0px solid gray; font-family: Verdana, Geneva, sans-serif; font-size: 14px;"size="12">
<tr bgcolor="#F3D6F2">
<td colspan="5" bgcolor="#FFFFFF"> </td>
</tr>
<tr bgcolor="#F3D6F2">
<td colspan="5" bgcolor="#FFFFFF"><font face="Tahoma">กลุ่ม /หน่วยงาน (Th)</font><font color="#0000FF" size="2" face="Tahoma">
<input name="Group_name" type="text" id="Group_name" style="BORDER-RIGHT: 0px; BORDER-TOP: 0px; BORDER-LEFT: 0px; BORDER-BOTTOM: black 1px dashed" value="<? echo $row[Group_name];?>" size="30" />
</font></td>
</tr>
<tr bgcolor="#F3D6F2">
<td colspan="5" bgcolor="#FFFFFF"><font face="Tahoma">กลุ่ม /หน่วยงาน</font> (Eng)<font color="#0000FF" size="2" face="Tahoma">
<input name="Group_nameE" type="text" id="Group_nameE" style="BORDER-RIGHT: 0px; BORDER-TOP: 0px; BORDER-LEFT: 0px; BORDER-BOTTOM: black 1px dashed" value="<? echo $row[Group_nameE];?>" size="30" />
</font></td>
</tr>
<tr bgcolor="#F3D6F2">
<td colspan="5" bgcolor="#FFFFFF"> </td>
</tr>
<tr bgcolor="#F3D6F2">
<td colspan="5" align="center" bgcolor="#FFFFFF"><input name="conId" type="hidden" id="conId" value="<? echo $row[conId]?>&<? echo $row[Faculty_code];?>" />
<input type="submit" name="Submit" value=" บันทึก " class="button" id="Submit" />
<input type="button" name="action" id="action" value=" ปิดหน้าต่าง" onclick="window.close();" /></td>
</tr>
<tr bgcolor="#F3D6F2">
<td colspan="5" bgcolor="#FFFFFF"> </td>
</tr>
<tr bgcolor="#F3D6F2">
<td colspan="5" align="right" bgcolor="#FFFFFF"><div align="Right"><span style="padding-bottom:5px">
<input type="submit" name="action" id="action" value="Delete" class="TEXT-CLIMSON10" onclick="return confirmDelete(this.form);" />
</span></div></td>
</tr>
<tr bgcolor="#F3F3F3">
<td width="27%" bordercolor="#CCCCCC" bgcolor="#FFFFFF"><font face="Tahoma">หน่วยงาน/ภาค/ฝ่าย </font></td>
<td colspan="4" bordercolor="#FFFFCC" bgcolor="#FFFFFF"><font color="#003366" size="2" face="Tahoma"><?php echo $rss['Faculty_name']; ?></font><font color="#003366" size="2" face="Tahoma"></a> </font><font size="2" face="Tahoma"> </font></td>
</tr>
<?php
$query = " SELECT * FROM $myTable1 WHERE Faculty_code='$Faculty_code' ";
$result = $dbObj->execQuery($query);
$numrows = $dbObj->_numrows;
?>
<?php
$no = 1+($display-1)*$limit;
while( $row = $dbObj->fetchArray($result) ) {
$bgColor = ( $bgColor == "#FFFFFF" ) ? "#F9FBFB" : "#FFFFFF";
?>
<tr bgcolor="#F3F3F3">
<td height="20" align="center" bordercolor="#CCCCCC" bgcolor="#FFFFFF"> </td>
<td width="4%" bordercolor="#FFFFCC" bgcolor="#FFFFFF"> </td>
<td width="61%" bordercolor="#FFFFCC" bgcolor="#FFFFFF"> <img src="../picture/linesub.gif" width="16" height="16" border="0" align="absmiddle" /><?php echo $row['Group_name']; ?> (<?php echo $row['Group_nameE']; ?>)</td>
<td width="2%" align="center" bordercolor="#FFFFCC" bgcolor="#FFFFFF"><a href="FrmEditFaculty.php?Faculty_code=<?=$row['Faculty_code'];?>"></a></td>
<td width="6%" align="center" bordercolor="#FFFFCC" bgcolor="#FFFFFF">
<input type="checkbox" name="id[]" value="<?=$row['conId'];?>&<?=$row['Faculty_code'];?>" onclick="highlightRow(this);" title=" ลบข้อมูล <?php echo $row['conId']; ?>=<?php echo $row['Faculty_code'];?> " />
</td>
</tr>
<?php
$no++;
} # while
$dbObj->freeresult($result1);
?>
<tr bgcolor="#F3F3F3">
<td align="center" bordercolor="#CCCCCC" bgcolor="#FFFFFF"> </td>
<td bordercolor="#FFFFCC" bgcolor="#FFFFFF"> </td>
<td bordercolor="#FFFFCC" bgcolor="#FFFFFF"> </td>
<td bordercolor="#FFFFCC" bgcolor="#FFFFFF"> </td>
<td bordercolor="#FFFFCC" bgcolor="#FFFFFF"> </td>
</tr>
<td colspan="5" bgcolor="#FFFFFF"></a></a></td>
</tr>
</table>
</form>
</fieldset></td>
</tr>
</table>
<?php
/** Close the Database */
$dbObj->disconn();
/** Unset Class */
unset($dbObj);
?>
|