当前位置：Gxlcms > 数据库问题 > php对数据库的增删改

php对数据库的增删改

时间：2021-07-01 10:21:17 帮助过：30人阅读

<!doctype html> 2 <html> 3 <head> 4 <meta charset="utf-8"> 5 <title>无标题文档</title> 6 </head> 7 8 <body> 9 10 <?php 11 //创建数据库 12 $db = new MySQLi("localhost","root","","z_stu"); 13 //判断连接是否成功 14 !mysqli_connect_error() or die("连接失败"); 15 $db->query("set names utf8"); 16 //创建SQL语句，查询教师表 17 $sql = "select * from teacher"; 18 //把SQL语句转成结果集 19 $result = $db->query($sql); 20 //把结果集转为数组 21 $attr = $result->fetch_all(); 22 23 ?> 24 25 <!--创建表格--> 26 <table border="1" width = "100%"> 27 <caption>老师表</caption> 28 <tr> 29 <th>编号</th> 30 <th>姓名</th> 31 <th>性别</th> 32 <th>生日</th> 33 <th>职称</th> 34 <th>所在系</th> 35 </tr> 36 <!--遍历获取表格--> 37 <?php 38 foreach($attr as $v){ ?> 39 <tr> 40 <td><?php echo $v[0] ?></td> 41 <td><?php echo $v[1] ?></td> 42 <!--判断数据库中的男女性别 运用到三元运算符--> 43 <td> 44 <?php 45 echo $v[2] == "1" ? "男" : "女" ; 46 ?> 47 </td> 48 <!-- 去掉计时 这里运用了substr--> 49 <td> 50 <?php 51 echo substr($v[3],0,10); 52 //echo $v[3]; 53 ?> 54 </td> 55 <td> 56 <?php 57 echo $v[4] 58 ?> 59 </td> 60 <td> 61 <?php 62 echo $v[5] 63 ?> 64 </td> 65 <td> 66 <!--把删除按钮链接到数据库中的相对性的编号 67 参数传值时是不需要加单引号的，字符串的拼接则需要单引号--> 68 <a href="chuli/delet.php?uid= 69 <?php 70 echo $v[0]; 71 ?>"> 72 <button class ="btn">删除</button> 73 <a href="update.php?type=updat&tno=<?php echo $v[0];?>"> 74 <button>编辑</button> 75 </a> 76 77 <!--a标签和form标签都可以实现--> 78 <!-- 79 <form action="chuli/delet.php" method = "post"> 80 <input type="hidden" name = "uid" value = "<?//php echo $v[0]; ?>"> 81 <button>删除</button> 82 </form> 83 --> 84 </a> 85 </td> 86 </tr> 87 <?php }?> 88 89 </table> 90 <!-- 添加老师信息 91 get 传值不要加空格--> 92 <a href="update.php?type=add"> 93 <button>添加数据</button> 94 </a> 95 96 97 98 99 100 </body> 101 </html> 102 103 主页的建立

效果图如下：

技术分享图片

