📄 adddepart.php
字号:
<html>
<head>
<title>添加部门</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body>
<?php
include ("resp.inc");
$modopt=$_POST["modopt"];
if (strlen($_POST["depart"])<21) {
$depart=$_POST["depart"];
} else {
print "部门名称超长度限定\n";
$errnumb+=1;
}
if (strlen($_POST["depnum"])<4) {
$depnum=$_POST["depnum"];
} else {
print "部门编号长度超限定";
$errnumb+=1;
}
if (strlen($_POST["master"])<9) {
$master=$_POST["master"];
} else {
print "责任人名字超长度限定";
$errnumb+=1;
}
if (strlen($_POST["respon"])<601) {
$respon=$_POST["respon"];
} else {
print "部门职责介绍应不超过600字符/300汉字";
$errnumb+=1;
}
if ($errnumb<=0) {
resp_db_connect();
switch($_POST["man"]) {
case 'add':
$reslut=mysql_query("select * from depart where depart.depart='$depart'") or die("Invalid query: " . mysql_error());
if (mysql_num_rows($reslut)) {
print "同名称部门已存在，请核对";
}
elseif (mysql_num_rows(mysql_query("select * from depart where depart.depnum='$depnum'") )) {
print "同编号部门已存在，请核对";
}
else {
mysql_query("insert into depart (depart,depnum,master,respon) values ('$depart','$depnum','$master','$respon')")
or die("Invalid query: " . mysql_error());
print "数据库操作成功,该添加部门完成\n";
}
break;
case 'delete':
mysql_query("delete from depart where depart='$depart' or depnum='$depnum'") or die("Invalid query: " . mysql_error());
if (mysql_affected_rows()) {
print "成功删除";
} else {
print "不存在该部门,请返回检查";
}
break;
case 'modify' :
switch($modopt) {
case 'name2id' :
mysql_query("update depart set depnum='$depnum' where depart='$depart'") or die("Invalid query: " . mysql_error());
break;
case 'id2name' :
mysql_query("update depart set depart='$depart' where depnum='$depnum'") or die("Invalid query: " . mysql_error());
break;
case 'name2master' :
mysql_query("update depart set master='$master' where depart='$depart'") or die("Invalid query: " . mysql_error());
break;
case 'id2master' :
mysql_query("update depart set master='$master' where depnum='$depnum'") or die("Invalid query: " . mysql_error());
break;
case 'name2resp' :
mysql_query("update depart set respon='$respon' where depart='$depart'") or die("Invalid query: " . mysql_error());
break;
case 'id2resp' :
mysql_query("update depart set respon='$respon' where depnum='$depnum'") or die("Invalid query: " . mysql_error());
break;
}
if (mysql_affected_rows()) {
print "修改资料操作成功";}else {
print "修改操作没有进行，请核查填写数据是否正确";
}
}}
else {
print "请返回重新核对并正确填写有关数据\n";
}
?>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -