当前位置：Gxlcms > 数据库问题 > php页面中实现对数据库的操作

php页面中实现对数据库的操作

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

//var_dump($_POST); $title = $_POST["title"]; $Author = $_POST["Author"]; $source = $_POST["source"]; $content = $_POST["content"]; $time = time(); $db = new MySQLi("localhost","root","123","newssystem"); $sql = "insert into news values(0,‘{$title}‘,‘{$Author}‘,‘{$source}‘,‘{$content}‘,now())"; echo $sql; $result = $db->query($sql); if($result){ echo "<script type=‘text/javascript‘>window.location.href=‘fabuxinwen.php‘;</script>"; }else{ echo "添加失败！"; }

 

　　在网页中显示数据库里面的内容：

  1. <span style="color: #008000">//</span><span style="color: #008000">首先在页面内添加一个表格，并设置列名</span>
  2. <table <span style="color: #0000ff">class</span>="table table-bordered">
  3.   <thead>
  4.     <tr>
  5.       <th>id</th>
  6.       <th>title</th>
  7.       <th>author</th>
  8.       <th>source</th>
  9.       <th><span style="color: #008080">date</span></th>
  10.       <th>update</th>
  11.       <th>delete</th>
  12.     </tr>
  13.   </thead>
  14. <span style="color: #008000">//</span><span style="color: #008000">表身内容为数据库存储的内容，对其进行展示</span>
  15.   <tbody>
  16.      <?<span style="color: #000000">php
  17.     </span><span style="color: #800080">$db</span> = <span style="color: #0000ff">new</span> MySQLi("localhost","root","123","newssystem"<span style="color: #000000">);
  18.     </span><span style="color: #800080">$sql</span> = "select * from news"<span style="color: #000000">;
  19.     </span><span style="color: #800080">$result</span> = <span style="color: #800080">$db</span>->query(<span style="color: #800080">$sql</span><span style="color: #000000">);
  20.     </span><span style="color: #0000ff">if</span>(<span style="color: #800080">$result</span><span style="color: #000000">){
  21.         </span><span style="color: #800080">$arr</span> = <span style="color: #800080">$result</span>-><span style="color: #000000">fetch_all();
  22.         </span><span style="color: #0000ff">foreach</span>(<span style="color: #800080">$arr</span> <span style="color: #0000ff">as</span> <span style="color: #800080">$v</span><span style="color: #000000">){
  23.             </span><span style="color: #0000ff">echo</span> "<span style="color: #000000"><tr>
  24.       <td>{</span><span style="color: #800080">$v</span><span style="color: #000000">[0]}</td>
  25.       <td>{</span><span style="color: #800080">$v</span><span style="color: #000000">[1]}</td>
  26.       <td>{</span><span style="color: #800080">$v</span><span style="color: #000000">[2]}</td>
  27.       <td>{</span><span style="color: #800080">$v</span><span style="color: #000000">[3]}</td>
  28.       <td>{</span><span style="color: #800080">$v</span><span style="color: #000000">[5]}</td>
  29.       <td>
  30.           <a href=‘xiugai.php?newsid={</span><span style="color: #800080">$v</span><span style="color: #000000">[0]}‘ ><button type=‘button‘ class=‘btn btn-primary btn-sm‘>修改</button></a>
  31.       </td>
  32.       <td>
  33.           <a href=‘shanchu.php?title={</span><span style="color: #800080">$v</span><span style="color: #000000">[1]}‘ onclick=\"return confirm(‘确认删除么？‘)\"><br>　　　　　　　　<button type=‘button‘ class=‘btn btn-primary btn-sm‘>删除</button><br>　　　　　　</a>
  34.       </td>
  35.     </tr></span>"<span style="color: #000000">;
  36.         }
  37.     }
  38.     </span>?>
  39.   </tbody>
  40. </table>

 

　　对数据进行删除：

  1. <?<span style="color: #000000">php
  2. </span><span style="color: #800080">$title</span> = <span style="color: #800080">$_GET</span>["title"<span style="color: #000000">];
  3. </span><span style="color: #800080">$db</span> = <span style="color: #0000ff">new</span> MySQLi("localhost","root","123","newssystem"<span style="color: #000000">);
  4. </span><span style="color: #800080">$sql</span> = "delete from news where title=‘{<span style="color: #800080">$title</span>}‘"<span style="color: #000000">;
  5. </span><span style="color: #800080">$result</span> = <span style="color: #800080">$db</span>->query(<span style="color: #800080">$sql</span><span style="color: #000000">);
  6. </span><span style="color: #0000ff">if</span>(<span style="color: #800080">$result</span><span style="color: #000000">){
  7.     </span><span style="color: #008080">header</span>("location:chakan.php"<span style="color: #000000">);
  8. }</span><span style="color: #0000ff">else</span><span style="color: #000000">{
  9.     </span><span style="color: #0000ff">echo</span> "删除失败！"<span style="color: #000000">;
  10. }</span>

　　　　如果实现批量删除：

　　　　　　首先在列表每一行最前面加上一个复选框：

  1.  <td><input type=‘checkbox‘ class=‘ck‘ name=‘ck[]‘ value=‘{$v[0]}‘/>{$v[0]}</td>

　　　　　　然后在列表列的最前面加入一个可以全选的复选框：

  1. <input type="checkbox" id="ckall" />