技术分享图片 
  1. <span style="color: #008080">  1</span>     <!doctype html>
  2. <span style="color: #008080">  2</span>     <html>
  3. <span style="color: #008080">  3</span>     <head>
  4. <span style="color: #008080">  4</span>     <meta charset="utf-8">
  5. <span style="color: #008080">  5</span>     <title>编辑老师信息</title>
  6. <span style="color: #008080">  6</span>     <link rel="stylesheet" href="../../bootstrap.min.css">
  7. <span style="color: #008080">  7</span>     <script type="text/javascript" src="../../jquery-3.2.1.min.js"
  8. <span style="color: #008080">  8</span>     ></script>
  9. <span style="color: #008080">  9</span>     <script type="text/javascript" src="../../bootstrap-datetimepicker.js"
  10. <span style="color: #008080"> 10</span>     ></script>
  11. <span style="color: #008080"> 11</span>     </head>
  12. <span style="color: #008080"> 12</span> 
  13. <span style="color: #008080"> 13</span>     <body>
  14. <span style="color: #008080"> 14</span>     <?<span style="color: #000000">php
  15. </span><span style="color: #008080"> 15</span>         <span style="color: #008000">//</span><span style="color: #008000">$tno = $_GET["tno"];
  16. </span><span style="color: #008080"> 16</span> 
  17. <span style="color: #008080"> 17</span> <span style="color: #008000">        //连接数据库</span>
  18. <span style="color: #008080"> 18</span>     <span style="color: #800080">$db</span> = <span style="color: #0000ff">new</span> MySQLi("localhost","root","","z_stu"<span style="color: #000000">);
  19. </span><span style="color: #008080"> 19</span>     !<span style="color: #008080">mysqli_connect_error</span>()or <span style="color: #0000ff">die</span>("连接失败"<span style="color: #000000">);
  20. </span><span style="color: #008080"> 20</span>     <span style="color: #800080">$db</span>->query("set names utf8"<span style="color: #000000">);
  21. </span><span style="color: #008080"> 21</span>     
  22. <span style="color: #008080"> 22</span>         
  23. <span style="color: #008080"> 23</span>         <span style="color: #800080">$type</span> = <span style="color: #800080">$_GET</span>["type"<span style="color: #000000">];
  24. </span><span style="color: #008080"> 24</span>         <span style="color: #0000ff">if</span>(<span style="color: #800080">$type</span> =="updat"<span style="color: #000000">){
  25. </span><span style="color: #008080"> 25</span>             <span style="color: #008000">//</span><span style="color: #008000">执行SQL语句选择表格</span>
  26. <span style="color: #008080"> 26</span>             <span style="color: #800080">$sql</span> = "select * from teacher where tno = ‘".<span style="color: #800080">$_GET</span>["tno"]."‘"<span style="color: #000000">;
  27. </span><span style="color: #008080"> 27</span>                 <span style="color: #008000">//</span><span style="color: #008000">将结果集转换成数组</span>
  28. <span style="color: #008080"> 28</span>             <span style="color: #800080">$result</span> = <span style="color: #800080">$db</span>->query(<span style="color: #800080">$sql</span><span style="color: #000000">);
  29. </span><span style="color: #008080"> 29</span>                 <span style="color: #008000">//</span><span style="color: #008000">得出数组的结果集</span>
  30. <span style="color: #008080"> 30</span>             <span style="color: #800080">$attr</span> = <span style="color: #800080">$result</span>-><span style="color: #000000">fetch_row();
  31. </span><span style="color: #008080"> 31</span> <span style="color: #000000">        }
  32. </span><span style="color: #008080"> 32</span>         
  33. <span style="color: #008080"> 33</span>     <span style="color: #800080">$proName</span> = <span style="color: #0000ff">array</span>("助教","教授","副教授"<span style="color: #000000">);
  34. </span><span style="color: #008080"> 34</span>     <span style="color: #800080">$depName</span> = <span style="color: #0000ff">array</span>("计算机系","电子工程系","数控系"<span style="color: #000000">);
  35. </span><span style="color: #008080"> 35</span> 
  36. <span style="color: #008080"> 36</span>     ?>
  37. <span style="color: #008080"> 37</span> 
  38. <span style="color: #008080"> 38</span>     <!--简历表格 fieldset是一种特殊格式-->
  39. <span style="color: #008080"> 39</span>     <fieldset>
  40. <span style="color: #008080"> 40</span>         <!--添加标题-->
  41. <span style="color: #008080"> 41</span>         <legend><?php <span style="color: #0000ff">echo</span> <span style="color: #800080">$type</span> == "updat" ? "编辑" : "添加"; ?>数据</legend>
  42. <span style="color: #008080"> 42</span>         <!--以post方式传值到insert页面-->
  43. <span style="color: #008080"> 43</span>         <form action="chuli/insert.php" method="post">
  44. <span style="color: #008080"> 44</span>             <input type="hidden" name="type" value="<?php echo <span style="color: #800080">$type</span>; ?>">
  45. <span style="color: #008080"> 45</span>             <table>
  46. <span style="color: #008080"> 46</span>                 
  47. <span style="color: #008080"> 47</span>                 <tr>
  48. <span style="color: #008080"> 48</span>                     <td>编号：</td>
  49. <span style="color: #008080"> 49</span>                     <td>
  50. <span style="color: #008080"> 50</span>                         <input type="text" name="tno" readonly value="<?php echo <span style="color: #800080">$attr</span>[0]==null ? "" : <span style="color: #800080">$attr</span>[0]; ?>">
  51. <span style="color: #008080"> 51</span>                     </td>
  52. <span style="color: #008080"> 52</span>                 </tr>
  53. <span style="color: #008080"> 53</span>                 <tr>
  54. <span style="color: #008080"> 54</span>                     <td>姓名：</td>
  55. <span style="color: #008080"> 55</span>                     <td>
  56. <span style="color: #008080"> 56</span>                         <input type="text" name="tname" value="<?php echo <span style="color: #800080">$attr</span>[1] == null ? "" : <span style="color: #800080">$attr</span>[1]; ?>">
  57. <span style="color: #008080"> 57</span>                     </td>
  58. <span style="color: #008080"> 58</span>                 </tr>
  59. <span style="color: #008080"> 59</span>                 <tr>
  60. <span style="color: #008080"> 60</span>                     <td>性别：</td>
  61. <span style="color: #008080"> 61</span>                     <td>
  62. <span style="color: #008080"> 62</span> <!--
  63. <span style="color: #008080"> 63</span>                     <?<span style="color: #000000">php
  64. </span><span style="color: #008080"> 64</span>                         <span style="color: #008000">//</span><span style="color: #008000">if($attr[2]=="男"){?></span>
  65. <span style="color: #008080"> 65</span>                             <input type="radio" name="tsex" value="男" checked><span style="color: #000000">男;
  66. </span><span style="color: #008080"> 66</span>                             <input type="radio" name="tsex" value="女" ><span style="color: #000000">女;
  67. </span><span style="color: #008080"> 67</span>                         }<span style="color: #0000ff">else</span>{?
  68. <span style="color: #008080"> 68</span>                             <input type="radio" name="tsex" value="男" ><span style="color: #000000">男;
  69. </span><span style="color: #008080"> 69</span>                             <input type="radio" name="tsex" value="女" checked><span style="color: #000000">女;
  70. </span><span style="color: #008080"> 70</span>                         }?>
  71. <span style="color: #008080"> 71</span> -->
  72. <span style="color: #008080"> 72</span>                         <input type="radio" name="tsex" value="1" <?php <span style="color: #0000ff">echo</span> <span style="color: #800080">$attr</span>[2] == "1"? "checked":""; ?> ><span style="color: #000000">男
  73. </span><span style="color: #008080"> 73</span>                         <input type="radio" name="tsex" value="0" <?php <span style="color: #0000ff">echo</span> <span style="color: #800080">$attr</span>[2] == "0"? "checked":""; ?> ><span style="color: #000000">女
  74. </span><span style="color: #008080"> 74</span>                     </td>
  75. <span style="color: #008080"> 75</span>                 </tr>
  76. <span style="color: #008080"> 76</span>                 <tr>
  77. <span style="color: #008080"> 77</span>                     <td>出生年月日：</td>
  78. <span style="color: #008080"> 78</span>                     <td>
  79. <span style="color: #008080"> 79</span>                         <input type="text" name="tbirthday" <?php <span style="color: #0000ff">echo</span> <span style="color: #800080">$attr</span>[3]== <span style="color: #0000ff">null</span> ? "" : <span style="color: #800080">$attr</span>[3]; ?> >
  80. <span style="color: #008080"> 80</span>                     </td>
  81. <span style="color: #008080"> 81</span>                 </tr>
  82. <span style="color: #008080"> 82</span>                 <tr>
  83. <span style="color: #008080"> 83</span>                     <td>职称：</td>
  84. <span style="color: #008080"> 84</span>                     <td>
  85. <span style="color: #008080"> 85</span>                     <select name="prof">
  86. <span style="color: #008080"> 86</span>                         <?<span style="color: #000000">php
  87. </span><span style="color: #008080"> 87</span>                             <span style="color: #0000ff">foreach</span>(<span style="color: #800080">$proName</span> <span style="color: #0000ff">as</span> <span style="color: #800080">$v</span><span style="color: #000000">){
  88. </span><span style="color: #008080"> 88</span>                                 <span style="color: #0000ff">if</span>(<span style="color: #800080">$v</span> == <span style="color: #800080">$attr</span>[4<span style="color: #000000">]){
  89. </span><span style="color: #008080"> 89</span>                                 <span style="color: #0000ff">echo</span> "<option selected><span style="color: #800080">$v</span></option>"<span style="color: #000000">;
  90. </span><span style="color: #008080"> 90</span>                             }<span style="color: #0000ff">else</span><span style="color: #000000">{
  91. </span><span style="color: #008080"> 91</span>                                 <span style="color: #0000ff">echo</span> "<option selected><span style="color: #800080">$v</span></option>"<span style="color: #000000">;
  92. </span><span style="color: #008080"> 92</span>                         }}?>
  93. <span style="color: #008080"> 93</span>                     </select>
  94. <span style="color: #008080"> 94</span>                     </td>
  95. <span style="color: #008080"> 95</span>                 </tr>
  96. <span style="color: #008080"> 96</span>                 <tr>
  97. <span style="color: #008080"> 97</span>                     <td>所在系：</td>
  98. <span style="color: #008080"> 98</span>                     <td>
  99. <span style="color: #008080"> 99</span>                         <select name="depart" >
  100. <span style="color: #008080">100</span>                             <?<span style="color: #000000">php
  101. </span><span style="color: #008080">101</span>                             <span style="color: #0000ff">foreach</span>(<span style="color: #800080">$depName</span> <span style="color: #0000ff">as</span> <span style="color: #800080">$v</span><span style="color: #000000">){
  102. </span><span style="color: #008080">102</span>                                 <span style="color: #0000ff">if</span>(<span style="color: #800080">$v</span> == <span style="color: #800080">$attr</span>[5<span style="color: #000000">]){
  103. </span><span style="color: #008080">103</span>                                     <span style="color: #0000ff">echo</span> "<option selected><span style="color: #800080">$v</span></option>"<span style="color: #000000">;
  104. </span><span style="color: #008080">104</span>                                 }<span style="color: #0000ff">else</span><span style="color: #000000">{
  105. </span><span style="color: #008080">105</span>                                     <span style="color: #0000ff">echo</span> "<option selected><span style="color: #800080">$v</span></option>"<span style="color: #000000">;
  106. </span><span style="color: #008080">106</span> <span style="color: #000000">                                }
  107. </span><span style="color: #008080">107</span>                             }?>
  108. <span style="color: #008080">108</span>                         </select>
  109. <span style="color: #008080">109</span>                     </td>
  110. <span style="color: #008080">110</span>                 </tr>
  111. <span style="color: #008080">111</span>             </table>
  112. <span style="color: #008080">112</span>             <button>提交</button>
  113. <span style="color: #008080">113</span>         </form>
  114. <span style="color: #008080">114</span>     </fieldset>
  115. <span style="color: #008080">115</span>     <script>
  116. <span style="color: #008080">116</span>         $(<span style="color: #0000ff">function</span><span style="color: #000000">(){
  117. </span><span style="color: #008080">117</span>             $(".form_datetime").<span style="color: #000000">datetimepicker({
  118. </span><span style="color: #008080">118</span>             format: ‘yyyy-mm-dd‘,<span style="color: #008000">//</span><span style="color: #008000">显示格式</span>
  119. <span style="color: #008080">119</span>             todayHighlight: 1,<span style="color: #008000">//</span><span style="color: #008000">今天高亮</span>
  120. <span style="color: #008080">120</span>             minView: "month",<span style="color: #008000">//</span><span style="color: #008000">设置只显示到月份</span>
  121. <span style="color: #008080">121</span>             startView:2,
  122. <span style="color: #008080">122</span>             forceParse: 0,
  123. <span style="color: #008080">123</span>             showMeridian: 1,
  124. <span style="color: #008080">124</span>             autoclose: 1<span style="color: #008000">//</span><span style="color: #008000">选择后自动关闭</span>
  125. <span style="color: #008080">125</span> <span style="color: #000000">    });
  126. </span><span style="color: #008080">126</span> 
  127. <span style="color: #008080">127</span>     </script>
  128. <span style="color: #008080">128</span> 
  129. <span style="color: #008080">129</span> </body>
  130. <span style="color: #008080">130</span> </html>
update页面

效果图：

技术分享图片

添加数据的代码：

技术分享图片 
  1. <span style="color: #008080"> 1</span> <!doctype html>
  2. <span style="color: #008080"> 2</span> <html>
  3. <span style="color: #008080"> 3</span> <head>
  4. <span style="color: #008080"> 4</span> <meta charset="utf-8">
  5. <span style="color: #008080"> 5</span> <title>这是添加数据的页面</title>
  6. <span style="color: #008080"> 6</span> <link rel="stylesheet" href="../../bootstrap.min.css">
  7. <span style="color: #008080"> 7</span> <script type="text/javascript" src="../../jquery-3.2.1.min.js"
  8. <span style="color: #008080"> 8</span> ></script>
  9. <span style="color: #008080"> 9</span> <script type="text/javascript" src="../../bootstrap-datetimepicker.js"
  10. <span style="color: #008080">10</span> ></script>
  11. <span style="color: #008080">11</span> </head>
  12. <span style="color: #008080">12</span> 
  13. <span style="color: #008080">13</span> <body>
  14. <span style="color: #008080">14</span>     <!--简历表格 fieldset是一种特殊格式-->
  15. <span style="color: #008080">15</span>     <fieldset>
  16. <span style="color: #008080">16</span>         <!--添加标题-->
  17. <span style="color: #008080">17</span>         <legend>添加数据</legend>
  18. <span style="color: #008080">18</span>         <!--以post方式传值到insert页面-->
  19. <span style="color: #008080">19</span>         <form action="chuli/insert.php" method="post">
  20. <span style="color: #008080">20</span>             <input type="hidden" name="type" value="add">
  21. <span style="color: #008080">21</span>             <table>
  22. <span style="color: #008080">22</span>                 
  23. <span style="color: #008080">23</span>                 <tr>
  24. <span style="color: #008080">24</span>                     <td>编号：</td>
  25. <span style="color: #008080">25</span>                     <td>
  26. <span style="color: #008080">26</span>                         <input type="text" name="tno">
  27. <span style="color: #008080">27</span>                     </td>
  28. <span style="color: #008080">28</span>                 </tr>
  29. <span style="color: #008080">29</span>                 <tr>
  30. <span style="color: #008080">30</span>                     <td>姓名：</td>
  31. <span style="color: #008080">31</span>                     <td>
  32. <span style="color: #008080">32</span>                         <input type="text" name="tname">
  33. <span style="color: #008080">33</span>                     </td>
  34. <span style="color: #008080">34</span>                 </tr>
  35. <span style="color: #008080">35</span>                 <tr>
  36. <span style="color: #008080">36</span>                     <td>性别：</td>
  37. <span style="color: #008080">37</span>                     <td>
  38. <span style="color: #008080">38</span>                         <input type="radio" name="tsex" value="1" checked><span style="color: #000000">男
  39. </span><span style="color: #008080">39</span>                         <input type="radio" name="tsex" value="0" ><span style="color: #000000">女
  40. </span><span style="color: #008080">40</span>                     </td>
  41. <span style="color: #008080">41</span>                 </tr>
  42. <span style="color: #008080">42</span>                 <tr>
  43. <span style="color: #008080">43</span>                     <td>出生年月日：</td>
  44. <span style="color: #008080">44</span>                     <td>
  45. <span style="color: #008080">45</span>                         <input <span style="color: #0000ff">class</span> = "form_datetime" type="text" name="tbirthday" readonly>
  46. <span style="color: #008080">46</span>                     </td>
  47. <span style="color: #008080">47</span>                 </tr>
  48. <span style="color: #008080">48</span>                 <tr>
  49. <span style="color: #008080">49</span>                     <td>职称：</td>
  50. <span style="color: #008080">50</span>                     <td>
  51. <span style="color: #008080">51</span>                     <select name="prof">
  52. <span style="color: #008080">52</span>                         <option>助教</option>
  53. <span style="color: #008080">53</span>                         <option>副教授</option>
  54. <span style="color: #008080">54</span>                         <option>教授</option>
  55. <span style="color: #008080">55</span>                     </select>
  56. <span style="color: #008080">56</span>                     </td>
  57. <span style="color: #008080">57</span>                 </tr>
  58. <span style="color: #008080">58</span>                 <tr>
  59. <span style="color: #008080">59</span>                     <td>所在系：</td>
  60. <span style="color: #008080">60</span>                     <td>
  61. <span style="color: #008080">61</span>                         <select name="depart">
  62. <span style="color: #008080">62</span>                             <option>计算机系</option>
  63. <span style="color: #008080">63</span>                             <option>电子工程系</option>
  64. <span style="color: #008080">64</span>                         </select>
  65. <span style="color: #008080">65</span>                     </td>
  66. <span style="color: #008080">66</span>                 </tr>
  67. <span style="color: #008080">67</span>             </table>
  68. <span style="color: #008080">68</span>             <button>提交</button>
  69. <span style="color: #008080">69</span>         </form>
  70. <span style="color: #008080">70</span>     </fieldset>
  71. <span style="color: #008080">71</span> 
  72. <span style="color: #008080">72</span> 
  73. <span style="color: #008080">73</span> </body>
  74. <span style="color: #008080">74</span> </html>
  75. <span style="color: #008080">75</span>     <script>
  76. <span style="color: #008080">76</span>         $(<span style="color: #0000ff">function</span><span style="color: #000000">(){
  77. </span><span style="color: #008080">77</span>             $(".form_datetime").<span style="color: #000000">datetimepicker({
  78. </span><span style="color: #008080">78</span>             format: ‘yyyy-mm-dd‘,<span style="color: #008000">//</span><span style="color: #008000">显示格式</span>
  79. <span style="color: #008080">79</span>             todayHighlight: 1,<span style="color: #008000">//</span><span style="color: #008000">今天高亮</span>
  80. <span style="color: #008080">80</span>             minView: "month",<span style="color: #008000">//</span><span style="color: #008000">设置只显示到月份</span>
  81. <span style="color: #008080">81</span>             startView:2,
  82. <span style="color: #008080">82</span>             forceParse: 0,
  83. <span style="color: #008080">83</span>             showMeridian: 1,
  84. <span style="color: #008080">84</span>             autoclose: 1<span style="color: #008000">//</span><span style="color: #008000">选择后自动关闭</span>
  85. <span style="color: #008080">85</span> <span style="color: #000000">    });
  86. </span><span style="color: #008080">86</span> 
  87. <span style="color: #008080">87</span>     </script>
代码

处理页面的代码：

技术分享图片1. 
  1. <span style="color: #008080"> 1</span> <?<span style="color: #000000">php
  2. </span><span style="color: #008080"> 2</span> <span style="color: #008000">//</span><span style="color: #008000">这个页面用来添加从主页传过来的值到teacher表中</span>
  3. <span style="color: #008080"> 3</span> <span style="color: #800080">$tno</span> =<span style="color: #800080">$_POST</span>["tno"];<span style="color: #008000">//</span><span style="color: #008000">教师编号</span>
  4. <span style="color: #008080"> 4</span> <span style="color: #800080">$tname</span> =<span style="color: #800080">$_POST</span>["tname"];<span style="color: #008000">//</span><span style="color: #008000">教师姓名</span>
  5. <span style="color: #008080"> 5</span> <span style="color: #800080">$tsex</span> =<span style="color: #800080">$_POST</span>["tsex"];<span style="color: #008000">//</span><span style="color: #008000">教师性别</span>
  6. <span style="color: #008080"> 6</span> <span style="color: #800080">$tbirthday</span> =<span style="color: #800080">$_POST</span>["tbirthday"];<span style="color: #008000">//</span><span style="color: #008000">教师生日</span>
  7. <span style="color: #008080"> 7</span> <span style="color: #800080">$prof</span> =<span style="color: #800080">$_POST</span>["prof"];<span style="color: #008000">//</span><span style="color: #008000">教师职称</span>
  8. <span style="color: #008080"> 8</span> <span style="color: #800080">$depart</span> =<span style="color: #800080">$_POST</span>["depart"];<span style="color: #008000">//</span><span style="color: #008000">教师所在系
  9. </span><span style="color: #008080"> 9</span> 
  10. <span style="color: #008080">10</span> <span style="color: #008000">//连接数据库</span>
  11. <span style="color: #008080">11</span> <span style="color: #800080">$db</span> = <span style="color: #0000ff">new</span> MySQLi("localhost","root","","z_stu"<span style="color: #000000">);
  12. </span><span style="color: #008080">12</span> !<span style="color: #008080">mysqli_connect_error</span>()or <span style="color: #0000ff">die</span>("连接失败"<span style="color: #000000">);
  13. </span><span style="color: #008080">13</span> <span style="color: #800080">$db</span>->query("set names utf8"<span style="color: #000000">);
  14. </span><span style="color: #008080">14</span> 
  15. <span style="color: #008080">15</span> <span style="color: #800080">$type</span> = <span style="color: #800080">$_POST</span>["type"<span style="color: #000000">];
  16. </span><span style="color: #008080">16</span> <span style="color: #0000ff">if</span>(<span style="color: #800080">$type</span> = "add"<span style="color: #000000">){
  17. </span><span style="color: #008080">17</span>     <span style="color: #800080">$sql</span> = "insert into teacher(".
  18. <span style="color: #008080">18</span>     "tno,".<span style="color: #008000">//</span><span style="color: #008000">编号</span>
  19. <span style="color: #008080">19</span>     "tname,".<span style="color: #008000">//</span><span style="color: #008000">姓名</span>
  20. <span style="color: #008080">20</span>     "tsex,".<span style="color: #008000">//</span><span style="color: #008000">性别</span>
  21. <span style="color: #008080">21</span>     "tbirthday,".<span style="color: #008000">//</span><span style="color: #008000">老师生日</span>
  22. <span style="color: #008080">22</span>     "prof,".<span style="color: #008000">//</span><span style="color: #008000">老师职称</span>
  23. <span style="color: #008080">23</span>     "depart".<span style="color: #008000">//</span><span style="color: #008000">老师所在系</span>
  24. <span style="color: #008080">24</span>     ") values(".
  25. <span style="color: #008080">25</span>     "‘<span style="color: #800080">$tno</span>‘,".<span style="color: #008000">//</span><span style="color: #008000">编号</span>
  26. <span style="color: #008080">26</span>     "‘<span style="color: #800080">$tname</span>‘,".<span style="color: #008000">//</span><span style="color: #008000">姓名</span>
  27. <span style="color: #008080">27</span>     "‘<span style="color: #800080">$tsex</span>‘,".<span style="color: #008000">//</span><span style="color: #008000">性别</span>
  28. <span style="color: #008080">28</span>     "‘<span style="color: #800080">$tbirthday</span>‘,".<span style="color: #008000">//</span><span style="color: #008000">生日</span>
  29. <span style="color: #008080">29</span>     "‘<span style="color: #800080">$prof</span>‘,".<span style="color: #008000">//</span><span style="color: #008000">职称</span>
  30. <span style="color: #008080">30</span>     "‘<span style="color: #800080">$depart</span>‘)"<span style="color: #000000">;
  31. </span><span style="color: #008080">31</span> }<span style="color: #0000ff">else</span> <span style="color: #0000ff">if</span>(<span style="color: #800080">$type</span> = "upda"<span style="color: #000000">){
  32. </span><span style="color: #008080">32</span>     <span style="color: #800080">$sql</span> = "update teacher set".
  33. <span style="color: #008080">33</span>     "tname = ‘<span style="color: #800080">$tname</span>‘,".
  34. <span style="color: #008080">34</span>     "tsex = ‘<span style="color: #800080">$tsex</span>‘,".
  35. <span style="color: #008080">35</span>     "tbirthday = ‘<span style="color: #800080">$tbirthday</span>‘,".
  36. <span style="color: #008080">36</span>     "prof = ‘<span style="color: #800080">$prof</span>‘,".
  37. <span style="color: #008080">37</span>     "prof = ‘<span style="color: #800080">$depart</span>‘,".
  38. <span style="color: #008080">38</span>     " where tno = ‘<span style="color: #800080">$tno</span>‘ "<span style="color: #000000">;
  39. </span><span style="color: #008080">39</span> <span style="color: #000000">}
  40. </span><span style="color: #008080">40</span> <span style="color: #008000">//</span><span style="color: #008000">执行SQL语句添加表格
  41. </span><span style="color: #008080">41</span> <span style="color: #008000">//所在系</span>
  42. <span style="color: #008080">42</span>     <span style="color: #800080">$result</span> = <span style="color: #800080">$db</span>->query(<span style="color: #800080">$sql</span>);<span style="color: #008000">//</span><span style="color: #008000">执行结果集
  43. </span><span style="color: #008080">43</span> <span style="color: #008000">//加载到主页面查看是否添加</span>
  44. <span style="color: #008080">44</span> <span style="color: #008080">header</span>("location:../indsert.php"<span style="color: #000000">);
  45. </span><span style="color: #008080">45</span> ?>
insert

效果图如下：

技术分享图片

php对数据库的增删改

标签：highlight   年月日   blog   .com   action   技术分享   引号   gpo   location   

人气教程排行

本站所有资源全部来源于网络，若本站发布的内容侵害到您的隐私或者利益，请联系我们删除！