搜索
首页后端开发php教程基于Sql Server 2008的分布式数据库的实践（五）_PHP教程

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

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
Jul 13, 2016 pm 05:16 PM
serversql分布式基于实践数据库的程序设计

程序设计

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

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

程序解释

学生注册

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

 

老师注册

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

学生登录和查看资料

<span  1</span> <span //</span><span cookie传递id</span>
<span  2</span>     <span $sid</span>=<span $_COOKIE</span>['uid'<span ];
</span><span  3</span> <span     sql();
</span><span  4</span>     <span //</span><span SQL 语句</span>
<span  5</span>     <span $query</span> = "SELECT * FROM [V3].[dbo].[V3_student] where [sid]=".<span $sid</span>.""<span ;
</span><span  6</span>     <span $result</span> = mssql_query(<span $query</span><span );
</span><span  7</span>     <span //</span><span 取得这个表有多少列</span>
<span  8</span>     <span $db_t_num</span>=mssql_num_fields(<span $result</span><span );
</span><span  9</span>     <span //</span><span 保存字段中文含义</span>
<span 10</span>     <span $arrname</span>[0]='学号'<span ;
</span><span 11</span>     <span $arrname</span>[1]='姓名'<span ;
</span><span 12</span>     <span $arrname</span>[2]='学院'<span ;
</span><span 13</span>     <span $arrname</span>[3]='帐号'<span ;
</span><span 14</span>     <span $arrname</span>[4]='密码'<span ;
</span><span 15</span>     <span /*</span><span ******************
</span><span 16</span> <span             HTML表格输出
</span><span 17</span> <span     ******************</span><span */</span>
<span 18</span>     <span echo</span> "<table border='1' >\n"<span ;
</span><span 19</span>     <span echo</span> "\t<tr>\n"<span ;
</span><span 20</span>     <span for</span>(<span $num</span>=0;<span $num</span><<span $db_t_num</span>;<span $num</span>++<span )
</span><span 21</span> <span     {
</span><span 22</span>         <span //</span><span 输出字段中文含义</span>
<span 23</span>         <span echo</span> "\t\t<td>".<span $arrname</span>[<span $num</span>]."</td>\n"<span ;
</span><span 24</span> <span     }
</span><span 25</span>     <span echo</span> "\t</tr>\n"<span ;
</span><span 26</span>     <span while</span> (<span $row</span> = mssql_fetch_array(<span $result</span>,<span  MSSQL_ASSOC)) 
</span><span 27</span> <span     { 
</span><span 28</span>         <span //</span><span 输出内容</span>
<span 29</span>       <span echo</span> "\t<tr>\n"<span ;
</span><span 30</span>             <span echo</span> '<td>'.<span $row</span>["sid"].'</td>'<span ;
</span><span 31</span>             <span echo</span> '<td>'.<span $row</span>["sname"].'</td>'<span ;
</span><span 32</span>             <span echo</span> '<td>'.<span $row</span>["school"].'</td>'<span ;
</span><span 33</span>             <span echo</span> '<td>'.<span $row</span>["scount"].'</td>'<span ;
</span><span 34</span>             <span echo</span> '<td>******</td>';<span //</span><span 隐藏的写法</span>
<span 35</span>         <span echo</span> "\t</tr>\n"<span ;
</span><span 36</span> <span     }
</span><span 37</span>     <span echo</span> "</table>\n"<span ;    
</span><span 38</span>     <span //</span><span 释放SQL链接</span>
<span 39</span>     mssql_free_result(<span $result</span>);

学生选课

