当前位置:Gxlcms > PHP教程 > 基于SqlServer2008的分布式数据库的实践(五)_PHP教程

基于SqlServer2008的分布式数据库的实践(五)_PHP教程

时间: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"              ''              ''              ''              ''              '';
          "\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]='选课'      输出
 
      '" }

学生退课

 
 (['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"                      ''                      ''                      ''                      ''                      ''                      '';
                      ''              "\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_[]"]<=100&&

                  

	 	
                    
                    
                    
                    
                    
                

人气教程排行