课程频道导航
课程分类导航
当前位置：首页 > 数据库 > Sqlserver

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

程序设计

-----------------------------------------------------------------------------------------------------------------

Index.php————选择界面，并且实现学生和老师的注册

sql_ini.php————SQL配置文件

<span ./student————学生的后台

<span ./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————后台表单处理文件

程序解释

学生注册

<span  1 <span if(<span isset(<span $_POST['addstudent'<span ]))
<span  2 <span {
<span  3     <span //<span 判断是否有空，即没有输入的
<span  4     <span if((<span $_POST['sname']=='')||(<span $_POST['sex']=='')||(<span $_POST['school']=='')||(<span $_POST['scount']=='')||(<span $_POST['spwd1']=='')||(<span $_POST['spwd2']==''<span ))
<span  5 <span     {
<span  6         <span echo '请输全信息！'<span ;
<span  7         <span exit<span ();
<span  8 <span     }
<span  9     <span //<span 把传递的数据赋值到变量里面
<span 10     <span $sname=<span $_POST['sname'<span ];
<span 11     <span $sex=<span $_POST['sex'<span ];
<span 12     <span $school=<span $_POST['school'<span ];
<span 13     <span $scount=<span $_POST['scount'<span ];
<span 14     <span $spwd1=<span $_POST['spwd1'<span ];
<span 15     <span $spwd2=<span $_POST['spwd2'<span ];
<span 16     <span $sid=<span rand(1,9999);<span //<span 随机一个学号
<span 17 <span     //判断两次密码是不是相同
<span 18     <span if(<span $spwd1==<span $spwd2<span )
<span 19 <span     {
<span 20         <span //<span SQL Server 对数据处理前的操作
<span 21 <span         sql();
<span 22         <span //<span SQL语句
<span 23         <span $sql="select * from [V3].[dbo].[V3_student]"<span ;
<span 24         <span $result = mssql_query(<span $sql<span );
<span 25         <span //<span 从结果集中取得一行作为关联数组
<span 26         <span while (<span $row = mssql_fetch_array(<span $result,<span  MSSQL_ASSOC))
<span 27 <span         {
<span 28             <span //<span 二次判断是否登录帐号重复
<span 29             <span if(<span $row['scount']==<span $scount<span )
<span 30 <span             {
<span 31                 <span //<span 报错并终止
<span 32                 <span echo ("已经有人申请了这个帐号！"<span );
<span 33                 <span exit<span ();        
<span 34 <span             }
<span 35 <span         }
<span 36         <span //<span SQL语句插入到视图里面
<span 37         <span $sql_add="<span INSERT INTO [V3].[dbo].[V3_student] ([sid],[sex],[sname],[school],[scount],[spwd]) 
<span 38                         VALUES (".<span $sid.",'".<span $sex."','".<span $sname."','".<span $school."','".<span $scount."','".<span $spwd1."')"<span ;
<span 39         <span $result_add = mssql_query(<span $sql_add<span );
<span 40         <span //<span 对SQL操作的结果的判断
<span 41         <span if(<span $result_add<span )
<span 42             {<span echo "
注册成功！
"<span ;}
<span 43         <span else 
<span 44             {<span echo "sql出错！"<span ;}
<span 45 <span     }
<span 46     <span else
<span 47 <span     {
<span 48         <span //<span 密码不相同报错并终止
<span 49         <span echo ("两次密码不对"<span );
<span 50         <span exit<span ();
<span 51 <span     }
<span 52 }

老师注册

<span  1 <span if(<span isset(<span $_POST['addadmin'<span ]))
<span  2 <span {
<span  3     <span //<span 判断是否有空，即没有输入的
<span  4     <span if((<span $_POST['name']=='')||(<span $_POST['sex']=='')||(<span $_POST['age']=='')||(<span $_POST['count']=='')||(<span $_POST['pwd']=='')||(<span $_POST['pwd2']=='')||(<span $_POST['ageage']=='')||(<span $_POST['tel']=='')||(<span $_POST['address']==''<span ))
<span  5 <span     {
<span  6         <span echo '请输全信息！'<span ;
<span  7         <span exit<span ();
<span  8 <span     }    
<span  9     <span //<span 把传递的数据赋值到变量里面
<span 10     <span $tname=<span $_POST['name'<span ];
<span 11     <span $tsex=<span $_POST['sex'<span ];
<span 12     <span $tage=<span $_POST['age'<span ];
<span 13     <span $tcount=<span $_POST['count'<span ];
<span 14     <span $tpwd=<span $_POST['pwd'<span ];
<span 15     <span $tpwd2=<span $_POST['pwd2'<span ];
<span 16     <span $age=<span $_POST['ageage'<span ];
<span 17     <span $tel=<span $_POST['tel'<span ];
<span 18     <span $address=<span $_POST['address'<span ];    
<span 19     <span $tsuper=1<span ;
<span 20     <span $tidid=<span rand(1,9999<span );
<span 21     <span //<span 判断两次密码是否相同
<span 22     <span if(<span $tpwd==<span $tpwd2<span )
<span 23 <span     {
<span 24         <span //<span SQL Server 对数据处理前的操作
<span 25 <span         sql();
<span 26         <span //<span SQL语句
<span 27         <span $sql="select * from [V3].[dbo].[teacher]"<span ;
<span 28         <span $result = mssql_query(<span $sql<span );
<span 29         <span //<span 从结果集中取得一行作为关联数组
<span 30         <span while (<span $row = mssql_fetch_array(<span $result,<span  MSSQL_ASSOC)) 
<span 31 <span         {
<span 32             <span //<span 二次判断是否登录帐号重复
<span 33             <span if(<span $row['tcount']==<span $tcount<span )
<span 34 <span             {
<span 35                 <span //<span 报错并终止
<span 36                 <span echo ("已经有人申请了这个帐号！"<span );
<span 37                 <span exit<span ();                
<span 38 <span             }
<span 39 <span         }
<span 40         <span $sql_add="EXEC [V3].[dbo].[V3_teacher] ".<span $tidid.",'".<span $tname."', '".<span $tage."', '".<span $tsex."', '".<span $tcount."', '".<span $tpwd."', '".<span $tsuper."','".<span $age."','".<span $tel."','".<span $address."'"<span ;
<span 41         <span $result_add = mssql_query(<span $sql_add<span );
<span 42         <span if(<span $result_add<span )
<span 43             {<span echo "
注册成功！
"<span ;}
<span 44         <span else 
<span 45             {<span echo "sql出错！"<span ;}    
<span 46 <span     }
<span 47     <span else
<span 48 <span     {
<span 49         <span //<span 报错并终止
<span 50         <span echo ("两次密码不对"<span );
<span 51         <span exit<span ();
<span 52 <span     }
<span 53 }

学生登录和查看资料

<span  1 <span //<span cookie传递id
<span  2     <span $sid=<span $_COOKIE['uid'<span ];
<span  3 <span     sql();
<span  4     <span //<span SQL 语句
<span  5     <span $query = "SELECT * FROM [V3].[dbo].[V3_student] where [sid]=".<span $sid.""<span ;
<span  6     <span $result = mssql_query(<span $query<span );
<span  7     <span //<span 取得这个表有多少列
<span  8     <span $db_t_num=mssql_num_fields(<span $result<span );
<span  9     <span //<span 保存字段中文含义
<span 10     <span $arrname[0]='学号'<span ;
<span 11     <span $arrname[1]='姓名'<span ;
<span 12     <span $arrname[2]='学院'<span ;
<span 13     <span $arrname[3]='帐号'<span ;
<span 14     <span $arrname[4]='密码'<span ;
<span 15     <span /*<span ******************
<span 16 <span             HTML表格
输出 n"<span ; <span 19 <span echo "tn"<span ; <span 20 <span for(<span $num=0;<span $num<<span $db_t_num;<span $num++<span ) <span 21 <span { <span 22 <span //<span 输出字段中文含义 <span 23 <span echo "tt".<span $arrname[<span $num]."n"<span ; <span 24 <span } <span 25 <span echo "tn"<span ; <span 26 <span while (<span $row = mssql_fetch_array(<span $result,<span MSSQL_ASSOC)) <span 27 <span { <span 28 <span //<span 输出内容 <span 29 <span echo "tn"<span ; <span 30 <span echo ''.<span $row["sid"].''<span ; <span 31 <span echo ''.<span $row["sname"].''<span ; <span 32 <span echo ''.<span $row["school"].''<span ; <span 33 <span echo ''.<span $row["scount"].''<span ; <span 34 <span echo '******';<span //<span 隐藏的写法 <span 35 <span echo "tn"<span ; <span 36 <span } <span 37 <span echo "n"学生选课 
<span  1 <span //<span GET得到是选课操作
<span  2 <span if(<span $_GET['action']=='do'<span )
<span  3 <span {
<span  4     <span //<span cookie传递sid
<span  5     <span $id=<span $_COOKIE["uid"<span ];
<span  6 <span     sql();
<span  7     <span //<span sid选了什么课，使check打上勾
<span  8     <span $sql_do="SELECT * FROM [V3].[dbo].[class] where [sid]=".<span $id.""<span ;
<span  9     <span $result_do = mssql_query(<span $sql_do<span );
<span 10     <span $ii=0;<span //<span 保存学生所选的课
<span 11     <span while (<span $row = mssql_fetch_array(<span $result_do,<span  MSSQL_ASSOC)) 
<span 12 <span     {
<span 13         <span $s_cid_do[<span $ii]=<span $row['cid'<span ];
<span 14         <span $ii++<span ;
<span 15 <span     }     
<span 16     
<span 17     <span //
<span 18     <span $sql_class="SELECT * FROM [V3].[dbo].[class] where [sid] = 0"<span ;
<span 19     <span $result_class = mssql_query(<span $sql_class<span );    
<span 20     <span $i=0;<span //<span 保存有多少行
<span 21     <span while (<span $row = mssql_fetch_array(<span $result_class,<span  MSSQL_ASSOC)) 
<span 22 <span     {
<span 23         <span $class_tid[<span $i]=<span $row['tid'<span ];
<span 24         <span $class_cid[<span $i]=<span $row['cid'<span ];
<span 25         <span $class_name[<span $i]=<span $row['cname'<span ];
<span 26         <span $i++<span ;
<span 27 <span     }
<span 28     <span //<span SQL语句通过tid取得老师名字，教学年龄和性别
<span 29     <span for(<span $a=0;<span $a<<span $i;<span $a++<span )
<span 30 <span     {
<span 31         <span $sql_t[<span $a]="SELECT * FROM [V3].[dbo].[teacher] where [tid]=".<span $class_tid[<span $a].""<span ;
<span 32         <span $result_t[<span $a]= mssql_query(<span $sql_t[<span $a<span ]);
<span 33         <span while (<span $class_t = mssql_fetch_array(<span $result_t[<span $a],<span  MSSQL_ASSOC)) 
<span 34 <span         {
<span 35             <span $class_tsex[<span $a]=<span $class_t['tsex'<span ];
<span 36             <span $class_tage[<span $a]=<span $class_t['tage'<span ];
<span 37             <span $class_tname[<span $a]=<span $class_t['tname'<span ];
<span 38 <span         }     
<span 39 <span     }
<span 40     <span //<span 保存字段中文含义
<span 41     <span $arrname[0]='课号'<span ;
<span 42     <span $arrname[1]='课名'<span ;
<span 43     <span $arrname[2]='老师名字'<span ;
<span 44     <span $arrname[3]='老师编号'<span ;
<span 45     <span $arrname[4]='老师教学年龄'<span ;
<span 46     <span $arrname[5]='老师性别'<span ;
<span 47     <span $arrname[6]='选课'<span ;
<span 48     <span /*<span ******************
<span 49 <span             HTML表格
输出

学生退课

<span  1 <span //<span GET传递操作，为退课操作
<span  2 <span if(<span $_GET['action']=='mine'<span )
<span  3 <span {
<span  4     <span //<span cookie传递sid
<span  5     <span $id=<span $_COOKIE["uid"<span ];
<span  6 <span     sql();
<span  7     <span //<span SQL语句通过学号sid取得课号cid和tid和课名
<span  8     <span $sql_s="SELECT * FROM [V3].[dbo].[class] where [sid]=".<span $id.""<span ;
<span  9     <span $result_s = mssql_query(<span $sql_s<span );
<span 10     <span $i=0;<span //<span 保存有多少行
<span 11     <span while (<span $row = mssql_fetch_array(<span $result_s,<span  MSSQL_ASSOC)) 
<span 12 <span     {
<span 13         <span $s_cid[<span $i]=<span $row['cid'<span ];
<span 14         <span $s_cname[<span $i]=<span $row['cname'<span ];
<span 15         <span $s_tid[<span $i]=<span $row['tid'<span ];
<span 16         <span $i++<span ;
<span 17 <span     }     
<span 18     <span //<span SQL语句通过tid得到上课的老师名字以及教学年龄和性别
<span 19     <span for(<span $a=0;<span $a<<span $i;<span $a++<span )
<span 20 <span     {
<span 21         <span $sql_s_t[<span $a]="SELECT * from [V3].[dbo].[teacher] where [tid]=".<span $s_tid[<span $a].""<span ;
<span 22         <span $result_s_t[<span $a] = mssql_query(<span $sql_s_t[<span $a<span ]);
<span 23         <span while (<span $s_t = mssql_fetch_array(<span $result_s_t[<span $a],<span  MSSQL_ASSOC)) 
<span 24 <span         {
<span 25             <span $s_tsex[<span $a]=<span $s_t['tsex'<span ];
<span 26             <span $s_tage[<span $a]=<span $s_t['tage'<span ];
<span 27             <span $s_tname[<span $a]=<span $s_t['tname'<span ];
<span 28 <span         }     
<span 29 <span     }
<span 30     <span //<span 保存字段中文含义
<span 31     <span $arrname[0]='课号'<span ;
<span 32     <span $arrname[1]='课名'<span ;
<span 33     <span $arrname[2]='老师名字'<span ;
<span 34     <span $arrname[3]='老师编号'<span ;
<span 35     <span $arrname[4]='老师教学年龄'<span ;
<span 36     <span $arrname[5]='老师性别'<span ;
<span 37     <span $arrname[6]='退课'<span ;
<span 38     <span /*<span ******************
<span 39 <span             HTML表格
输出 学生查看成绩 
<span  1 <span //<span 通过cookie得到sid
<span  2     <span $id=<span $_COOKIE['uid'<span ];
<span  3 <span     sql();
<span  4     <span //<span SQL语句通过学号sid取得课号cid和tid和课名
<span  5     <span $sql_s="SELECT * FROM [V3].[dbo].[class] where [sid]=".<span $id.""<span ;
<span  6     <span $result_s = mssql_query(<span $sql_s<span );
<span  7     <span $i=0;<span //<span 保存有多少行
<span  8     <span while (<span $row = mssql_fetch_array(<span $result_s,<span  MSSQL_ASSOC)) 
<span  9 <span     {
<span 10         <span $s_cid[<span $i]=<span $row['cid'<span ];
<span 11         <span $s_cname[<span $i]=<span $row['cname'<span ];
<span 12         <span $s_tid[<span $i]=<span $row['tid'<span ];
<span 13         <span $s_score[<span $i]=<span $row['score'<span ];        
<span 14         <span $i++<span ;
<span 15 <span     }
<span 16     <span //<span SQL语句通过tid得到上课的老师名字以及教学年龄和性别
<span 17     <span for(<span $a=0;<span $a<<span $i;<span $a++<span )
<span 18 <span     {
<span 19         <span $sql_s_t[<span $a]="SELECT * from [V3].[dbo].[teacher] where [tid]=".<span $s_tid[<span $a].""<span ;
<span 20         <span $result_s_t[<span $a] = mssql_query(<span $sql_s_t[<span $a<span ]);
<span 21         <span while (<span $s_t = mssql_fetch_array(<span $result_s_t[<span $a],<span  MSSQL_ASSOC)) 
<span 22 <span         {
<span 23             <span $s_tsex[<span $a]=<span $s_t['tsex'<span ];
<span 24             <span $s_tage[<span $a]=<span $s_t['tage'<span ];
<span 25             <span $s_tname[<span $a]=<span $s_t['tname'<span ];
<span 26 <span         }     
<span 27 <span     }
<span 28     <span //<span 保存字段中文含义
<span 29     <span $arrname[0]='课号'<span ;
<span 30     <span $arrname[1]='课名'<span ;
<span 31     <span $arrname[2]='老师名字'<span ;
<span 32     <span $arrname[3]='老师编号'<span ;
<span 33     <span $arrname[4]='老师教学年龄'<span ;
<span 34     <span $arrname[5]='老师性别'<span ;
<span 35     <span $arrname[6]='分数'<span ;     
<span 36         <span /*<span ******************
<span 37 <span             HTML表格
输出 n"<span ; <span 40 <span echo "t我选上的课n"<span ; <span 41 <span echo "tn"<span ; <span 42 <span echo "tn"<span ; <span 43 <span //<span 有7列 <span 44 <span for(<span $num=0;<span $num<7;<span $num++<span ) <span 45 <span { <span 46 <span echo "tt".<span $arrname[<span $num]."n"<span ; <span 47 <span } <span 48 <span echo "tn"<span ; <span 49 <span for(<span $a=0;<span $a<<span $i;<span $a++<span ) <span 50 <span { <span 51 <span if(<span $s_tsex[<span $a]=='0'<span ) <span 52 <span $s_tsex[<span $a]='男'<span ; <span 53 <span else <span 54 <span $s_tsex[<span $a]='女'<span ; <span 55 <span //<span 判断是否上成绩，若为999，则是没有上成绩 <span 56 <span if(<span $s_score[<span $a]=='999'<span ) <span 57 <span { <span 58 <span $s_score[<span $a]='未上成绩'<span ; <span 59 <span } <span 60 <span echo "tn"<span ; <span 61 <span echo ''.<span $s_cid[<span $a].''<span ; <span 62 <span echo ''.<span $s_cname[<span $a].''<span ; <span 63 <span echo ''.<span $s_tname[<span $a].''<span ; <span 64 <span echo ''.<span $s_tid[<span $a].''<span ; <span 65 <span echo ''.<span $s_tage[<span $a].''<span ; <span 66 <span echo ''.<span $s_tsex[<span $a].''<span ; <span 67 <span echo ''.<span $s_score[<span $a].''<span ; <span 68 <span 69 <span echo "tn"<span ; <span 70 <span } <span 71 <span echo "n";

老师登录和查看所有资料（权限限制）

<span  1 <span //<span GET传递信息，显示所以老师（权限限制）
<span  2 <span if(<span $_GET['people']=='all'<span )
<span  3 <span {
<span  4     <span if(<span $_COOKIE["super"]=='10'<span )
<span  5 <span     {
<span  6 <span         sql();
<span  7         <span //<span SQL 语句
<span  8         <span $query = "SELECT * FROM [V3].[dbo].[teacher]"<span ;
<span  9         <span $result = mssql_query(<span $query<span );
<span 10     
<span 11         <span /*<span ******************
<span 12 <span                 HTML表格
输出 n"<span ; <span 15 <span //<span 取得结果集中字段的数目 <span 16 <span $db_t_num=mssql_num_fields(<span $result<span ); <span 17 <span //<span 保存字段中文含义 <span 18 <span $arrname[0]='编号'<span ; <span 19 <span $arrname[1]='姓名'<span ; <span 20 <span $arrname[2]='教学年龄'<span ; <span 21 <span $arrname[3]='性别'<span ; <span 22 <span $arrname[4]='登录帐号'<span ; <span 23 <span $arrname[5]='登录密码'<span ; <span 24 <span $arrname[6]='管理权限'<span ; <span 25 <span 26 <span echo "tn"<span ; <span 27 <span for(<span $num=0;<span $num<<span $db_t_num;<span $num++<span ) <span 28 <span { <span 29 <span echo "tt".<span $arrname[<span $num]."n"<span ; <span 30 <span } <span 31 <span echo "tn"<span ; <span 32 <span //<span 从结果集中取得一行作为关联数组 <span 33 <span while (<span $row = mssql_fetch_array(<span $result,<span MSSQL_ASSOC)) <span 34 <span { <span 35 <span //<span 判断之后显示男女中文 <span 36 <span if(<span $row["tsex"]=='0'<span ) <span 37 <span $row["tsex"]='男'<span ; <span 38 <span else <span 39 <span $row["tsex"]='女'<span ; <span 40 <span //<span 判断是不是超级管理员 <span 41 <span if(<span $row["tsuper"]=='10'<span ) <span 42 <span $row["tsuper"]='超级老师管理员'<span ; <span 43 <span else <span 44 <span $row["tsuper"]='普通老师管理员'<span ; <span 45 <span 46 <span //<span 输出内容 <span 47 <span echo "tn"<span ; <span 48 <span echo ''.<span $row["tid"].''<span ; <span 49 <span echo ''.<span $row["tname"].''<span ; <span 50 <span echo ''.<span $row["tage"].''<span ; <span 51 <span echo ''.<span $row["tsex"].''<span ; <span 52 <span echo ''.<span $row["tcount"].''<span ; <span 53 <span echo '******';<span //<span 隐藏的写法 <span 54 <span echo ''.<span $row["tsuper"].''<span ; <span 55 <span echo "tn"<span ; <span 56 <span } <span 57 <span echo "n"老师查看资料 
<span  1 <span //<span GET传递信息，显示自己信息
<span  2 <span if(<span $_GET['people']=='me'<span )
<span  3 <span {
<span  4     <span //<span cookie传输tid
<span  5     <span $id=<span $_COOKIE["uid"<span ];
<span  6     <span //<span SQL 语句
<span  7     <span $query = "SELECT * FROM [V3].[dbo].[teacher] where tid=".<span $id.""<span ;
<span  8     <span $result = mssql_query(<span $query<span );
<span  9     <span /*<span ******************
<span 10 <span             HTML表格
输出 n"<span ; <span 13 <span //<span 取得结果集中字段的数目 <span 14 <span $db_t_num=mssql_num_fields(<span $result<span ); <span 15 <span //<span 保存字段中文含义 <span 16 <span $arrname[0]='编号'<span ; <span 17 <span $arrname[1]='姓名'<span ; <span 18 <span $arrname[2]='教学年龄'<span ; <span 19 <span $arrname[3]='性别'<span ; <span 20 <span $arrname[4]='登录帐号'<span ; <span 21 <span $arrname[5]='登录密码'<span ; <span 22 <span $arrname[6]='管理权限'<span ; <span 23 <span 24 <span echo "tn"<span ; <span 25 <span for(<span $num=0;<span $num<<span $db_t_num;<span $num++<span ) <span 26 <span { <span 27 <span echo "tt".<span $arrname[<span $num]."n"<span ; <span 28 <span } <span 29 <span echo "tn"<span ; <span 30 <span while (<span $row = mssql_fetch_array(<span $result,<span MSSQL_ASSOC)) <span 31 <span { <span 32 <span //<span 判断之后显示男女中文 <span 33 <span if(<span $row["tsex"]=='0'<span ) <span 34 <span $row["tsex"]='男'<span ; <span 35 <span else <span 36 <span $row["tsex"]='女'<span ; <span 37 <span //<span 判断是不是超级管理员 <span 38 <span if(<span $row["tsuper"]=='10'<span ) <span 39 <span $row["tsuper"]='超级老师管理员'<span ; <span 40 <span else <span 41 <span $row["tsuper"]='普通老师管理员'<span ; <span 42 <span 43 <span //<span 输出内容 <span 44 <span echo "tn"<span ; <span 45 <span echo ''.<span $row["tid"].''<span ; <span 46 <span echo ''.<span $row["tname"].''<span ; <span 47 <span echo ''.<span $row["tage"].''<span ; <span 48 <span echo ''.<span $row["tsex"].''<span ; <span 49 <span echo ''.<span $row["tcount"].''<span ; <span 50 <span echo '******';<span //<span 隐藏的写法 <span 51 <span echo ''.<span $row["tsuper"].''<span ; <span 52 <span echo "tn"<span ; <span 53 <span } <span 54 <span echo "n"老师添加老师（权限限制） 
<span  1 <span //<span POST传递信息
<span  2 <span if(<span isset(<span $_POST['addsub'<span ]))
<span  3 <span {
<span  4     <span //<span 把传递的信息传到变量里面
<span  5     <span $tname=<span $_POST['name'<span ];
<span  6     <span $tsex=<span $_POST['sex'<span ];
<span  7     <span $tage=<span $_POST['age'<span ];
<span  8     <span $tcount=<span $_POST['count'<span ];
<span  9     <span $tpwd=<span $_POST['pwd'<span ];
<span 10     <span $tpwd2=<span $_POST['pwd2'<span ];
<span 11     <span $tsuper=<span $_POST['super'<span ];
<span 12     <span $tidid=<span $_POST['idid'<span ];
<span 13     <span $age=<span $_POST['ageage'<span ];
<span 14     <span $tel=<span $_POST['tel'<span ];
<span 15     <span $address=<span $_POST['address'<span ];        
<span 16     <span //<span 判断两次密码是否相同
<span 17     <span if(<span $tpwd==<span $tpwd2<span )
<span 18 <span     {
<span 19 <span         sql();
<span 20         <span //<span SQL语句
<span 21         <span $sql="select * from [V3].[dbo].[teacher]"<span ;
<span 22         <span $result = mssql_query(<span $sql<span );
<span 23         <span //<span 从结果集中取得一行作为关联数组
<span 24         <span while (<span $row = mssql_fetch_array(<span $result,<span  MSSQL_ASSOC)) 
<span 25 <span         {
<span 26             <span //<span 二次判断是否登录帐号重复
<span 27             <span if(<span $row['tcount']==<span $tcount<span )
<span 28 <span             {
<span 29                 <span //<span 报错并终止
<span 30                 <span echo ("已经有人申请了这个帐号！"<span );
<span 31                 <span exit<span ();                
<span 32 <span             }
<span 33 <span         }
<span 34         <span //<span 执行SQL语句插入
<span 35         <span $sql_add="EXEC [V3].[dbo].[V3_teacher] ".<span $tidid.",'".<span $tname."', '".<span $tage."', '".<span $tsex."', '".<span $tcount."', '".<span $tpwd."', '".<span $tsuper."','".<span $age."','".<span $tel."','".<span $address."'"<span ;
<span 36         <span $result_add = mssql_query(<span $sql_add<span );
<span 37         <span if(<span $result_add<span )
<span 38             {<span echo "添加成功！"<span ;}
<span 39         <span else 
<span 40             {<span echo "sql出错！"<span ;}    
<span 41 <span     }
<span 42     <span else
<span 43 <span     {
<span 44         <span //<span 报错并终止
<span 45         <span echo ("两次密码不对"<span );
<span 46         <span exit<span ();
<span 47 <span     }
<span 48 }

老师删减老师（权限限制）

<span  1 <span //<span POST传递信息
<span  2 <span if(<span isset(<span $_POST['delsub'<span ]))
<span  3 <span {
<span  4 <span     sql();
<span  5     <span $tid=<span $_POST['id'<span ];
<span  6     <span $sql="DELETE FROM [V3].[dbo].[teacher] where [tid]=".<span $tid.""<span ;
<span  7     <span $result = mssql_query(<span $sql<span );
<span  8     <span if(<span $result<span )
<span  9         {<span echo "删除成功"<span ;}
<span 10     <span else
<span 11         {<span echo "SQL出错！"<span ;}
<span 12 }

老师添加课程

<span  1 <span //<span POST传递信息
<span  2 <span if(<span isset(<span $_POST['addclass'<span ]))
<span  3 <span {
<span  4 <span     sql();
<span  5     <span //<span POST传递信息
<span  6     <span $tid=<span $_POST['id'<span ];
<span  7     <span $cname=<span $_POST['name'<span ];
<span  8     <span //<span SQL语句插入
<span  9     <span $sql="INSERT INTO [V3].[dbo].[class] ([sid], [tid], [cname],[score],[cid]) VALUES (0, ".<span $tid.", '".<span $cname."',999,".<span rand(1,999).")"<span ;
<span 10     <span $result = mssql_query(<span $sql<span );
<span 11     <span if(<span $result<span )
<span 12         {<span echo "创建课程成功"<span ;}
<span 13     <span else
<span 14         {<span echo "SQL出错！"<span ;}
<span 15 }

老师查看选课情况

<span  1 <span if(<span $_GET['action']=='list'<span )
<span  2 <span {
<span  3     <span //<span cookie传递tid
<span  4     <span $id=<span $_COOKIE["uid"<span ];
<span  5 <span     sql();
<span  6     <span //
<span  7     <span $sql_class="SELECT * FROM [V3].[dbo].[class] where [tid]=".<span $id." AND [sid] = 0"<span ;
<span  8     <span $result_class = mssql_query(<span $sql_class<span );    
<span  9     <span $i=0;<span //<span 保存有多少行
<span 10     <span while (<span $row = mssql_fetch_array(<span $result_class,<span  MSSQL_ASSOC)) 
<span 11 <span     {
<span 12         <span $class_id[<span $i]=<span $row['cid'<span ];
<span 13         <span $class_name[<span $i]=<span $row['cname'<span ];
<span 14         <span $i++<span ;
<span 15 <span     }
<span 16     <span //<span SQL语句通过tid和cid得到有多少学生选课
<span 17     <span for(<span $a=0;<span $a<<span $i;<span $a++<span )
<span 18 <span     {
<span 19         <span $sql_num[<span $a]="SELECT * FROM [V3].[dbo].[class] where [tid]=".<span $id." AND [cid] = ".<span $class_id[<span $a].""<span ;
<span 20         <span $result_num[<span $a]= mssql_query(<span $sql_num[<span $a<span ]);
<span 21         <span $class_num[<span $a]=mssql_num_rows(<span $result_num[<span $a<span ]);
<span 22 <span     }
<span 23     <span //<span 保存字段中文含义
<span 24     <span $arrname[0]='课号'<span ;
<span 25     <span $arrname[1]='课名'<span ;
<span 26     <span $arrname[2]='选课人数'<span ;
<span 27         <span /*<span ******************
<span 28 <span                 HTML表格
输出 n"<span ; <span 31 <span echo "t老师号：".<span $id."n"<span ; <span 32 <span echo "tn"<span ; <span 33 <span //<span 有3列 <span 34 <span for(<span $num=0;<span $num<3;<span $num++<span ) <span 35 <span { <span 36 <span echo "tt".<span $arrname[<span $num]."n"<span ; <span 37 <span } <span 38 <span echo "tn"<span ; <span 39 <span for(<span $a=0;<span $a<<span $i;<span $a++<span ) <span 40 <span { <span 41 <span //<span 删去sid为0的 <span 42 <span $class_num[<span $a]=<span $class_num[<span $a]-1<span ; <span 43 <span echo "tn"<span ; <span 44 <span echo ''.<span $class_id[<span $a].''<span ; <span 45 <span echo ''.<span $class_name[<span $a].''<span ; <span 46 <span echo ''.<span $class_num[<span $a].''<span ; <span 47 <span echo "tn"<span ; <span 48 <span } <span 49 <span echo "n"

老师删减课程

<span  1 <span //<span POST传递信息
<span  2 <span if(<span isset(<span $_POST['delclass'<span ]))
<span  3 <span {
<span  4 <span     sql();
<span  5     <span //<span POST传递信息
<span  6     <span $cid=<span $_POST['cid'<span ];
<span  7     <span //<span SQL进行删减操作
<span  8     <span $sql="DELETE FROM [V3].[dbo].[class] where [cid]=".<span $cid.""<span ;
<span  9     <span $result = mssql_query(<span $sql<span );
<span 10     <span if(<span $result<span )
<span 11         {<span echo "删除课程成功"<span ;}
<span 12     <span else
<span 13         {<span echo "SQL出错！";}

老师查看成绩

<span  1 <span //<span GET传递信息
<span  2 <span if(<span $_GET['action']=='show'<span )
<span  3 <span {
<span  4 <span     sql();
<span  5     <span //<span cookie传输tid
<span  6     <span $id=<span $_COOKIE["uid"<span ];
<span  7     <span //<span SQL语句通过tid取得课号cid
<span  8     <span $sql_t="SELECT * FROM [V3].[dbo].[class] where [sid]=0 AND [tid] = ".<span $id.""<span ;
<span  9     <span $result_t = mssql_query(<span $sql_t<span );
<span 10     <span $i=0;<span //<span 保存老师有多少课程
<span 11     <span while (<span $row = mssql_fetch_array(<span $result_t,<span  MSSQL_ASSOC)) 
<span 12 <span     {
<span 13         <span $t_cid[<span $i]=<span $row['cid'<span ];
<span 14         <span $t_cname[<span $i]=<span $row['cname'<span ];    
<span 15         <span $i++<span ;
<span 16 <span     }
<span 17     <span //<span 将cid,sid,score存入数组
<span 18     <span for(<span $a=0;<span $a<<span $i;<span $a++<span )
<span 19 <span     {
<span 20         <span //<span 通过cid找到选课了的学生
<span 21         <span $sql_t_s="SELECT * FROM [V3].[dbo].[class] where [cid]=".<span $t_cid[<span $a]." AND [tid] = ".<span $id.""<span ;
<span 22         <span $result_t_s = mssql_query(<span $sql_t_s<span );
<span 23         <span $ii=0;<span //<span 保存每个课程的学生人数
<span 24         <span while(<span $row_ready = mssql_fetch_array(<span $result_t_s,<span  MSSQL_ASSOC))
<span 25 <span         {
<span 26             <span $t_sid[<span $a][<span $ii]=<span $row_ready['sid'<span ];
<span 27             <span $t_score[<span $a][<span $ii]=<span $row_ready['score'<span ];
<span 28             <span $ii++<span ;
<span 29 <span         }
<span 30         <span $num[<span $a]=<span $ii;<span //<span 把每个课程的人数存到数组里面
<span 31 <span     }
<span 32     <span //<span 通过sid找到sname
<span 33     <span for(<span $b=0;<span $b<<span $i;<span $b++<span )
<span 34 <span     {
<span 35         <span for(<span $c=0;<span $c<<span $num[<span $b];<span $c++<span )
<span 36 <span         {
<span 37             <span //<span 通过cid找到选课了的学生
<span 38             <span $sql_sn="SELECT * FROM [V3].[dbo].[V3_student] where [sid]=".<span $t_sid[<span $b][<span $c].""<span ;
<span 39             <span $result_sn = mssql_query(<span $sql_sn<span );
<span 40             <span while(<span $row_sn = mssql_fetch_array(<span $result_sn,<span  MSSQL_ASSOC))
<span 41 <span             {
<span 42                 <span $t_sname[<span $b][<span $c]=<span $row_sn['sname'<span ];
<span 43 <span             }
<span 44 <span         }
<span 45 <span     }    
<span 46     <span //<span 列出老师的课程
<span 47     <span if(<span $_GET['cid']=='0'<span )
<span 48 <span     {
<span 49         <span for(<span $dd=0;<span $dd<<span $i;<span $dd++<span )
<span 50 <span         { 
<span 51                     <span echo "[<span $dd]."'>查看__".<span $t_cname[<span $dd]."__课程情况!
"<span ;        
<span 52 <span         }
<span 53 <span     }
<span 54     <span for(<span $ddd=0;<span $ddd<<span $i;<span $ddd++<span )
<span 55 <span     {
<span 56         <span if(<span $_GET['cid']==<span $t_cid[<span $ddd<span ])
<span 57 <span         {
<span 58             <span //<span 保存字段中文含义
<span 59             <span $arrname[0]='课号'<span ;
<span 60             <span $arrname[1]='课名'<span ;
<span 61             <span $arrname[2]='学生号'<span ;
<span 62             <span $arrname[3]='学生名'<span ;
<span 63             <span $arrname[4]='成绩'<span ;
<span 64             <span /*<span ******************
<span 65 <span                     HTML表格
输出 n"<span ; <span 68 <span echo "tn"<span ; <span 69 <span //<span 5列 <span 70 <span for(<span $num5=0;<span $num5<5;<span $num5++<span ) <span 71 <span { <span 72 <span echo "tt".<span $arrname[<span $num5]."n"<span ; <span 73 <span } <span 74 <span echo "tn"<span ; <span 75 <span 76 <span for(<span $e=0;<span $e < <span $num[ <span $ddd ];<span $e++<span ) <span 77 <span { <span 78 <span if(<span $t_score[<span $ddd][<span $e]=="999"<span ) <span 79 <span { <span 80 <span $t_score[<span $ddd][<span $e]="未上传成绩"<span ; <span 81 <span } <span 82 <span if(<span $t_sid[<span $ddd][<span $e]=='0'<span ) <span 83 <span { <span 84 <span //<span 不显示默认为0的学生 <span 85 <span continue<span ; <span 86 <span } <span 87 <span //<span 输出内容 <span 88 <span echo "tn"<span ; <span 89 <span echo ''.<span $t_cid[<span $ddd].''<span ; <span 90 <span echo ''.<span $t_cname[<span $ddd].''<span ; <span 91 <span echo ''.<span $t_sid[<span $ddd][<span $e].''<span ; <span 92 <span echo ''.<span $t_sname[<span $ddd][<span $e].''<span ; <span 93 <span echo ''.<span $t_score[<span $ddd][<span $e].''<span ; <span 94 <span echo "tn"<span ; <span 95 <span } <span 96 <span echo "n"老师上传成绩 
<span  1 <span if(<span isset(<span $_POST['up'<span ]))
<span  2 <span {
<span  3 <span     sql();
<span  4     <span //<span cookie传输tid
<span  5     <span $id=<span $_COOKIE["uid"<span ];
<span  6     <span //<span POST传输得到cid
<span  7     <span $up_cid=<span $_POST['cid'<span ];
<span  8     <span //<span 通过cid和tid找到选课了的学生
<span  9     <span $sql_s="SELECT * FROM [V3].[dbo].[class] where [cid]=".<span $up_cid." AND [tid] = ".<span $id.""<span ;
<span 10     <span $result_s = mssql_query(<span $sql_s<span );
<span 11     <span $i=0;<span //<span 保存有多少学生
<span 12     <span while (<span $row = mssql_fetch_array(<span $result_s,<span  MSSQL_ASSOC)) 
<span 13 <span     {
<span 14         <span $up_score[<span $i]=<span $row['score'<span ];
<span 15         <span $up_sid[<span $i]=<span $row['sid'<span ];    
<span 16         <span $i++<span ;
<span 17 <span     }
<span 18     <span for(<span $a=0;<span $a<<span $i;<span $a++<span )
<span 19 <span     {
<span 20         <span if(<span $up_sid[<span $a]=='0'<span )
<span 21 <span         {
<span 22             <span //<span 忽略默认sid为0的学生
<span 23             <span continue<span ;
<span 24 <span         }
<span 25         <span //<span 判断是不是数字
<span 26         <span if(<span is_numeric(<span $_POST["sid_<span $up_sid[<span $a]"<span ]))
<span 27 <span         {
<span 28             <span //<span 判断是否在0~100之内
<span 29             <span if(<span $_POST["sid_<span $up_sid[<span $a]"]<=100&&<span $_PO

【说明】：本文章由站长整理发布，文章内容不代表本站观点，如文中有侵权行为，请与本站客服联系(QQ:254677821)！

相关教程推荐

其他课程推荐