<span  1</span> <span //</span><span GET得到是选课操作</span>
<span  2</span> <span if</span>(<span $_GET</span>['action']=='do'<span )
</span><span  3</span> <span {
</span><span  4</span>     <span //</span><span cookie传递sid</span>
<span  5</span>     <span $id</span>=<span $_COOKIE</span>["uid"<span ];
</span><span  6</span> <span     sql();
</span><span  7</span>     <span //</span><span sid选了什么课，使check打上勾</span>
<span  8</span>     <span $sql_do</span>="SELECT * FROM [V3].[dbo].[class] where [sid]=".<span $id</span>.""<span ;
</span><span  9</span>     <span $result_do</span> = mssql_query(<span $sql_do</span><span );
</span><span 10</span>     <span $ii</span>=0;<span //</span><span 保存学生所选的课</span>
<span 11</span>     <span while</span> (<span $row</span> = mssql_fetch_array(<span $result_do</span>,<span  MSSQL_ASSOC)) 
</span><span 12</span> <span     {
</span><span 13</span>         <span $s_cid_do</span>[<span $ii</span>]=<span $row</span>['cid'<span ];
</span><span 14</span>         <span $ii</span>++<span ;
</span><span 15</span> <span     }     
</span><span 16</span>     
<span 17</span>     <span //</span><span SQL语句通过默认学生sid=0取得课名cname和课号cid和老师tid</span>
<span 18</span>     <span $sql_class</span>="SELECT * FROM [V3].[dbo].[class] where [sid] = 0"<span ;
</span><span 19</span>     <span $result_class</span> = mssql_query(<span $sql_class</span><span );    
</span><span 20</span>     <span $i</span>=0;<span //</span><span 保存有多少行</span>
<span 21</span>     <span while</span> (<span $row</span> = mssql_fetch_array(<span $result_class</span>,<span  MSSQL_ASSOC)) 
</span><span 22</span> <span     {
</span><span 23</span>         <span $class_tid</span>[<span $i</span>]=<span $row</span>['tid'<span ];
</span><span 24</span>         <span $class_cid</span>[<span $i</span>]=<span $row</span>['cid'<span ];
</span><span 25</span>         <span $class_name</span>[<span $i</span>]=<span $row</span>['cname'<span ];
</span><span 26</span>         <span $i</span>++<span ;
</span><span 27</span> <span     }
</span><span 28</span>     <span //</span><span SQL语句通过tid取得老师名字，教学年龄和性别</span>
<span 29</span>     <span for</span>(<span $a</span>=0;<span $a</span><<span $i</span>;<span $a</span>++<span )
</span><span 30</span> <span     {
</span><span 31</span>         <span $sql_t</span>[<span $a</span>]="SELECT * FROM [V3].[dbo].[teacher] where [tid]=".<span $class_tid</span>[<span $a</span>].""<span ;
</span><span 32</span>         <span $result_t</span>[<span $a</span>]= mssql_query(<span $sql_t</span>[<span $a</span><span ]);
</span><span 33</span>         <span while</span> (<span $class_t</span> = mssql_fetch_array(<span $result_t</span>[<span $a</span>],<span  MSSQL_ASSOC)) 
</span><span 34</span> <span         {
</span><span 35</span>             <span $class_tsex</span>[<span $a</span>]=<span $class_t</span>['tsex'<span ];
</span><span 36</span>             <span $class_tage</span>[<span $a</span>]=<span $class_t</span>['tage'<span ];
</span><span 37</span>             <span $class_tname</span>[<span $a</span>]=<span $class_t</span>['tname'<span ];
</span><span 38</span> <span         }     
</span><span 39</span> <span     }
</span><span 40</span>     <span //</span><span 保存字段中文含义</span>
<span 41</span>     <span $arrname</span>[0]='课号'<span ;
</span><span 42</span>     <span $arrname</span>[1]='课名'<span ;
</span><span 43</span>     <span $arrname</span>[2]='老师名字'<span ;
</span><span 44</span>     <span $arrname</span>[3]='老师编号'<span ;
</span><span 45</span>     <span $arrname</span>[4]='老师教学年龄'<span ;
</span><span 46</span>     <span $arrname</span>[5]='老师性别'<span ;
</span><span 47</span>     <span $arrname</span>[6]='选课'<span ;
</span><span 48</span>     <span /*</span><span ******************
</span><span 49</span> <span             HTML表格输出
</span><span 50</span> <span     ******************</span><span */</span>
<span 51</span>     <span echo</span> '<form action="up.php" method="POST">'<span ;
</span><span 52</span>     <span echo</span> "<table border='1' >\n"<span ;
</span><span 53</span>     <span echo</span> "\t<tr><td colspan='7' align='center'>选课系统</td></tr>\n"<span ;
</span><span 54</span>     <span echo</span> "\t<tr>\n"<span ;
</span><span 55</span>     <span echo</span> "\t<tr>\n"<span ;
</span><span 56</span>     <span //</span><span 有6列</span>
<span 57</span>     <span for</span>(<span $num</span>=0;<span $num</span><7;<span $num</span>++<span )
</span><span 58</span> <span     {
</span><span 59</span>         <span echo</span> "\t\t<td>".<span $arrname</span>[<span $num</span>]."</td>\n"<span ;
</span><span 60</span> <span     }
</span><span 61</span>     <span for</span>(<span $a</span>=0;<span $a</span><<span $i</span>;<span $a</span>++<span )
</span><span 62</span> <span     {
</span><span 63</span>         <span //</span><span check初始化</span>
<span 64</span>         <span $check</span> = ''<span ;
</span><span 65</span>         <span //</span><span 判断是男是女</span>
<span 66</span>         <span if</span>(<span $class_tsex</span>[<span $a</span>]=='0'<span )
</span><span 67</span>                 <span $class_tsex</span>[<span $a</span>]='男'<span ;
</span><span 68</span>         <span else</span>
<span 69</span>                 <span $class_tsex</span>[<span $a</span>]='女'<span ;
</span><span 70</span>         <span //</span><span 判断选了这门课</span>
<span 71</span>         <span for</span>(<span $b</span>=0;<span $b</span><<span $ii</span>;<span $b</span>++<span )
</span><span 72</span> <span         {
</span><span 73</span>             <span if</span>(<span $class_cid</span>[<span $a</span>]==<span $s_cid_do</span>[<span $b</span><span ])
</span><span 74</span> <span             {
</span><span 75</span>                 <span $check</span> = 'checked'<span ;
</span><span 76</span> <span             }
</span><span 77</span> <span         }
</span><span 78</span>         <span echo</span> "\t<tr>\n"<span ;
</span><span 79</span>             <span echo</span> '<td>'.<span $class_cid</span>[<span $a</span>].'</td>'<span ;
</span><span 80</span>             <span echo</span> '<td>'.<span $class_name</span>[<span $a</span>].'</td>'<span ;
</span><span 81</span>             <span echo</span> '<td>'.<span $class_tname</span>[<span $a</span>].'</td>'<span ;
</span><span 82</span>             <span echo</span> '<td>'.<span $class_tid</span>[<span $a</span>].'</td>'<span ;
</span><span 83</span>             <span echo</span> '<td>'.<span $class_tage</span>[<span $a</span>].'</td>'<span ;
</span><span 84</span>             <span echo</span> '<td>'.<span $class_tsex</span>[<span $a</span>].'</td>'<span ;
</span><span 85</span>             <span echo</span> '<td><input type="checkbox" name=pa_'.<span $class_cid</span>[<span $a</span>].' '.<span $check</span>.'></td>';<span //</span><span name=pa_'.$class_cid[$a]这样写是为了出现BUG</span>
<span 86</span>         <span echo</span> "\t</tr>\n"<span ;
</span><span 87</span> <span     }
</span><span 88</span>     <span echo</span> "\t<tr><td colspan='7' align='center'><input type='submit' name='sub' value='确认课程'></td></tr>\n"<span ;
</span><span 89</span>     <span echo</span> "</table>\n"<span ;
</span><span 90</span>     <span echo</span> "</form>"<span ;
</span><span 91</span> }

 

