基于SqlServer2008的分布式数据库的实践（五）_PHP教程
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了基于SqlServer2008的分布式数据库的实践（五）_PHP教程，小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含35921字，纯文字阅读大概需要52分钟。
内容图文
程序设计
-----------------------------------------------------------------------------------------------------------------
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 "\t
<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老师登录和查看所有资料（权限限制）
<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 "\t<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 "\t<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 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 "\t<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
内容总结
以上是互联网集市为您收集整理的基于SqlServer2008的分布式数据库的实践（五）_PHP教程全部内容，希望文章能够帮你解决基于SqlServer2008的分布式数据库的实践（五）_PHP教程所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错，欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明：本文内容由互联网用户自发贡献，该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 gblab@vip.qq.com 举报，一经查实，本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。
来源：【匿名】