📄 regschool.php3
字号:
<?
/*大家好，我是豆腐
提供原码是我的一贯原则，但是希望大家能够尊重豆腐的工作
希望大家在使用的过程中随时和我联系 roboo@21cn.com
您可以随意修改代码，但是请保留我的注释（如果不保留，我也没办法）
如果您觉得这个程序对您有或多或少的帮助，豆腐希望能够得到您的鼓励
您的鼓励和支持，是我们工作的最大动力
. =======
/ \| O O |
\ / \v_'/
# _| |_
(#) ( )
#\//|* *|\\
#\/( * )/ //豆腐制作，都是精品
# =====
# (\ /)
# || ||
.#---'| |----.
#----' -----'
//哲人说：用我的心换你的心，我们便拥有两颗心
*/
?>
<?
include("conn.php3");
include("db.php3");
include("userfunc.php3");
?>
<HTML>
<HEAD>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" type="text/css" href="class.css">
<TITLE>同学录__注册学校班级</TITLE>
</HEAD>
<script>
function SetValue(type,str){
this.frmschool.txtSchool.value="asdasd";
}
</script>
<BODY>
<?
if($step==1){
//选定城市
$conn=openconn();
$SQL="Select distinct schoolcity from " . $DataBaseOwerName . ".class_school where SchoolProvince='" . $selProvince . "' and schoolType='" . $selType . "'";
$stmt1=opensql($conn,$SQL);
?>
<form action=<? echo $PHP_SELF ?>?step=2 method="post">
已经有的城市:
<select name="selCity" class=selectface>
<? while($stmt=fecthrow($stmt1)){?>
<OPTION value="<? echo getcolumn($stmt,"SCHOOLCITY") ?>"><?echo getcolumn($stmt,"SCHOOLCITY")?></option>
<?}?>
</select>
<br>
其他:<input type=text name="txtCity" maxlength=20 size=15 class=editface>
<input type=hidden name="txtProvince" value="<? echo $selProvince ?>">
<input type=hidden name="txtType" value="<? echo $selType ?>">
<input type=hidden name="userid" value="<? echo $userid?>">
<br>
<input type="submit" name="cmdDo" value="确定" class=buttonface>
</form>
<?
}
?>
<?
if($step==2){
//选定学校
$conn=openconn();
if($txtCity!=""){
$strCity=$txtCity;
}
else{
if($selCity==""){
echo "必须选定您所想要注册的学校的所在地！";
exit;
}
$strCity=$selCity;
}
$SQL="Select schoolname,regtime,classnum from " . $DataBaseOwerName . ".class_school where SchoolProvince='" . $txtProvince . "' and schooltype='" . $txtType . "' and schoolcity='" . $strCity . "' order by schoolname" ;
$stmt1=opensql($conn,$SQL);
?>
<form action=<? echo $PHP_SELF ?>?step=3 method="post" name=frmschool>
<table border=1 width=100%>
<tr>
<td>学校名称</td>
<td>注册时间</td>
<td>班级数量</td>
</tr>
<? while($stmt=fecthrow($stmt1)){ ?>
<tr>
<td><a href="<?echo $PHP_SELF?>?step=3&txtSchool=<? echo getcolumn($stmt,'SCHOOLNAME') ?>&txtProvince=<? echo $txtProvince ?>&txtType=<? echo $txtType ?>&userid=<? echo $userid?>&txtCity=<? echo $strCity ?>"><? echo getcolumn($stmt,"SCHOOLNAME") ?></a></td>
<td><? echo getcolumn($stmt,"REGTIME") ?></td>
<td><? echo getcolumn($stmt,"CLASSNUM") ?></td>
</tr>
<?}?>
</table>
<br>
上面仍然没有你的学校！请在下面填写您的学校名称:<br>
<input type=text name="txtSchool" class=editface>
<input type=hidden name="txtProvince" value="<? echo $txtProvince ?>">
<input type=hidden name="txtType" value="<? echo $txtType ?>">
<input type=hidden name="userid" value="<? echo $userid?>">
<input type=hidden name="txtCity" value="<? echo $strCity ?>"> <br>
<input type=submit value="确定" name="cmdDo" class=buttonface>
</form>
<?
}
?>
<?
if($step==3){
//开始选定班级
if($txtSchool!=""){
$school=$txtSchool;
}
else{
echo "必须填写学校名称";
exit;
}
$SQL="select schoolid,schoolname from " . $DataBaseOwerName . ".class_school where schoolname='" . $school . "'";
$conn=openconn();
$stmt=opensql($conn,$SQL);
$stmt=FecthRow($stmt);
if(getcolumn($stmt,"SCHOOLNAME")!=$school){
//一所新录入的学校
$RegTime=$TTime=date("Y-n-d"). " " . date("H:i:s");
$SQL="insert into " . $DataBaseOwerName . ".class_school(SchoolName,schoolType,SchoolProvince,schoolCity,RegTime,ClassNum)values(";
$SQL=$SQL . "'" . $school . "','" . $txtType . "','" . $txtProvince . "','" . $txtCity . "','" . $RegTime . "',0)";
$stmt=opensql($conn,$SQL);
$SQL="select max(schoolid) maxid from class_school";
$stmt=opensql($conn,$SQL);
$stmt=FecthRow($stmt);
$schoolID=getcolumn($stmt,"maxid");
}
else{
$schoolID=getcolumn($stmt,"SCHOOLID");
}
//列出这个学校的所有班级
$SQL="select * from " . $DataBaseOwerName . ".class_class where SchoolID='" . $schoolID . "'";
$stmt1=opensql($conn,$SQL);
?>
<form action=<? echo $PHP_SELF ?>?step=4 method="post">
<table border=1>
<tr>
<td>班级名称</td>
<td>注册时间</td>
<td>注册人数</td>
</tr>
<? while($stmt=fecthrow($stmt1)){ ?>
<tr>
<td><a href="<? echo $PHP_SELF ?>?step=4&txtClass=<? echo getcolumn($stmt,"CLASSNAME") ?>&userid=<? echo $userid ?>&txtSchoolID=<? echo $schoolID ?>"><? echo getcolumn($stmt,"CLASSNAME") ?></td>
<td><? echo getcolumn($stmt,"REGTIME") ?></td>
<td><? echo getcolumn($stmt,"REGNUM") ?></td>
</tr>
<?}?>
</table>
上面仍然没有你的班级！请在下面填写您的班级名称:<br>
<input type=hidden name="txtSchoolID" value="<? echo $schoolID ?>">
<input type=text name="txtClass" class=editface>
<input type=hidden name="userid" value="<? echo $userid?>">
<input type=submit value="确定" name="cmdDo" class=buttonface>
</form>
<?
}
?>
<?
if($step==4){
//选定班级,注册结束
if($txtClass==""){
echo "必须填写班级名称";
exit;
}
$SQL="select ClassID,ClassName From " . $DataBaseOwerName . ".Class_Class Where ClassName='" . $txtClass . "' and schoolid='" . $txtSchoolID . "'";
$conn=openconn();
$stmt1=opensql($conn,$SQL);
$stmt=fecthrow($stmt1);
if(getcolumn($stmt,"CLASSNAME")==$txtClass){
//这个班级已经存在
$ClassID=getcolumn($stmt,"CLASSID");
$SQL="select ClassId From " . $DataBaseOwerName . ".Class_UserRelation Where ClassID='" . $ClassID . "' and userid='" . $userid . "'";
$stmt1=opensql($conn,$SQL);
$stmt=fecthrow($stmt1);
if(getcolumn($stmt,"CLASSID")==$ClassID){
//这个用户已经登记过这个班级编号
echo "对不起，一个班级您只能登记一次";
exit;
}
$SQL="insert into " . $DataBaseOwerName . ".Class_UserRelation(userid,classid) values('" . $userid . "','" . $ClassID . "')";
$stmt=opensql($conn,$SQL);
$SQL="Update " . $DataBaseOwerName . ".Class_Class set regNum=regNum + 1 where schoolid = '" . $txtSchoolID . "'";
$stmt=opensql($conn,$SQL);
?>
<?
$SQL="select * from " . $DataBaseOwerName . ".class_UserRelation where userid='" . $userid . "'";
$stmt1=opensql($conn,$SQL);
include("welcometemplate.php3");
exit;
}
//班级不存在，需要设置ClassID
?>
您所登记的班级在系统中首次出现，请给这个班级设置一个代号:
<form action=<? echo $PHP_SELF ?>?step=5 method="post">
<input type=text name="txtClassID" class=editface>
<input type=hidden name="userid" value="<? echo $userid?>">
<input type=hidden name="txtSchoolID" value="<? echo $txtSchoolID ?>">
<input type=hidden name="txtClass" value="<? echo $txtClass ?>">
<br>
<input type=submit name="cmdDo" value="确定" class=buttonface>
</form>
<?
}
?>
<?
if($step==5){
//最后一步
if($txtClassID==""){
echo "对不起，必须输入班级的代号！";
exit;
}
$SQL="select ClassID from " . $DataBaseOwerName . ".Class_cLass Where Classid='" . $txtClassID . "'";
$conn=openconn();
$stmt1=opensql($conn,$SQL);
$stmt=fecthrow($stmt1);
if(getcolumn($stmt,"CLASSID")==$txtClassID){
//这个班级编号已经存在
echo "对不起，您填写的班级编号已经存在，请重新挑选一个班级编号！";
exit;
}
//一切就绪，登记班级
$RegTime=$TTime=date("Y-n-d"). " " . date("H:i:s");
$SQL="insert into " . $DataBaseOwerName . ".Class_Class(ClassID,SchoolID,ClassName,RegTime,RegNum,ManagerID)values(";
$SQL=$SQL . "'" . $txtClassID . "','" . $txtSchoolID . "','" . $txtClass . "','" . $RegTime . "',1,'" . $userid . "')";
$stmt=opensql($conn,$SQL);
$DateTimeStr=$TTime=date("Y-n-d"). " " . date("H:i:s");
$SQL="insert into " . $DataBaseOwerName . ".Class_UserRelation values('" . $userid . "','" . $txtClassID . "',1,'" . $DateTimeStr . "','" . $DateTimeStr . "')";
$stmt=opensql($conn,$SQL);
$SQL="Update " . $DataBaseOwerName . ".Class_School set classnum=classnum + 1 where schoolid = '" . $txtSchoolID . "'";
$stmt=opensql($conn,$SQL);
$SQL="select * from " . $DataBaseOwerName . ".Class_UserRelation where userid='" . $userid . "'";
$stmt1=opensql($conn,$SQL);
include("welcometemplate.php3");
exit;
}
?>
<input type=submit value="返回上一级" onclick="history.back()" class=buttonface>
</BODY>
</HTML>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -