基于Sql Server 2008的分布式数据库的实践（五）_PHP教程
server
sql
diedarkan
berdasarkan
berlatih
pangkalan data
daripada
Pengaturcaraan
程序设计
-----------------------------------------------------------------------------------------------------------------
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> }Salin selepas log masuk
老师注册
<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> }Salin selepas log masuk
学生登录和查看资料
<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>);Salin selepas log masuk
学生选课
<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> }Salin selepas log masuk
学生退课
<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> }Salin selepas log masuk
学生查看成绩
<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";Salin selepas log masuk
老师登录和查看所有资料（权限限制）
<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> }Salin selepas log masuk
老师查看资料
<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> }Salin selepas log masuk
老师添加老师（权限限制）
<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> }Salin selepas log masuk
老师删减老师（权限限制）
<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> }Salin selepas log masuk
老师添加课程
<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> }Salin selepas log masuk
老师查看选课情况
<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> ?>Salin selepas log masuk
老师删减课程
<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出错！";}Salin selepas log masuk
老师查看成绩
<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> }Salin selepas log masuk
老师上传成绩
<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>
Salin selepas log masuk
Kenyataan Laman Web ini
Kandungan artikel ini disumbangkan secara sukarela oleh netizen, dan hak cipta adalah milik pengarang asal. Laman web ini tidak memikul tanggungjawab undang-undang yang sepadan. Jika anda menemui sebarang kandungan yang disyaki plagiarisme atau pelanggaran, sila hubungi admin@php.cn
Alat AI Hot
Undresser.AI Undress
Apl berkuasa AI untuk mencipta foto bogel yang realistik
AI Clothes Remover
Alat AI dalam talian untuk mengeluarkan pakaian daripada foto.
Undress AI Tool
Gambar buka pakaian secara percuma
Clothoff.io
Penyingkiran pakaian AI
AI Hentai Generator
Menjana ai hentai secara percuma.
Artikel Panas
R.E.P.O. Kristal tenaga dijelaskan dan apa yang mereka lakukan (kristal kuning)
3 minggu yang lalu
By 尊渡假赌尊渡假赌尊渡假赌
R.E.P.O. Tetapan grafik terbaik
3 minggu yang lalu
By 尊渡假赌尊渡假赌尊渡假赌
Assassin's Creed Shadows: Penyelesaian Riddle Seashell
2 minggu yang lalu
By DDD
R.E.P.O. Cara Memperbaiki Audio Jika anda tidak dapat mendengar sesiapa
3 minggu yang lalu
By 尊渡假赌尊渡假赌尊渡假赌
WWE 2K25: Cara Membuka Segala -galanya Di Myrise
4 minggu yang lalu
By 尊渡假赌尊渡假赌尊渡假赌
Alat panas
Notepad++7.3.1
Editor kod yang mudah digunakan dan percuma
SublimeText3 versi Cina
Versi Cina, sangat mudah digunakan
Hantar Studio 13.0.1
Persekitaran pembangunan bersepadu PHP yang berkuasa
Dreamweaver CS6
Alat pembangunan web visual
SublimeText3 versi Mac
Perisian penyuntingan kod peringkat Tuhan (SublimeText3)
Topik panas
Tutorial CakePHP
1376
52
1376
52
Apakah perbezaan antara HQL dan SQL dalam rangka kerja Hibernate?
Apr 17, 2024 pm 02:57 PM
HQL dan SQL dibandingkan dalam rangka kerja Hibernate: HQL (1. Sintaks berorientasikan objek, 2. Pertanyaan bebas pangkalan data, 3. Keselamatan jenis), manakala SQL mengendalikan pangkalan data secara langsung (1. Piawaian bebas pangkalan data, 2. Boleh laku kompleks pertanyaan dan manipulasi data).
Bagaimanakah Hibernate melaksanakan pemetaan polimorfik?
Apr 17, 2024 pm 12:09 PM
Pemetaan polimorfik hibernate boleh memetakan kelas yang diwarisi ke pangkalan data dan menyediakan jenis pemetaan berikut: subkelas bercantum: Cipta jadual berasingan untuk subkelas, termasuk semua lajur kelas induk. table-per-class: Cipta jadual berasingan untuk subkelas, yang mengandungi hanya lajur khusus subkelas. union-subclass: serupa dengan joined-subclass, tetapi jadual kelas induk menggabungkan semua lajur subclass.
iOS 18 menambah fungsi album 'Dipulihkan' baharu untuk mendapatkan semula foto yang hilang atau rosak
Jul 18, 2024 am 05:48 AM
Keluaran terbaharu Apple bagi sistem iOS18, iPadOS18 dan macOS Sequoia telah menambah ciri penting pada aplikasi Photos, yang direka untuk membantu pengguna memulihkan foto dan video yang hilang atau rosak dengan mudah disebabkan pelbagai sebab. Ciri baharu ini memperkenalkan album yang dipanggil "Dipulihkan" dalam bahagian Alat pada apl Foto yang akan muncul secara automatik apabila pengguna mempunyai gambar atau video pada peranti mereka yang bukan sebahagian daripada pustaka foto mereka. Kemunculan album "Dipulihkan" menyediakan penyelesaian untuk foto dan video yang hilang akibat kerosakan pangkalan data, aplikasi kamera tidak disimpan ke pustaka foto dengan betul, atau aplikasi pihak ketiga yang menguruskan pustaka foto. Pengguna hanya memerlukan beberapa langkah mudah
Tutorial terperinci tentang mewujudkan sambungan pangkalan data menggunakan MySQLi dalam PHP
Jun 04, 2024 pm 01:42 PM
Cara menggunakan MySQLi untuk mewujudkan sambungan pangkalan data dalam PHP: Sertakan sambungan MySQLi (require_once) Cipta fungsi sambungan (functionconnect_to_db) Fungsi sambungan panggilan ($conn=connect_to_db()) Laksanakan pertanyaan ($result=$conn->query()) Tutup sambungan ( $conn->close())
Bagaimana untuk mengendalikan ralat sambungan pangkalan data dalam PHP
Jun 05, 2024 pm 02:16 PM
Untuk mengendalikan ralat sambungan pangkalan data dalam PHP, anda boleh menggunakan langkah berikut: Gunakan mysqli_connect_errno() untuk mendapatkan kod ralat. Gunakan mysqli_connect_error() untuk mendapatkan mesej ralat. Dengan menangkap dan mengelog mesej ralat ini, isu sambungan pangkalan data boleh dikenal pasti dan diselesaikan dengan mudah, memastikan kelancaran aplikasi anda.
Bagaimana untuk menggunakan fungsi panggil balik pangkalan data di Golang?
Jun 03, 2024 pm 02:20 PM
Menggunakan fungsi panggil balik pangkalan data di Golang boleh mencapai: melaksanakan kod tersuai selepas operasi pangkalan data yang ditentukan selesai. Tambah tingkah laku tersuai melalui fungsi berasingan tanpa menulis kod tambahan. Fungsi panggil balik tersedia untuk operasi memasukkan, mengemas kini, memadam dan pertanyaan. Anda mesti menggunakan fungsi sql.Exec, sql.QueryRow atau sql.Query untuk menggunakan fungsi panggil balik.
Bagaimana untuk menyambung ke pangkalan data jauh menggunakan Golang?
Jun 01, 2024 pm 08:31 PM
Melalui pakej pangkalan data/sql perpustakaan standard Go, anda boleh menyambung ke pangkalan data jauh seperti MySQL, PostgreSQL atau SQLite: buat rentetan sambungan yang mengandungi maklumat sambungan pangkalan data. Gunakan fungsi sql.Open() untuk membuka sambungan pangkalan data. Lakukan operasi pangkalan data seperti pertanyaan SQL dan operasi sisipan. Gunakan tangguh untuk menutup sambungan pangkalan data untuk mengeluarkan sumber.
Bagaimana untuk mengendalikan sambungan dan operasi pangkalan data menggunakan C++?
Jun 01, 2024 pm 07:24 PM
Gunakan perpustakaan DataAccessObjects (DAO) dalam C++ untuk menyambung dan mengendalikan pangkalan data, termasuk mewujudkan sambungan pangkalan data, melaksanakan pertanyaan SQL, memasukkan rekod baharu dan mengemas kini rekod sedia ada. Langkah-langkah khusus ialah: 1. Sertakan penyata perpustakaan yang diperlukan 2. Buka fail pangkalan data 3. Buat objek Recordset untuk melaksanakan pertanyaan SQL atau memanipulasi data 4. Melintasi keputusan atau mengemas kini rekod mengikut keperluan tertentu;