　　　　　　加入JS代码实现全选：

  1. <script type="text/javascript">
  2. <span style="color: #0000ff">var</span> ckall = document.getElementById("ckall"<span style="color: #000000">);
  3. ckall</span>.onclick = <span style="color: #0000ff">function</span><span style="color: #000000">(){
  4.     </span><span style="color: #0000ff">var</span> xz = ckall.<span style="color: #000000">checked;
  5.     </span><span style="color: #0000ff">var</span> ck = document.getElementsByClassName("ck"<span style="color: #000000">);
  6.     </span><span style="color: #0000ff">for</span>(<span style="color: #0000ff">var</span> i=0;i<ck.length;i++<span style="color: #000000">){
  7.         ck[i]</span>.checked =<span style="color: #000000"> xz; 
  8.     }
  9. }
  10. </span></script>

　　　　　　加入批量删除按钮，然后使其可以运行下一个页面的代码：

  1. <?<span style="color: #000000">php
  2. </span><span style="color: #800080">$arr</span> = <span style="color: #800080">$_POST</span>["ck"<span style="color: #000000">];
  3. </span><span style="color: #008000">//</span><span style="color: #008000">delete from info where code in(‘p001‘,‘p002‘,‘p003‘)</span>
  4. <span style="color: #800080">$str</span> = <span style="color: #008080">implode</span>("‘,‘",<span style="color: #800080">$arr</span><span style="color: #000000">);
  5. </span><span style="color: #800080">$sql</span> = "delete from info where code in(‘{<span style="color: #800080">$str</span>}‘)"<span style="color: #000000">;
  6. </span><span style="color: #800080">$db</span> = <span style="color: #0000ff">new</span> MySQLi("localhost","root","123","mydb"<span style="color: #000000">);
  7. </span><span style="color: #800080">$result</span> = <span style="color: #800080">$db</span>->query(<span style="color: #800080">$sql</span><span style="color: #000000">);
  8. </span><span style="color: #0000ff">if</span>(<span style="color: #800080">$result</span><span style="color: #000000">){
  9.     </span><span style="color: #008080">header</span>("location:main.php"<span style="color: #000000">);
  10. }</span><span style="color: #0000ff">else</span><span style="color: #000000">{
  11.     </span><span style="color: #0000ff">echo</span> "删除失败！"<span style="color: #000000">;
  12. }</span>

　　　　　　即可实现批量删除功能。

 

　　对数据修改（需要同时运用到添加和删除）：

　　　　首先先将要修改的数据展示出来：

  1. <span style="color: #008000">//</span><span style="color: #008000">在要展示的修改的页面加入一段php代码</span>
  2. <?<span style="color: #000000">php
  3. </span><span style="color: #008000">//</span><span style="color: #008000">取出主键值</span>
  4. <span style="color: #800080">$newsid</span> = <span style="color: #800080">$_GET</span>["newsid"<span style="color: #000000">];
  5. </span><span style="color: #008000">//</span><span style="color: #008000">读取该条数据</span>
  6. <span style="color: #800080">$db</span> = <span style="color: #0000ff">new</span> MySQLi("localhost","root","123","newssystem"<span style="color: #000000">);
  7. </span><span style="color: #800080">$sql</span> = "select * from news where newsid={<span style="color: #800080">$newsid</span>}"<span style="color: #000000">;
  8. </span><span style="color: #800080">$result</span> = <span style="color: #800080">$db</span>->query(<span style="color: #800080">$sql</span><span style="color: #000000">);
  9. </span><span style="color: #800080">$arr1</span> = <span style="color: #800080">$result</span>-><span style="color: #000000">fetch_row();
  10. </span>?>

　　　　然后在每一条数据内使其内容显示出来（给文本框赋值），如：<?php echo $arr1[0] ?>

　　　　在新建一个只有php的页面：

  1. <?<span style="color: #000000">php
  2. </span><span style="color: #800080">$newsid</span> = <span style="color: #800080">$_POST</span>["newsid"<span style="color: #000000">];
  3. </span><span style="color: #800080">$title</span> = <span style="color: #800080">$_POST</span>["title"<span style="color: #000000">];
  4. </span><span style="color: #800080">$Author</span> = <span style="color: #800080">$_POST</span>["Author"<span style="color: #000000">];
  5. </span><span style="color: #800080">$source</span> = <span style="color: #800080">$_POST</span>["source"<span style="color: #000000">];
  6. </span><span style="color: #800080">$content</span> = <span style="color: #800080">$_POST</span>["content"<span style="color: #000000">];
  7. </span><span style="color: #800080">$db</span> = <span style="color: #0000ff">new</span> MySQLi("localhost","root","123","newssystem"<span style="color: #000000">);
  8. </span><span style="color: #800080">$sql</span> = "update news set title=‘{<span style="color: #800080">$title</span>}‘,Author=‘{<span style="color: #800080">$Author</span>}‘,source=‘{<span style="color: #800080">$source</span>}‘,content=‘{<span style="color: #800080">$content</span>}‘ where newsid = {<span style="color: #800080">$newsid</span>}"<span style="color: #000000">;
  9. </span><span style="color: #800080">$result</span> = <span style="color: #800080">$db</span>->query(<span style="color: #800080">$sql</span><span style="color: #000000">);
  10. </span><span style="color: #0000ff">if</span>(<span style="color: #800080">$result</span><span style="color: #000000">){
  11.     </span><span style="color: #008080">header</span>("location:chakan.php"<span style="color: #000000">);
  12. }</span><span style="color: #0000ff">else</span><span style="color: #000000">{
  13.     </span><span style="color: #0000ff">echo</span> "修改失败！"<span style="color: #000000">;
  14. }</span>

 

php页面中实现对数据库的操作

标签：fetch   nts   str   sid   库存   header   全选   java   var   

人气教程排行

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