跳转到主内容
趣航编程网 - 趣学编程，启航技术之路！
📁 网站地图

基于Sql Server 2008的分布式数据库的实践（五）

顺亿
顺亿
• 👁 0人浏览过
程序设计 ----------------------------------------------------------------------------------------------------------------- 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" '' '' '' '' ''; "\t\n" "
".[]."
'.["sid"].''.["sname"].''.["school"].''.["scount"].'******
\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]='选课' '
' "\n" "\t\n" "\t\n" "\t\n" (=0;<7;++ "\t\t\n" (=0;<;++ = '' ([]=='0' []='男' []='女' (=0;<;++ ([]==[ = 'checked' "\t\n" '' '' '' '' '' '' ''; "\t\n" "\t\n" "
选课系统
".[]."
'.[].''.[].''.[].''.[].''.[].''.[].'[].' '..'>
\n" "" }
学生退课
(['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]='退课' '
' "\n" "\t\n" "\t\n" "\t\n" (=0;<7;++ "\t\t\n" "\t\n" (=0;<;++ ([]=='0' []='男' []='女' "\t\n" '' '' '' '' '' '' '' "\t\n" "\t\n" "
我选上的课
".[]."
'.[].''.[].''.[].''.[].''.[].''.[].'
\n" "" }
学生查看成绩
=['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" '' '' '' '' '' ''; '' "\t\n" "
".[]."
'.["tid"].''.["tname"].''.["tage"].''.["tsex"].''.["tcount"].'******'.["tsuper"].'
\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" '' '' '' '' '' ''; '' "\t\n" "
".[]."
'.["tid"].''.["tname"].''.["tage"].''.["tsex"].''.["tcount"].'******'.["tsuper"].'
\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" (=0;<5;++ "\t\t\n" "\t\n" (=0; < [ ];++ ([][]=="999" [][]="未上传成绩" ([][]=='0' "\t\n" '' '' '' '' '' "\t\n" "
".[]."
'.[].''.[].''.[][].''.[][].''.[][].'
\n" }
老师上传成绩
((['up' =["uid" =['cid' ="SELECT * FROM [V3].[dbo].[class] where [cid]=".." AND [tid] = ".."" = mssql_query( =0; ( = mssql_fetch_array(, []=['score' []=['sid' ++ (=0;;++ ([]=='0' ((["sid_[]" (["sid_[]"]

相关文章