function doInsert()
{
if (isset($_POST['savecourse'])) {
if ($_POST['coursename'] == "" or $_POST['coursedesc'] == "") {
message("All field is required!", "error");
check_message();
} else {
$course = new Course();
$coursename = $_POST['coursename'];
$courselevel = $_POST['level'];
$coursemajor = $_POST['major'];
$coursedesc = $_POST['coursedesc'];
$coursedept = $_POST['dept'];
$res = $course->find_all_course($coursename, $courselevel, $coursemajor);
if ($res >= 1) {
message("Course name already exist!", "error");
check_message();
} else {
$course->COURSE_NAME = $coursename;
$course->COURSE_LEVEL = $courselevel;
$course->COURSE_MAJOR = $coursemajor;
$course->COURSE_DESC = $coursedesc;
$course->DEPT_ID = $coursedept;
$istrue = $course->create();
if ($istrue == 1) {
message("New [" . $coursename . "] course created successfully!", "success");
redirect('index.php');
}
}
}
}
}
function doInsert()
{
if (isset($_POST['savecourse'])) {
if ($_POST['subjcode'] == "" or $_POST['subjdesc'] == "" or $_POST['unit'] == "") {
message("All field is required!", "error");
check_message();
} else {
$subj = new Subject();
$subjcode = $_POST['subjcode'];
$subjdesc = $_POST['subjdesc'];
$unit = $_POST['unit'];
$pre = $_POST['pre'];
$course = $_POST['course'];
$ay = $_POST['ay'];
$Semester = $_POST['Semester'];
$subj->SUBJ_CODE = $subjcode;
$subj->SUBJ_DESCRIPTION = $subjdesc;
$subj->UNIT = $unit;
$subj->PRE_REQUISITE = $pre;
$subj->COURSE_ID = $course;
$subj->AY = $ay;
$subj->SEMESTER = $Semester;
$istrue = $subj->create();
if ($istrue == 1) {
message("New Subject created successfully!", "success");
redirect('index.php');
}
}
} elseif (isset($_POST['saveandnewcourse'])) {
if ($_POST['subjcode'] == "" or $_POST['subjdesc'] == "" or $_POST['unit'] == "") {
message("All field is required!", "error");
check_message();
} else {
$subj = new Subject();
$subjcode = $_POST['subjcode'];
$subjdesc = $_POST['subjdesc'];
$unit = $_POST['unit'];
$pre = $_POST['pre'];
$course = $_POST['course'];
$ay = $_POST['ay'];
$Semester = $_POST['Semester'];
$subj->SUBJ_CODE = $subjcode;
$subj->SUBJ_DESCRIPTION = $subjdesc;
$subj->UNIT = $unit;
$subj->PRE_REQUISITE = $pre;
$subj->COURSE_ID = $course;
$subj->AY = $ay;
$subj->SEMESTER = $Semester;
$istrue = $subj->create();
if ($istrue == 1) {
message("New Subject created successfully!", "success");
redirect('index.php?view=add');
}
}
}
}
<?php
require_once 'config/tank_config.php';
$colname_Recordset_anc = "2";
mysql_select_db($database_tankdb, $tankdb);
$query_Recordset_anc = sprintf("SELECT * FROM tk_announcement WHERE tk_anc_type = %s ORDER BY tk_anc_lastupdate DESC", GetSQLValueString($colname_Recordset_anc, "text"));
$Recordset_anc = mysql_query($query_Recordset_anc, $tankdb) or die(mysql_error());
$row_Recordset_anc = mysql_fetch_assoc($Recordset_anc);
$totalRows_Recordset_anc = mysql_num_rows($Recordset_anc);
$message_count = check_message($_SESSION['MM_uid']);
$self = $_SERVER['PHP_SELF'];
$pagename = explode("/", $self);
$pagename = end($pagename);
?>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>综合所</title> <!--TODO：zhl 修改wss-->
<link href="bootstrap/css/bootstrap.css" rel="stylesheet" media="screen"> <!--bootstrap V3 ,201501 by superlin-->
<link href="skin/themes/base/tk_style.css" rel="stylesheet" type="text/css" />
<link href="skin/themes/base/lhgdialog.css" rel="stylesheet" type="text/css" />
<link href="skin/themes/base/zhs_zhl_style.css" rel="stylesheet" type="text/css" /> <!--综合所系统定制的css，by zhl -->
<script type="text/javascript" src="srcipt/jquery.js"></script> <!--jQuery v2.1.0-->
<script type="text/javascript" src="srcipt/js.js"></script>
<script src="bootstrap/js/bootstrap.js"></script> <!--bootstrap v3.3.4 ,201501 by superlin-->
<script type="text/javascript" src="srcipt/lhgcore.js"></script>
<script type="text/javascript" src="srcipt/lhgdialog.js"></script> <!--原wss使用的Dialog组件，V2，2009-->
function doEdit()
{
$instid = $_GET['id'];
if (isset($_POST['savefaculty'])) {
if ($_POST['name'] == "" or $_POST['address'] == "" or $_POST['email'] == "") {
message("All field is required!", "error");
check_message();
} else {
$inst = new Instructor();
$name = $_POST['name'];
$address = $_POST['address'];
$Gender = $_POST['Gender'];
$civilstats = $_POST['civilstats'];
$specialization = $_POST['specialization'];
$email = $_POST['email'];
$empStats = $_POST['empStats'];
$inst->INST_FULLNAME = $name;
$inst->INST_ADDRESS = $address;
$inst->INST_SEX = $Gender;
$inst->INST_STATUS = $civilstats;
$inst->SPECIALIZATION = $specialization;
$inst->INST_EMAIL = $email;
$inst->EMPLOYMENT_STATUS = $empStats;
$inst->update($instid);
message($name . "has been updated successfully!", "success");
redirect('index.php');
}
}
}
<?php
check_message();
?>
<div class="well">
<form action="controller.php?action=delete" Method="POST">
<table class="table table-hover">
<caption><h3 align="left">List of Department</h3></caption>
<thead>
<tr>
<th> <input type="checkbox" name="chkall" id="chkall" onclick="return checkall('selector[]');"> Department Name</th>
<th>Department Description</th>
</tr>
</thead>
<tbody>
<?php
$dept = new Dept();
$cur = $dept->listOfDept();
foreach ($cur as $Department) {
echo '<tr>';
echo '<td><input type="checkbox" name="selector[]" id="selector[]" value="' . $Department->DEPT_ID . '"/>
<a href="index.php?view=edit&id=' . $Department->DEPT_ID . '">' . $Department->DEPARTMENT_NAME . '</a></td>';
echo '<td colspan="3">' . $Department->DEPARTMENT_DESC . '</td>';
echo '</tr>';
}
?>
</tbody>
<tfoot>
<tr><td></td><td></td></tr>