学生退课

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

学生查看成绩

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

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

<span  1</span> <span //</span><span GET传递信息，显示所以老师（权限限制）</span>
<span  2</span> <span if</span>(<span $_GET</span>['people']=='all'<span )
</span><span  3</span> <span {
</span><span  4</span>     <span if</span>(<span $_COOKIE</span>["super"]=='10'<span )
</span><span  5</span> <span     {
</span><span  6</span> <span         sql();
</span><span  7</span>         <span //</span><span SQL 语句</span>
<span  8</span>         <span $query</span> = "SELECT * FROM [V3].[dbo].[teacher]"<span ;
</span><span  9</span>         <span $result</span> = mssql_query(<span $query</span><span );
</span><span 10</span>     
<span 11</span>         <span /*</span><span ******************
</span><span 12</span> <span                 HTML表格输出
</span><span 13</span> <span         ******************</span><span */</span>
<span 14</span>         <span echo</span> "<table border='1' >\n"<span ;
</span><span 15</span>         <span //</span><span 取得结果集中字段的数目</span>
<span 16</span>         <span $db_t_num</span>=mssql_num_fields(<span $result</span><span );
</span><span 17</span>         <span //</span><span 保存字段中文含义</span>
<span 18</span>         <span $arrname</span>[0]='编号'<span ;
</span><span 19</span>         <span $arrname</span>[1]='姓名'<span ;
</span><span 20</span>         <span $arrname</span>[2]='教学年龄'<span ;
</span><span 21</span>         <span $arrname</span>[3]='性别'<span ;
</span><span 22</span>         <span $arrname</span>[4]='登录帐号'<span ;
</span><span 23</span>         <span $arrname</span>[5]='登录密码'<span ;
</span><span 24</span>         <span $arrname</span>[6]='管理权限'<span ;
</span><span 25</span>         
<span 26</span>         <span echo</span> "\t<tr>\n"<span ;
</span><span 27</span>         <span for</span>(<span $num</span>=0;<span $num</span><<span $db_t_num</span>;<span $num</span>++<span )
</span><span 28</span> <span         {
</span><span 29</span>             <span echo</span> "\t\t<td>".<span $arrname</span>[<span $num</span>]."</td>\n"<span ;
</span><span 30</span> <span         }
</span><span 31</span>         <span echo</span> "\t</tr>\n"<span ;
</span><span 32</span>         <span //</span><span 从结果集中取得一行作为关联数组</span>
<span 33</span>         <span while</span> (<span $row</span> = mssql_fetch_array(<span $result</span>,<span  MSSQL_ASSOC)) 
</span><span 34</span> <span         { 
</span><span 35</span>             <span //</span><span 判断之后显示男女中文</span>
<span 36</span>             <span if</span>(<span $row</span>["tsex"]=='0'<span )
</span><span 37</span>                 <span $row</span>["tsex"]='男'<span ;
</span><span 38</span>             <span else</span>
<span 39</span>                 <span $row</span>["tsex"]='女'<span ;
</span><span 40</span>             <span //</span><span 判断是不是超级管理员</span>
<span 41</span>             <span if</span>(<span $row</span>["tsuper"]=='10'<span )
</span><span 42</span>                 <span $row</span>["tsuper"]='超级老师管理员'<span ;
</span><span 43</span>             <span else</span>
<span 44</span>                 <span $row</span>["tsuper"]='普通老师管理员'<span ;
</span><span 45</span>             
<span 46</span>                 <span //</span><span 输出内容</span>
<span 47</span>             <span echo</span> "\t<tr>\n"<span ;
</span><span 48</span>                     <span echo</span> '<td>'.<span $row</span>["tid"].'</td>'<span ;
</span><span 49</span>                     <span echo</span> '<td>'.<span $row</span>["tname"].'</td>'<span ;
</span><span 50</span>                     <span echo</span> '<td>'.<span $row</span>["tage"].'</td>'<span ;
</span><span 51</span>                     <span echo</span> '<td>'.<span $row</span>["tsex"].'</td>'<span ;
</span><span 52</span>                     <span echo</span> '<td>'.<span $row</span>["tcount"].'</td>'<span ;
</span><span 53</span>                     <span echo</span> '<td>******</td>';<span //</span><span 隐藏的写法</span>
<span 54</span>                     <span echo</span> '<td>'.<span $row</span>["tsuper"].'</td>'<span ;
</span><span 55</span>             <span echo</span> "\t</tr>\n"<span ;
</span><span 56</span> <span         }    
</span><span 57</span>         <span echo</span> "</table>\n"<span ;
</span><span 58</span>         
<span 59</span>         <span //</span><span 释放SQL链接</span>
<span 60</span>         mssql_free_result(<span $result</span><span );
</span><span 61</span> <span     }
</span><span 62</span>     <span else</span>
<span 63</span> <span     {
</span><span 64</span>         <span echo</span> "没有权限查看！"<span ;
</span><span 65</span> <span     }
</span><span 66</span> }

