时间:2021-07-01 10:21:17 帮助过:10人阅读
-----------------------------------------------------------------------------------------------------------------
Index.php————选择界面,并且实现学生和老师的注册
sql_ini.php————SQL配置文件
./student————学生的后台
./admin————老师的后台
-----------------------------------------------------------------------------------------------------------------
./student
cookie.php————cookie转跳文件
index1.php————后台界面
login.php————登录界面
loginout.php————cookie注销处理
main.php————主界面
menu.php————后台菜单
sclass.php————显示学生选课信息
score.php-————显示学生成绩
sinfo.php————显示*
sql_ini.php————SQL配置文件
up.php————后台表单处理文件
-----------------------------------------------------------------------------------------------------------------
./admin
class.php————显示老师课程信息
cookie.php————cookie转跳文件
index1.php————后台界面
info.php————显示老师资料(有权限设置)
login.php————登录界面
loginout.php————cookie注销处理
main.php————主界面
menu.php————后台菜单
score.php-————登记学生成绩
sql_ini.php————SQL配置文件
up.php————后台表单处理文件
((['addstudent'
((['sname']=='')||(['sex']=='')||(['school']=='')||(['scount']=='')||(['spwd1']=='')||(['spwd2']=='' '请输全信息!'
=['sname' =['sex' =['school' =['scount' =['spwd1' =['spwd2' =(1,9999);
(==
="select * from [V3].[dbo].[V3_student]" = mssql_query(
( = mssql_fetch_array(,
(['scount']==
("已经有人申请了这个帐号!"
=" VALUES ("..",'".."','".."','".."','".."','".."')" = mssql_query(
( { "注册成功! "
{ "sql出错!"
("两次密码不对" }
((['addadmin'
((['name']=='')||(['sex']=='')||(['age']=='')||(['count']=='')||(['pwd']=='')||(['pwd2']=='')||(['ageage']=='')||(['tel']=='')||(['address']=='' '请输全信息!'
=['name' =['sex' =['age' =['count' =['pwd' =['pwd2' =['ageage' =['tel' =['address' =1 =(1,9999
(==
="select * from [V3].[dbo].[teacher]" = mssql_query(
( = mssql_fetch_array(,
(['tcount']==
("已经有人申请了这个帐号!" ="EXEC [V3].[dbo].[V3_teacher] "..",'".."', '".."', '".."', '".."', '".."', '".."','".."','".."','".."'" = mssql_query( ( { "注册成功! "
{ "sql出错!"
("两次密码不对" }
=['uid'
= "SELECT * FROM [V3].[dbo].[V3_student] where [sid]=".."" = mssql_query(
=mssql_num_fields(
[0]='学号' [1]='姓名' [2]='学院' [3]='帐号' [4]='密码' 输出
"\n" "\t\n" (=0;<;++ 输出字段中文含义
"\t\t".[]." \n" "\t \n" ( = mssql_fetch_array(, 输出内容
"\t\n" ''.["sid"].' ' ''.["sname"].' ' ''.["school"].' ' ''.["scount"].' ' '****** ';
"\t \n" "
\n"
mssql_free_result();
(['action']=='do'
=["uid"
="SELECT * FROM [V3].[dbo].[class] where [sid]=".."" = mssql_query( =0;
( = mssql_fetch_array(, []=['cid' ++
="SELECT * FROM [V3].[dbo].[class] where [sid] = 0" = mssql_query( =0;
( = mssql_fetch_array(, []=['tid' []=['cid' []=['cname' ++
(=0;<;++ []="SELECT * FROM [V3].[dbo].[teacher] where [tid]=".[]."" []= mssql_query([ ( = mssql_fetch_array([], []=['tsex' []=['tage' []=['tname'
[0]='课号' [1]='课名' [2]='老师名字' [3]='老师编号' [4]='老师教学年龄' [5]='老师性别' [6]='选课' 输出
'" }
(['action']=='mine'
=["uid"
="SELECT * FROM [V3].[dbo].[class] where [sid]=".."" = mssql_query( =0;
( = mssql_fetch_array(, []=['cid' []=['cname' []=['tid' ++
(=0;<;++ []="SELECT * from [V3].[dbo].[teacher] where [tid]=".[]."" [] = mssql_query([ ( = mssql_fetch_array([], []=['tsex' []=['tage' []=['tname'
[0]='课号' [1]='课名' [2]='老师名字' [3]='老师编号' [4]='老师教学年龄' [5]='老师性别' [6]='退课' 输出
'" }
=['uid'
="SELECT * FROM [V3].[dbo].[class] where [sid]=".."" = mssql_query( =0;
( = mssql_fetch_array(, []=['cid' []=['cname' []=['tid' []=['score' ++
(=0;<;++ []="SELECT * from [V3].[dbo].[teacher] where [tid]=".[]."" [] = mssql_query([ ( = mssql_fetch_array([], []=['tsex' []=['tage' []=['tname'
[0]='课号' [1]='课名' [2]='老师名字' [3]='老师编号' [4]='老师教学年龄' [5]='老师性别' [6]='分数' 输出
"\n" "\t我选上的课 \n" "\t\n" "\t\n"
(=0;<7;++ "\t\t".[]." \n" "\t \n" (=0;<;++ ([]=='0' []='男'
[]='女'
([]=='999' []='未上成绩' "\t\n" ''.[].' ' ''.[].' ' ''.[].' ' ''.[].' ' ''.[].' ' ''.[].' ' ''.[].' '
"\t \n" "
\n";
(['people']=='all' (["super"]=='10'
= "SELECT * FROM [V3].[dbo].[teacher]" = mssql_query(
输出
"\n"
=mssql_num_fields(
[0]='编号' [1]='姓名' [2]='教学年龄' [3]='性别' [4]='登录帐号' [5]='登录密码' [6]='管理权限'
"\t\n" (=0;<;++ "\t\t".[]." \n" "\t \n"
( = mssql_fetch_array(,
(["tsex"]=='0' ["tsex"]='男'
["tsex"]='女'
(["tsuper"]=='10' ["tsuper"]='超级老师管理员'
["tsuper"]='普通老师管理员'
输出内容
"\t\n" ''.["tid"].' ' ''.["tname"].' ' ''.["tage"].' ' ''.["tsex"].' ' ''.["tcount"].' ' '****** ';
''.["tsuper"].' ' "\t \n" "
\n"
mssql_free_result(
"没有权限查看!" }
(['people']=='me'
=["uid"
= "SELECT * FROM [V3].[dbo].[teacher] where tid=".."" = mssql_query( 输出
"\n"
=mssql_num_fields(
[0]='编号' [1]='姓名' [2]='教学年龄' [3]='性别' [4]='登录帐号' [5]='登录密码' [6]='管理权限'
"\t\n" (=0;<;++ "\t\t".[]." \n" "\t \n" ( = mssql_fetch_array(,
(["tsex"]=='0' ["tsex"]='男'
["tsex"]='女'
(["tsuper"]=='10' ["tsuper"]='超级老师管理员'
["tsuper"]='普通老师管理员'
输出内容
"\t\n" ''.["tid"].' ' ''.["tname"].' ' ''.["tage"].' ' ''.["tsex"].' ' ''.["tcount"].' ' '****** ';
''.["tsuper"].' ' "\t \n" "
\n"
mssql_free_result( }
((['addsub'
=['name' =['sex' =['age' =['count' =['pwd' =['pwd2' =['super' =['idid' =['ageage' =['tel' =['address'
(==
="select * from [V3].[dbo].[teacher]" = mssql_query(
( = mssql_fetch_array(,
(['tcount']==
("已经有人申请了这个帐号!"
="EXEC [V3].[dbo].[V3_teacher] "..",'".."', '".."', '".."', '".."', '".."', '".."','".."','".."','".."'" = mssql_query( ( { "添加成功!"
{ "sql出错!"
("两次密码不对" }
((['delsub' =['id' ="DELETE FROM [V3].[dbo].[teacher] where [tid]=".."" = mssql_query( ( { "删除成功"
{ "SQL出错!" }
((['addclass'
=['id' =['name'
="INSERT INTO [V3].[dbo].[class] ([sid], [tid], [cname],[score],[cid]) VALUES (0, "..", '".."',999,".(1,999).")" = mssql_query( ( { "创建课程成功"
{ "SQL出错!" }
(['action']=='list'
=["uid"
="SELECT * FROM [V3].[dbo].[class] where [tid]=".." AND [sid] = 0" = mssql_query( =0;
( = mssql_fetch_array(, []=['cid' []=['cname' ++
(=0;<;++ []="SELECT * FROM [V3].[dbo].[class] where [tid]=".." AND [cid] = ".[]."" []= mssql_query([ []=mssql_num_rows([
[0]='课号' [1]='课名' [2]='选课人数' 输出
"\n" "\t老师号:".." \n" "\t\n"
(=0;<3;++ "\t\t".[]." \n" "\t \n" (=0;<;++
[]=[]-1 "\t\n" ''.[].' ' ''.[].' ' ''.[].' ' "\t \n" "
\n" ?>
((['delclass'
=['cid'
="DELETE FROM [V3].[dbo].[class] where [cid]=".."" = mssql_query( ( { "删除课程成功"
{ "SQL出错!";}
(['action']=='show'
=["uid"
="SELECT * FROM [V3].[dbo].[class] where [sid]=0 AND [tid] = ".."" = mssql_query( =0;
( = mssql_fetch_array(, []=['cid' []=['cname' ++
(=0;<;++
="SELECT * FROM [V3].[dbo].[class] where [cid]=".[]." AND [tid] = ".."" = mssql_query( =0;
( = mssql_fetch_array(, [][]=['sid' [][]=['score' ++ []=;
(=0;<;++ (=0;<[];++
="SELECT * FROM [V3].[dbo].[V3_student] where [sid]=".[][]."" = mssql_query( ( = mssql_fetch_array(, [][]=['sname'
(['cid']=='0' (=0;<;++ "[]."'>查看__".[]."__课程情况!
" (=0;<;++ (['cid']==[
[0]='课号' [1]='课名' [2]='学生号' [3]='学生名' [4]='成绩' 输出
"\n" "\t\n"