Table of Contents
Home
Backend Development
PHP Tutorial
Practice of distributed database based on Sql Server 2008 (5)_PHP tutorial
Backend Development
PHP Tutorial
Practice of distributed database based on Sql Server 2008 (5)_PHP tutorial
Practice of distributed database based on Sql Server 2008 (5)_PHP tutorial
server
sql
distributed
based on
practice
database
of
programming
Programming
-------------------------------------------------- -------------------------------------------------- ------------------
Index.php——Select the interface and register students and teachers
sql_ini.php————SQL configuration file
./student————Student’s backstage
./admin————Teacher’s backstage
-------------------------------------------------- -------------------------------------------------- ------------------
./student
cookie.php————cookie jump file
index1.php————Backend interface
login.php————Login interface
loginout.php————cookie logout processing
main.php————Main interface
menu.php————Backend menu
sclass.php————Displays student course selection information
score.php-————Display student scores
sinfo.php————display*
sql_ini.php————SQL configuration file
up.php————Backend form processing file
-------------------------------------------------- -------------------------------------------------- ------------------
./admin
class.php————Display teacher course information
cookie.php————cookie jump file
index1.php————Backend interface
info.php————Display teacher information (with permission settings)
login.php————Login interface
loginout.php————cookie logout processing
main.php————Main interface
menu.php————Backend menu
score.php-————Register student scores
sql_ini.php————SQL configuration file
up.php————Backend form processing file
Procedure explanation
Student Registration
<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> }Copy after login
Teacher Registration
<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> }Copy after login
Student login and view information
<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>);Copy after login
Students choose courses
<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> }Copy after login
Students drop out of class
<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> }Copy after login
Students check results
<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";Copy after login
Teacher log in and view all information (permission restrictions)
<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> }Copy after login
Teacher check information
<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> }Copy after login
Teacher Add teacher (permission restrictions)
<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> }Copy after login
Teacher deletes teacher (permission restrictions)
<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> }Copy after login
Teacher adds course
<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> }Copy after login
Teacher checks course selection status
<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> ?>Copy after login
老师删减课程
<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出错！";}Copy after login
老师查看成绩
<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> }Copy after login
老师上传成绩
<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> <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>]"]<=100&&<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></span>
Copy after login
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!
Hot Article
Assassin's Creed Shadows: Seashell Riddle Solution
3 weeks ago
By DDD
What's New in Windows 11 KB5054979 & How to Fix Update Issues
2 weeks ago
By DDD
Where to find the Crane Control Keycard in Atomfall
3 weeks ago
By DDD
Assassin's Creed Shadows - How To Find The Blacksmith And Unlock Weapon And Armour Customisation
4 weeks ago
By DDD
Roblox: Dead Rails - How To Complete Every Challenge
3 weeks ago
By DDD
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
CakePHP Tutorial
1386
52
1386
52
iOS 18 adds a new 'Recovered' album function to retrieve lost or damaged photos
Jul 18, 2024 am 05:48 AM
Apple's latest releases of iOS18, iPadOS18 and macOS Sequoia systems have added an important feature to the Photos application, designed to help users easily recover photos and videos lost or damaged due to various reasons. The new feature introduces an album called "Recovered" in the Tools section of the Photos app that will automatically appear when a user has pictures or videos on their device that are not part of their photo library. The emergence of the "Recovered" album provides a solution for photos and videos lost due to database corruption, the camera application not saving to the photo library correctly, or a third-party application managing the photo library. Users only need a few simple steps
Detailed tutorial on establishing a database connection using MySQLi in PHP
Jun 04, 2024 pm 01:42 PM
How to use MySQLi to establish a database connection in PHP: Include MySQLi extension (require_once) Create connection function (functionconnect_to_db) Call connection function ($conn=connect_to_db()) Execute query ($result=$conn->query()) Close connection ( $conn->close())
How to handle database connection errors in PHP
Jun 05, 2024 pm 02:16 PM
To handle database connection errors in PHP, you can use the following steps: Use mysqli_connect_errno() to obtain the error code. Use mysqli_connect_error() to get the error message. By capturing and logging these error messages, database connection issues can be easily identified and resolved, ensuring the smooth running of your application.
How to connect to remote database using Golang?
Jun 01, 2024 pm 08:31 PM
Through the Go standard library database/sql package, you can connect to remote databases such as MySQL, PostgreSQL or SQLite: create a connection string containing database connection information. Use the sql.Open() function to open a database connection. Perform database operations such as SQL queries and insert operations. Use defer to close the database connection to release resources.
How to use database callback functions in Golang?
Jun 03, 2024 pm 02:20 PM
Using the database callback function in Golang can achieve: executing custom code after the specified database operation is completed. Add custom behavior through separate functions without writing additional code. Callback functions are available for insert, update, delete, and query operations. You must use the sql.Exec, sql.QueryRow, or sql.Query function to use the callback function.
How to handle database connections and operations using C++?
Jun 01, 2024 pm 07:24 PM
Use the DataAccessObjects (DAO) library in C++ to connect and operate the database, including establishing database connections, executing SQL queries, inserting new records and updating existing records. The specific steps are: 1. Include necessary library statements; 2. Open the database file; 3. Create a Recordset object to execute SQL queries or manipulate data; 4. Traverse the results or update records according to specific needs.
PHP connections to different databases: MySQL, PostgreSQL, Oracle and more
Jun 01, 2024 pm 03:02 PM
PHP database connection guide: MySQL: Install the MySQLi extension and create a connection (servername, username, password, dbname). PostgreSQL: Install the PgSQL extension and create a connection (host, dbname, user, password). Oracle: Install the OracleOCI8 extension and create a connection (servername, username, password). Practical case: Obtain MySQL data, PostgreSQL query, OracleOCI8 update record.
How to save JSON data to database in Golang?
Jun 06, 2024 am 11:24 AM
JSON data can be saved into a MySQL database by using the gjson library or the json.Unmarshal function. The gjson library provides convenience methods to parse JSON fields, and the json.Unmarshal function requires a target type pointer to unmarshal JSON data. Both methods require preparing SQL statements and performing insert operations to persist the data into the database.