老师查看资料

<span  1</span> <span //</span><span GET传递信息，显示自己信息</span>
<span  2</span> <span if</span>(<span $_GET</span>['people']=='me'<span )
</span><span  3</span> <span {
</span><span  4</span>     <span //</span><span cookie传输tid</span>
<span  5</span>     <span $id</span>=<span $_COOKIE</span>["uid"<span ];
</span><span  6</span>     <span //</span><span SQL 语句</span>
<span  7</span>     <span $query</span> = "SELECT * FROM [V3].[dbo].[teacher] where tid=".<span $id</span>.""<span ;
</span><span  8</span>     <span $result</span> = mssql_query(<span $query</span><span );
</span><span  9</span>     <span /*</span><span ******************
</span><span 10</span> <span             HTML表格输出
</span><span 11</span> <span     ******************</span><span */</span>
<span 12</span>     <span echo</span> "<table border='1' >\n"<span ;
</span><span 13</span>     <span //</span><span 取得结果集中字段的数目</span>
<span 14</span>     <span $db_t_num</span>=mssql_num_fields(<span $result</span><span );
</span><span 15</span>     <span //</span><span 保存字段中文含义</span>
<span 16</span>     <span $arrname</span>[0]='编号'<span ;
</span><span 17</span>     <span $arrname</span>[1]='姓名'<span ;
</span><span 18</span>     <span $arrname</span>[2]='教学年龄'<span ;
</span><span 19</span>     <span $arrname</span>[3]='性别'<span ;
</span><span 20</span>     <span $arrname</span>[4]='登录帐号'<span ;
</span><span 21</span>     <span $arrname</span>[5]='登录密码'<span ;
</span><span 22</span>     <span $arrname</span>[6]='管理权限'<span ;
</span><span 23</span>     
<span 24</span>     <span echo</span> "\t<tr>\n"<span ;
</span><span 25</span>     <span for</span>(<span $num</span>=0;<span $num</span><<span $db_t_num</span>;<span $num</span>++<span )
</span><span 26</span> <span     {
</span><span 27</span>         <span echo</span> "\t\t<td>".<span $arrname</span>[<span $num</span>]."</td>\n"<span ;
</span><span 28</span> <span     }
</span><span 29</span>     <span echo</span> "\t</tr>\n"<span ;
</span><span 30</span>     <span while</span> (<span $row</span> = mssql_fetch_array(<span $result</span>,<span  MSSQL_ASSOC)) 
</span><span 31</span> <span     { 
</span><span 32</span>         <span //</span><span 判断之后显示男女中文</span>
<span 33</span>         <span if</span>(<span $row</span>["tsex"]=='0'<span )
</span><span 34</span>                 <span $row</span>["tsex"]='男'<span ;
</span><span 35</span>             <span else</span>
<span 36</span>                 <span $row</span>["tsex"]='女'<span ;
</span><span 37</span>             <span //</span><span 判断是不是超级管理员</span>
<span 38</span>             <span if</span>(<span $row</span>["tsuper"]=='10'<span )
</span><span 39</span>                 <span $row</span>["tsuper"]='超级老师管理员'<span ;
</span><span 40</span>             <span else</span>
<span 41</span>                 <span $row</span>["tsuper"]='普通老师管理员'<span ;
</span><span 42</span>             
<span 43</span>                 <span //</span><span 输出内容</span>
<span 44</span>             <span echo</span> "\t<tr>\n"<span ;
</span><span 45</span>                     <span echo</span> '<td>'.<span $row</span>["tid"].'</td>'<span ;
</span><span 46</span>                     <span echo</span> '<td>'.<span $row</span>["tname"].'</td>'<span ;
</span><span 47</span>                     <span echo</span> '<td>'.<span $row</span>["tage"].'</td>'<span ;
</span><span 48</span>                     <span echo</span> '<td>'.<span $row</span>["tsex"].'</td>'<span ;
</span><span 49</span>                     <span echo</span> '<td>'.<span $row</span>["tcount"].'</td>'<span ;
</span><span 50</span>                     <span echo</span> '<td>******</td>';<span //</span><span 隐藏的写法</span>
<span 51</span>                     <span echo</span> '<td>'.<span $row</span>["tsuper"].'</td>'<span ;
</span><span 52</span>             <span echo</span> "\t</tr>\n"<span ;
</span><span 53</span> <span     }
</span><span 54</span>     <span echo</span> "</table>\n"<span ;
</span><span 55</span>     
<span 56</span>     <span //</span><span 释放SQL链接</span>
<span 57</span>         mssql_free_result(<span $result</span><span );
</span><span 58</span> }

