基于Sql Server 2008的分布式数据库的实践（五）
server
sql
分散式
基於
實踐
資料庫
的
程式設計
程序设计
-----------------------------------------------------------------------------------------------------------------
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
熱AI工具
Undresser.AI Undress
人工智慧驅動的應用程序，用於創建逼真的裸體照片
AI Clothes Remover
用於從照片中去除衣服的線上人工智慧工具。
Undress AI Tool
免費脫衣圖片
Clothoff.io
AI脫衣器
Video Face Swap
使用我們完全免費的人工智慧換臉工具，輕鬆在任何影片中換臉！
熱門文章
Windows 11 KB5054979中的新功能以及如何解決更新問題
3 週前
By DDD
如何修復KB5055523無法在Windows 11中安裝？
2 週前
By DDD
Inzoi：如何申請學校和大學
4 週前
By DDD
如何修復KB5055518無法在Windows 10中安裝？
2 週前
By DDD
Roblox：Dead Rails - 如何召喚和擊敗Nikola Tesla
1 個月前
By 尊渡假赌尊渡假赌尊渡假赌
熱工具
記事本++7.3.1
好用且免費的程式碼編輯器
SublimeText3漢化版
中文版，非常好用
禪工作室 13.0.1
強大的PHP整合開發環境
Dreamweaver CS6
視覺化網頁開發工具
SublimeText3 Mac版
神級程式碼編輯軟體(SublimeText3)
iOS 18 新增「已復原」相簿功能 可找回遺失或損壞的照片
Jul 18, 2024 am 05:48 AM
蘋果公司最新發布的iOS18、iPadOS18以及macOSSequoia系統為Photos應用程式增添了一項重要功能，旨在幫助用戶輕鬆恢復因各種原因遺失或損壞的照片和影片。這項新功能在Photos應用的"工具"部分引入了一個名為"已恢復"的相冊，當用戶設備中存在未納入其照片庫的圖片或影片時，該相冊將自動顯示。 "已恢復"相簿的出現為因資料庫損壞、相機應用未正確保存至照片庫或第三方應用管理照片庫時照片和視頻丟失提供了解決方案。使用者只需簡單幾步
在PHP中使用MySQLi建立資料庫連線的詳盡教學
Jun 04, 2024 pm 01:42 PM
如何在PHP中使用MySQLi建立資料庫連線：包含MySQLi擴充（require_once）建立連線函數（functionconnect_to_db）呼叫連線函數（$conn=connect_to_db()）執行查詢（$result=$conn->query()）關閉連線（ $conn->close()）
如何在PHP中處理資料庫連線錯誤
Jun 05, 2024 pm 02:16 PM
PHP處理資料庫連線報錯，可以使用下列步驟：使用mysqli_connect_errno()取得錯誤代碼。使用mysqli_connect_error()取得錯誤訊息。透過擷取並記錄這些錯誤訊息，可以輕鬆識別並解決資料庫連接問題，確保應用程式的順暢運作。
如何用 Golang 連接遠端資料庫？
Jun 01, 2024 pm 08:31 PM
透過Go標準庫database/sql包，可以連接到MySQL、PostgreSQL或SQLite等遠端資料庫：建立包含資料庫連接資訊的連接字串。使用sql.Open()函數開啟資料庫連線。執行SQL查詢和插入操作等資料庫操作。使用defer關閉資料庫連線以釋放資源。
如何在 Golang 中使用資料庫回呼函數？
Jun 03, 2024 pm 02:20 PM
在Golang中使用資料庫回呼函數可以實現：在指定資料庫操作完成後執行自訂程式碼。透過單獨的函數新增自訂行為，無需編寫額外程式碼。回調函數可用於插入、更新、刪除和查詢操作。必須使用sql.Exec、sql.QueryRow或sql.Query函數才能使用回呼函數。
如何在 Golang 中將 JSON 資料保存到資料庫中？
Jun 06, 2024 am 11:24 AM
可以透過使用gjson函式庫或json.Unmarshal函數將JSON資料儲存到MySQL資料庫中。 gjson函式庫提供了方便的方法來解析JSON字段，而json.Unmarshal函數需要一個目標類型指標來解組JSON資料。這兩種方法都需要準備SQL語句和執行插入操作來將資料持久化到資料庫中。
如何使用C++處理資料庫連線和操作？
Jun 01, 2024 pm 07:24 PM
在C++中使用DataAccessObjects(DAO)函式庫連接和操作資料庫，包括建立資料庫連線、執行SQL查詢、插入新記錄和更新現有記錄。具體步驟為：1.包含必要的函式庫語句；2.開啟資料庫檔案；3.建立Recordset物件執行SQL查詢或操作資料；4.遍歷結果或依照特定需求更新記錄。
PHP與不同資料庫的連接：MySQL、PostgreSQL、Oracle和更多
Jun 01, 2024 pm 03:02 PM
PHP連接資料庫指南：MySQL：安裝MySQLi擴展，建立連線（servername、username、password、dbname）。 PostgreSQL：安裝PgSQL擴展，建立連線（host、dbname、user、password）。 Oracle：安裝OracleOCI8擴展，建立連線（servername、username、password）。實戰案例：取得MySQL資料、PostgreSQL查詢、OracleOCI8更新記錄。
