標籤：val else 頁面 庫存 uga 顯示 charset 個數 localhost
第一步
1 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> 2 <html xmlns="http://www.w3.org/1999/xhtml"> 3 <head> 4 <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> 5 <title>無標題文檔</title> 6 </head> 7 8 <body> 9 <h1>水果資訊表</h1>10 <table width="100%" border="1" cellpadding="0" cellpadding="0">11 <tr>12 <td>代號</td>13 <td>名稱</td>14 <td>價格</td>15 <td>產地</td>16 <td>庫存</td>17 <td>刪除</td>18 </tr>19 20 <?php21 //1.造連結化物件22 $db = new MySQLi("localhost","root","511108","text");23 //2.寫SQL語句24 $sql = "select*from fruit";25 //3.執行26 $result = $db->query($sql);27 //4.讀取資料(有兩種方法)28 //1.方法29 /*$attr = $result->fetch_all();30 foreach($attr as $v)31 {32 echo"<tr><td>{$v[0]}</td><td>{$v[1]}</td><td>{$v[2]}</td><td>{$v[3]}</td><td>{$v[4]}</td></tr>";33 34 }*/35 //2.方法36 while($attr = $result->fetch_row())37 {38 echo "<tr><td>{$attr[0]}</td><td>{$attr[1]}</td><td>{$attr[2]}</td><td>{$attr[3]}</td><td>{$attr[4]}</td><td>39 <a href=‘shanchu.php?code={$attr[0]}‘onclick=\"return confirm(‘確定刪除嗎‘)\">刪除40 </a>41 42 <a href=‘xiugai.php?code={$attr[0]}‘>修改</a> //再加個a標籤目的是修改表裡面的資料43 44 </td></tr>";45 46 }47 48 49 ?>50 </table>51 52 <a href="tianjiashuiguo.php">添加資料</a>53 54 </body>55 <script type="text/javascript"></script>56 </html>
綠字標記那是加個修改的a標籤下面是
下面是修改
第二步
1 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> 2 <html xmlns="http://www.w3.org/1999/xhtml"> 3 <head> 4 <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> 5 <title>無標題文檔</title> 6 </head> 7 8 <body> 9 <h1>修改水果</h1>10 <form action="xiugaichuli.php" method="post">11 <div>代號：<input type="hidden" name="ids" /></div><!--代號不讓使用者改,hidden有隱藏效果-->12 <div>名稱：<input type="text" name="name" /></div>13 <div>價格：<input type="text" name="price" /></div>14 <div>產地：<input type="text" name="source" /></div>15 <div>庫存：<input type="text" name="numbers" /></div>16 <div><input type="submit" value="修改" /></div>17 </form>18 19 20 </body>21 </html>
hidden的效果代號框隱藏吧
修改水果表單頁如下
1 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> 2 <html xmlns="http://www.w3.org/1999/xhtml"> 3 <head> 4 <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> 5 <title>無標題文檔</title> 6 </head> 7 8 <body> 9 <h1>修改水果表單頁</h1>10 <?php11 $code = $_GET["code"];//取到cade主索引值。去查詢資料12 //造連結化物件13 $db = new MySQLi("localhost","root","511108","text");14 //寫SQL語句15 $sql = "select * from fruit where ids=‘{$code}‘";//根據主鍵查fruit表的ids主鍵代號查詢內容16 //執行17 $result = $db->query($sql);18 //取資料19 $attr = $result->fetch_row();//根據主索引值去查查出的只有一條資料，知道只有一條資料可以直接調$result->fetch_row()它會返回一個第一條資料的數組，一維數組。20 //下一步要把$attr這個資料顯示在當前頁面在主鍵代號ids後面用value 嵌入<?php代碼，輸出echo $attr[0]就是代號21 22 23 ?>24 <form action="xiugaichuli.php" method="post">25 <input type="hidden" name="ids" value="<?php echo $attr[0] ?>" /><!--代號不讓使用者改,hidden-->26 <div>名稱：<input type="text" name="name" value="<?php echo $attr[1] ?>" /></div>27 <div>價格：<input type="text" name="price" value="<?php echo $attr[2] ?>" /></div>28 <div>產地：<input type="text" name="source" value="<?php echo $attr[3] ?>" /></div>29 <div>庫存：<input type="text" name="numbers" value="<?php echo $attr[4] ?>" /></div>30 <div><input type="submit" value="修改" /></div>31 </form>32 </body>33 </html>
在每個代號後面添加value="<?php echo $attr[0] ?>每一個文版框裡都有預設值效果如下
點擊修改處理頁
第三步
1 點擊修改處理頁 2 <?php 3 $ids = $_POST["ids"]; 4 $name = $_POST["name"]; 5 $price = $_POST["price"]; 6 $source = $_POST["source"]; 7 $numbers = $_POST["numbers"]; 8 //造連結化物件 9 $db = new MySQLi("localhost","root","511108","text");10 //寫SQL語句下面是一條修改語句11 //價格price={$price}是整數就不用單引號。庫存量numbers={$numbers}也是整數不需要單引號。修改傳遞過來的主鍵where ids=‘{$ids}‘12 $sql = "update fruit set name=‘{$name}‘,price={$price},source=‘{$source}‘,numbers={$numbers} where ids=‘{$ids}‘";13 //執行14 $r = $db->query($sql);15 if($r)16 {17 header("location:pingguoxinxi.php");//跳轉到首頁面18 }19 else20 {21 echo "修改失敗！"; 22 }
運行效果如1，圖2
圖1圖2
php後台增加刪除修改跳轉。
Start building with 50+ products and up to 12 months usage for Elastic Compute Service
1 on 1 presale consultation
24/7 Technical Support 6 Free Tickets per Quarter Faster Response
Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.
A comprehensive suite of global cloud computing services to power your business
Payment Methods We Support