老师添加老师（权限限制）

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

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

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

老师添加课程

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

老师查看选课情况

 

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

老师删减课程

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

老师查看成绩

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

老师上传成绩

<span> <span if>(<span isset>(<span>['up'<span><span> <span><span> <span sql><span>     <span><span cookie>
<span>     <span>=<span>["uid"<span><span>     <span><span post>
<span>     <span>=<span>['cid'<span><span>     <span><span>
<span>     <span>="SELECT * FROM [V3].[dbo].[class] where [cid]=".<span>." AND [tid] = ".<span>.""<span><span>     <span> = mssql_query(<span><span><span>     <span>=0;<span><span>
<span>     <span while> (<span> = mssql_fetch_array(<span>,<span mssql_assoc><span> <span><span>         <span>[<span>]=<span>['score'<span><span>         <span>[<span>]=<span>['sid'<span><span>         <span>++<span><span> <span><span>     <span for>(<span>=0;<span>;<span>++<span><span> <span><span>         <span if>(<span>[<span>]=='0'<span><span> <span><span>             <span><span>
<span>             <span continue><span><span> <span><span>         <span><span>
<span>         <span if>(<span is_numeric>(<span>["sid_<span>[<span>]"<span><span> <span><span>             <span><span>
<span>             <span if>(<span>["sid_<span>[<span>]"]</span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span>
声明
本文内容由网友自发贡献，版权归原作者所有，本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容，请联系admin@php.cn
相关文章
PHP和Python：解释了不同的范例PHP和Python：解释了不同的范例Apr 18, 2025 am 12:26 AM

PHP主要是过程式编程，但也支持面向对象编程（OOP）；Python支持多种范式，包括OOP、函数式和过程式编程。PHP适合web开发，Python适用于多种应用，如数据分析和机器学习。

PHP和Python：深入了解他们的历史PHP和Python：深入了解他们的历史Apr 18, 2025 am 12:25 AM

PHP起源于1994年，由RasmusLerdorf开发，最初用于跟踪网站访问者，逐渐演变为服务器端脚本语言，广泛应用于网页开发。Python由GuidovanRossum于1980年代末开发，1991年首次发布，强调代码可读性和简洁性，适用于科学计算、数据分析等领域。

在PHP和Python之间进行选择：指南在PHP和Python之间进行选择：指南Apr 18, 2025 am 12:24 AM

PHP适合网页开发和快速原型开发，Python适用于数据科学和机器学习。1.PHP用于动态网页开发，语法简单，适合快速开发。2.Python语法简洁，适用于多领域，库生态系统强大。

PHP和框架：现代化语言PHP和框架：现代化语言Apr 18, 2025 am 12:14 AM

PHP在现代化进程中仍然重要，因为它支持大量网站和应用，并通过框架适应开发需求。1.PHP7提升了性能并引入了新功能。2.现代框架如Laravel、Symfony和CodeIgniter简化开发，提高代码质量。3.性能优化和最佳实践进一步提升应用效率。

PHP的影响：网络开发及以后PHP的影响：网络开发及以后Apr 18, 2025 am 12:10 AM

PHPhassignificantlyimpactedwebdevelopmentandextendsbeyondit.1)ItpowersmajorplatformslikeWordPressandexcelsindatabaseinteractions.2)PHP'sadaptabilityallowsittoscaleforlargeapplicationsusingframeworkslikeLaravel.3)Beyondweb,PHPisusedincommand-linescrip

PHP类型提示如何起作用，包括标量类型，返回类型，联合类型和无效类型？PHP类型提示如何起作用，包括标量类型，返回类型，联合类型和无效类型？Apr 17, 2025 am 12:25 AM

PHP类型提示提升代码质量和可读性。1)标量类型提示：自PHP7.0起，允许在函数参数中指定基本数据类型，如int、float等。2)返回类型提示：确保函数返回值类型的一致性。3)联合类型提示：自PHP8.0起，允许在函数参数或返回值中指定多个类型。4)可空类型提示：允许包含null值，处理可能返回空值的函数。

PHP如何处理对象克隆（克隆关键字）和__clone魔法方法？PHP如何处理对象克隆（克隆关键字）和__clone魔法方法？Apr 17, 2025 am 12:24 AM

PHP中使用clone关键字创建对象副本，并通过\_\_clone魔法方法定制克隆行为。1.使用clone关键字进行浅拷贝，克隆对象的属性但不克隆对象属性内的对象。2.通过\_\_clone方法可以深拷贝嵌套对象，避免浅拷贝问题。3.注意避免克隆中的循环引用和性能问题，优化克隆操作以提高效率。

PHP与Python：用例和应用程序PHP与Python：用例和应用程序Apr 17, 2025 am 12:23 AM

PHP适用于Web开发和内容管理系统，Python适合数据科学、机器学习和自动化脚本。1.PHP在构建快速、可扩展的网站和应用程序方面表现出色，常用于WordPress等CMS。2.Python在数据科学和机器学习领域表现卓越，拥有丰富的库如NumPy和TensorFlow。

See all articles

热AI工具

Undresser.AI Undress

Undresser.AI Undress

人工智能驱动的应用程序，用于创建逼真的裸体照片

AI Clothes Remover

AI Clothes Remover

用于从照片中去除衣服的在线人工智能工具。

Undress AI Tool

Undress AI Tool

免费脱衣服图片

Clothoff.io

Clothoff.io

AI脱衣机

AI Hentai Generator

AI Hentai Generator

免费生成ai无尽的。

显示更多

热门文章

R.E.P.O.能量晶体解释及其做什么（黄色晶体）
1 个月前By尊渡假赌尊渡假赌尊渡假赌
R.E.P.O.最佳图形设置
1 个月前By尊渡假赌尊渡假赌尊渡假赌
刺客信条阴影：贝壳谜语解决方案
3 周前ByDDD
Windows 11 KB5054979中的新功能以及如何解决更新问题
2 周前ByDDD
威尔R.E.P.O.有交叉游戏吗？
1 个月前By尊渡假赌尊渡假赌尊渡假赌
显示更多

热工具

MinGW - 适用于 Windows 的极简 GNU

MinGW - 适用于 Windows 的极简 GNU

这个项目正在迁移到osdn.net/projects/mingw的过程中，你可以继续在那里关注我们。MinGW：GNU编译器集合（GCC）的本地Windows移植版本，可自由分发的导入库和用于构建本地Windows应用程序的头文件；包括对MSVC运行时的扩展，以支持C99功能。MinGW的所有软件都可以在64位Windows平台上运行。

Dreamweaver CS6

Dreamweaver CS6

视觉化网页开发工具

WebStorm Mac版

WebStorm Mac版

好用的JavaScript开发工具

ZendStudio 13.5.1 Mac

ZendStudio 13.5.1 Mac

功能强大的PHP集成开发环境

记事本++7.3.1

记事本++7.3.1

好用且免费的代码编辑器

显示更多

热门话题

gmail邮箱登陆入口在哪里
7554
15
CakePHP 教程
1382
52
steam的账户名称是什么格式
83
11
win11激活密钥永久
59
19
NYT连接提示和答案
28
96
显示更多