亚洲国产日韩欧美一区二区三区,精品亚洲国产成人av在线,国产99视频精品免视看7,99国产精品久久久久久久成人热,欧美日韩亚洲国产综合乱

搜索
博主信息
博文 64
粉絲 6
評論 2
訪問量 100652
最新下載
更多>
網(wǎng)站特效
網(wǎng)站源碼
網(wǎng)站素材
前端模板
php 數(shù)據(jù)庫操作mysqli
王嬌
原創(chuàng)
1587人瀏覽過

學(xué)習(xí)總結(jié)

  • mysqli連接的時候不需要type參數(shù)
  • mysqli執(zhí)行時只需要調(diào)用query()方法，返回個結(jié)果集
  • 但是如果使用mysqli連接數(shù)據(jù)庫時，如果更換數(shù)據(jù)庫引擎，則所有的方法都得進(jìn)行更改。

1.數(shù)據(jù)庫連接和增刪改查類DBconn.php

  1. <?php
  3. namespace compotents\conn
  4. {
  5.     use Exception;
  6.     use mysqli;
  7.     class DBconn
  8.     {
  9.         private $config = [];
  10.         protected $dbConn;
  11.         public function __construct($dbName = 'db_phpstudy',$userName = 'root',$passWord ='root')
  12.         {
  13.             $this ->config['type'] = 'mysql';
  14.             $this ->config['host'] = 'localhost';
  15.             $this ->config['dbName'] = $dbName;
  16.             $this ->config['userName'] = $userName;
  17.             $this ->config['passWord'] = $passWord;
  18.             $this ->config['charSet'] = 'utf8';
  19.             $this ->config['port'] = '3306';
  20.             $this ->connect();
  22.         }
  23.         public function connect()
  24.         {
  25.             //拆分?jǐn)?shù)組，鍵名當(dāng)做變量名，值當(dāng)做變量的值,拆分成數(shù)據(jù)庫連接的變量
  26.            extract($this->config,EXTR_PREFIX_SAME,'config');
  27.            try
  28.            {
  29.                //1.創(chuàng)建一個mysqli的數(shù)據(jù)庫連接
  30.                $this->dbConn = new mysqli($host,$userName,$passWord,$dbName);
  31.                //2. 判斷是否連接成功?
  32.                 if ($this->dbConn->connect_errno) echo $this->dbConn->connect_error;
  33.                //3.設(shè)置數(shù)據(jù)庫連接的字符集
  34.                $this->dbConn->set_charset($charSet);
  35.            }
  36.            catch(Exception $e)
  37.            {
  38.                 die($e->getMessage());
  39.            }
  40.         }
  42.         //查詢返回查詢結(jié)果集
  43.         public function select($table,$where)
  44.         {
  45.             if ($where === '*'):
  46.                 $sql = "SELECT * FROM `$table`";
  47.             else:
  48.                 $sql = "SELECT * FROM `$table` WHERE $where";
  49.             endif;
  51.             $info = $this ->dbConn->query($sql);
  52.             $records = $info->fetch_all(MYSQLI_ASSOC);
  53.             return $records;
  54.         }
  55.         //插入記錄，輸出是否成功添加記錄
  56.         public function insert($table,$insData)
  57.         {
  58.             //把傳入的添加數(shù)據(jù)的數(shù)組轉(zhuǎn)換為一個SQL添加字符串
  59.             $insertSet = $this->toSqlStr($insData);
  61.             $sql = "INSERT `$table` SET $insertSet";
  62.             $flag =  $this->dbConn->query($sql);
  63.             $rowCount = $this->dbConn->affected_rows;//返回受影響的記錄數(shù)
  64.             if ($flag) {
  65.                 //$this->dbConn->insert_id返回最后一條插入語句的自增id
  66.                 if ($rowCount > 0) {
  67.                     echo '成功添加了 ' . $rowCount . ' 條記錄, 新增記錄主鍵ID: ' . $this->dbConn->insert_id;
  68.                 } else {
  69.                     echo '沒有添加新記錄';
  70.                 }
  71.             } else {
  72.                 //$this->dbConn->errno返回最近函數(shù)調(diào)用的錯誤代碼
  73.                 //$this->dbConn->error返回最后一次調(diào)用的錯誤信息
  74.                 die('添加失敗'. $this->dbConn->errno . ' : ' . $this->dbConn->error);
  75.             }
  76.         }
  77.         //更新記錄，輸出更新幾條記錄
  78.         public function update($table,$data,$where)
  79.         {
  80.             //把傳入的添加數(shù)據(jù)的數(shù)組轉(zhuǎn)換為一個SQL添加字符串
  81.             $updateSet = $this->toSqlStr($data);   
  82.             $sql = "UPDATE `$table` SET $updateSet WHERE $where";
  83.             $flag =  $this->dbConn->query($sql);
  84.             $rowCount = $this->dbConn->affected_rows;//返回受影響的記錄數(shù)
  85.             if ($flag) {
  86.                 //$this->dbConn->insert_id返回最后一條插入語句的自增id
  87.                 if ($rowCount > 0) {
  88.                     echo '成功更新了 ' . $rowCount . ' 條記錄';
  89.                 } else {
  90.                     echo '沒有更新記錄';
  91.                 }
  92.             } else {
  93.                 //$this->dbConn->errno返回最近函數(shù)調(diào)用的錯誤代碼
  94.                 //$this->dbConn->error返回最后一次調(diào)用的錯誤信息
  95.                 die('更新失敗'. $this->dbConn->errno . ' : ' . $this->dbConn->error);
  96.             }
  98.         }
  99.         //刪除記錄，輸出是否刪除成功
  100.         public function delete($table,$where)
  101.         {
  102.             $sql = "DELETE FROM $table WHERE $where";
  103.             $flag =  $this->dbConn->query($sql);
  104.             $rowCount = $this->dbConn->affected_rows;//返回受影響的記錄數(shù)
  105.             if ($flag) {
  106.                 //$this->dbConn->insert_id返回最后一條插入語句的自增id
  107.                 if ($rowCount > 0) {
  108.                     echo '成功刪除了 ' . $rowCount . ' 條記錄';
  109.                 } else {
  110.                     echo '沒有刪除記錄';
  111.                 }
  112.             } else {
  113.                 //$this->dbConn->errno返回最近函數(shù)調(diào)用的錯誤代碼
  114.                 //$this->dbConn->error返回最后一次調(diào)用的錯誤信息
  115.                 die('刪除失敗'. $this->dbConn->errno . ' : ' . $this->dbConn->error);
  116.             }
  117.         }
  118.         public function toSqlStr($arr):string
  119.         {
  120.             //把數(shù)組的鍵提取到一個數(shù)組中
  121.             $keys = array_keys($arr);
  122.             //把數(shù)組的值提取到一個數(shù)組中
  123.             $value = array_values($arr);
  125.             $con = count($keys);
  126.             $sqlStr ='';
  127.             for ($i=0;$i<$con;$i++):
  128.                 if($i===$con-1):
  129.                     $sqlStr .= " `$keys[$i]`='$value[$i]'";
  130.                 else:
  131.                     $sqlStr .= " `$keys[$i]`='$value[$i]' ,";
  132.                 endif;   
  133.             endfor; 
  134.             return $sqlStr;
  135.         }
  136.     }
  137. }
  138. ?>

2.后臺首頁index.html

  2. <!DOCTYPE html>
  3. <html lang="en">
  5. <head>
  6.     <meta charset="UTF-8">
  7.     <meta name="viewport" content="width=device-width, initial-scale=1.0">
  8.     <link rel="stylesheet" href="style/style.css">
  9.     <title>商品后臺管理</title>
  10. </head>
  12. <body>
  13.     <div class="container">
  14.         <div class="row">
  15.             <div class="header col-12">
  16.                 <span>商品后臺管理</span>
  17.                 <div><a href="">返回首頁</a> </div>
  18.                 <div><a href="">退出</a></div>
  19.             </div>
  20.         </div>
  21.         <div class="row">
  22.             <div class="aside col-3">
  23.                 <div><a href="select.php" target="main"><span>查詢商品</span> </a></div>
  24.                 <div><a href="insert.php" target="main"><span>添加商品</span> </a></div>
  25.                 <div><a href="update.php" target="main"><span>修改商品</span> </a></div>
  26.                 <div><a href="delete.php" target="main"><span>刪除商品</span> </a></div>
  28.             </div>
  29.             <div class="main col-9">
  30.                 <iframe src="select.php" frameborder="0" name="main" width="680px" height="510px"></iframe>
  31.             </div>
  32.         </div>
  33.         <div class="row">
  34.             <div class="footer col-12">
  35.                 <div>聯(lián)系郵箱：<a href="mailto:573661083@qq.com">573661083@qq.com</a></div>
  36.                 <div>聯(lián)系電話：<a href="tel:15010046927">1501004xxxx</a></div>
  37.                 <div>Copyright 1998 - 2020 Tencent. All Rights Reserved</div>
  38.             </div>
  39.         </div>
  41.     </div>
  42. </body>
  44. </html>

3.首頁樣式表 style.css

  2. @import "reset.css";
  4. /* 整頁布局 */
  5. .container {
  6.   max-width: 920px;
  7.   min-height: 650px;
  8.   margin-left: auto;
  9.   margin-right: auto;
  10.   background-color: white;
  11.   display: grid;
  12.   gap: 5px;
  13. }
  14. /* 整頁中的每行分成12列 */
  15. .container > .row {
  16.   display: grid;
  17.   grid-template-columns: repeat(12, 1fr);
  18.   gap: 5px;
  19. }
  20. /* 頭部布局 */
  21. .container > .row > .header {
  22.   margin-top: 5px;
  23.   background-color: #58c4f2;
  24.   max-height: 56px;
  25.   border-radius: 3px;
  26.   padding: 0px 10px;
  27.   display: flex;
  28.   flex-flow: row nowrap;
  29.   align-items: center;
  30. }
  31. .container > .row > .header > span {
  32.   letter-spacing: 2px;
  33.   margin-left: 20px;
  34.   font-size: 1.5rem;
  35.   font-weight: bolder;
  36. }
  37. .container > .row > .header > div > a {
  38.   margin: 0px 10px;
  39. }
  40. .container > .row > .header > div > a:hover {
  41.   color: lightgreen;
  42. }
  43. .container > .row > .header > div:nth-of-type(1) {
  44.   margin-left: auto;
  45. }
  47. /* 側(cè)邊欄  */
  48. .container > .row > .aside {
  49.   min-height: 500px;
  50.   background-color: #ccc;
  51.   border-radius: 3px;
  52.   display: flex;
  53.   flex-flow: column nowrap;
  54.   padding: 5px;
  55. }
  56. /* 側(cè)邊欄導(dǎo)航 */
  57. .container > .row > .aside > div {
  58.   background-color: #58c4f2;
  59.   height: 40px;
  60.   margin: 2px 8px;
  61.   border-radius: 10px;
  62. }
  63. .container > .row > .aside > div > a {
  64.   width: 100%;
  65.   height: 100%;
  66.   display: flex;
  67.   justify-content: center;
  68.   align-items: center;
  69. }
  70. .container > .row > .aside > div > a > span {
  71.   font-size: 1.2rem;
  72.   letter-spacing: 2px;
  73. }
  75. .container > .row > .aside > div:hover {
  76.   background-color: lightgreen;
  77.   box-shadow: 0 0 5px #555;
  78. }
  79. /* 主體內(nèi)容顯示區(qū) */
  80. .container > .row > .main {
  81.   min-height: 500px;
  82. }
  83. /* 頁腳 */
  84. .container > .row > .footer {
  85.   max-height: 80px;
  86.   margin-bottom: 5px;
  87.   background-color: #58c4f2;
  88.   border-radius: 3px;
  89.   display: flex;
  90.   flex-flow: column nowrap;
  91.   justify-content: center;
  92.   align-items: center;
  93. }
  94. .container > .row > .footer > div > a:hover {
  95.   color: lightgreen;
  96. }
  97. /* 12列柵格布局 */
  98. .col-1 {
  99.   grid-column-end: span 1;
  100. }
  101. .col-2 {
  102.   grid-column-end: span 2;
  103. }
  104. .col-3 {
  105.   grid-column-end: span 3;
  106. }
  107. .col-4 {
  108.   grid-column-end: span 4;
  109. }
  110. .col-5 {
  111.   grid-column-end: span 5;
  112. }
  113. .col-6 {
  114.   grid-column-end: span 6;
  115. }
  116. .col-7 {
  117.   grid-column-end: span 7;
  118. }
  119. .col-8 {
  120.   grid-column-end: span 8;
  121. }
  122. .col-9 {
  123.   grid-column-end: span 9;
  124. }
  125. .col-10 {
  126.   grid-column-end: span 10;
  127. }
  128. .col-11 {
  129.   grid-column-end: span 11;
  130. }
  131. .col-12 {
  132.   grid-column-end: span 12;
  133. }

4.前端綜合處理handle.php

  2. <?php
  3. require 'autoLoad.php';
  5. use compotents\conn\DBconn;
  7. $user =new  DBconn();
  8. $table = 'tb_goods';//表名
  9. $where =''; //判斷的條件
  10. $data =[];//添加或者更新的數(shù)據(jù)
  12. $action = $_GET['action'];
  13. switch ($action)
  14. {
  15.     case 'insert':
  16.         $name = $_POST['goodsName'];
  17.         $price = $_POST['goodsPrice'];
  18.         $unit = $_POST['goodsUnit'];
  19.         $date = $_POST['goodsSdate'];
  20.         $data = ['name'=>"$name",'price'=>"$price",'unit'=>"$unit",'sdate'=>"$date"];
  21.         $user->insert($table,$data);
  22.     break;
  23.     case 'update':
  24.         $id = $_GET['id'];
  25.         $name = $_POST['goodsName'];
  26.         $price = $_POST['goodsPrice'];
  27.         $unit = $_POST['goodsUnit'];
  28.         $sdate = $_POST['goodSdate'];
  30.         $where = "`id`=$id";
  31.         $data = ['name'=>"$name",'price'=>"$price",'unit'=>"$unit",'sdate'=>"$sdate"];
  32.         $user->update($table,$data,$where);
  33.     break;
  34.     case 'delete':
  35.         $id = $_GET['id'];
  36.         $where = "`id`=$id";
  37.         $user->delete($table,$where);
  38.     break;
  39.     default:
  40.         echo '不支持此操作';
  41. }
  43. ?>

5.查詢商品select.php

  2. <!DOCTYPE html>
  3. <html lang="en">
  5. <head>
  6.     <meta charset="UTF-8">
  7.     <meta name="viewport" content="width=device-width, initial-scale=1.0">
  8.     <link rel="stylesheet" href="style/select.css">
  9.     <title>商品查詢頁</title>
  10. </head>
  12. <body>
  13.     <div class="show">
  14.         <div class="row">
  15.             <div>商品編號</div>
  16.             <div>商品名稱</div>
  17.             <div>商品價(jià)格</div>
  18.             <div>上架時間</div>
  19.         </div>
  20.         <?php
  21.             require 'autoLoad.php';
  22.             use compotents\conn\DBconn;
  23.             $user =new  DBconn();
  24.             $table = 'tb_goods';//表名
  25.             $where ='*'; //判斷的條件 如果選擇所有數(shù)據(jù)則為*
  26.             //顯示所有用戶信息
  27.             $records = $user->select($table,$where);
  28.             foreach($records as $res):
  29.         ?>
  30.         <div class="row">
  31.             <div><?php echo $res['id']; ?></div>
  32.             <div><?php echo $res['name']; ?></div>
  33.             <div><?php echo $res['price'],'元/',$res['unit']; ?></div>
  34.             <div><?php echo $res['sdate']; ?></div>
  35.         </div>
  36.         <?php
  37.             endforeach;
  38.         ?>
  39.     </div>
  40. </body>
  42. </html>
  • 查詢效果圖

5.添加商品insert.php

  2. <!DOCTYPE html>
  3. <html lang="en">
  5. <head>
  6.     <meta charset="UTF-8" />
  7.     <meta name="viewport" content="width=device-width, initial-scale=1.0" />
  8.     <link rel="stylesheet" href="style/insert.css" />
  9.     <title>商品添加頁</title>
  10. </head>
  12. <body>
  13.     <div class="add">
  14.         <h2>商品添加</h2>
  15.         <form action="handle.php?action=insert" method="POST">
  16.             <div>
  17.                 <label for="goodsName">商品名稱：</label>
  18.                 <input type="text" name="goodsName" placeholder="商品名稱不能為空" require />
  19.             </div>
  20.             <div>
  21.                 <label for="goodsPrice">商品單價(jià)：</label>
  22.                 <input type="text" name="goodsPrice" placeholder="輸入商品價(jià)格" />
  23.             </div>
  24.             <div>
  25.                 <label for="goodsUnit">商品單位：</label>
  26.                 <select name="goodsUnit" id="goodsUnit">
  27.                     <option value="斤" selected>斤</option>
  28.                     <option value="盒">盒</option>
  29.                     <option value="袋">袋</option>
  30.                     <option value="捆">捆</option>
  31.                     <option value="筐">筐</option>
  32.                     <option value="箱">箱</option>
  33.                     <option value="桶">桶</option>
  34.                 </select>
  35.             </div>
  36.             <div>
  37.                 <label for="goodsSdate">上架時間：</label>
  38.                 <input type="date" name="goodsSdate" id="goodsSdate" value="<?php echo date('Y-m-d'); ?>" />
  39.             </div>
  40.             <div>
  41.                 <button type="submit">添加</button>
  42.             </div>
  43.         </form>
  44.     </div>
  45. </body>
  47. </html>

  • 添加商品

  • 添加成功

5.修改商品update.php

  2. <!DOCTYPE html>
  3. <html lang="en">
  5. <head>
  6.     <meta charset="UTF-8">
  7.     <meta name="viewport" content="width=device-width, initial-scale=1.0">
  8.     <link rel="stylesheet" href="style/select.css">
  9.     <title>商品修改頁</title>
  10. </head>
  12. <body>
  13.     <div class="show">
  14.         <div class="row">
  15.             <div>商品編號</div>
  16.             <div>商品名稱</div>
  17.             <div>價(jià)格/單位</div>
  18.             <div>上架時間</div>
  19.             <div>更新操作</div>
  20.         </div>
  21.         <?php
  22.             require 'autoLoad.php';
  23.             use compotents\conn\DBconn;
  24.             $user =new  DBconn();
  25.             $table = 'tb_goods';//表名
  26.             $where ='*'; //判斷的條件 如果選擇所有數(shù)據(jù)則為*
  27.             //顯示所有用戶信息
  28.             $records = $user->select($table,$where);
  29.             foreach($records as $res):
  30.         ?>
  31.         <div class="row">
  32.             <form action="handle.php?action=update&id=<?php echo $res['id']; ?>" method="POST">
  33.                 <div style="width:100px"><?php echo $res['id']; ?></div>
  34.                 <input type="text" name="goodsName" id="goodsName" style="width:120px"
  35.                     value="<?php echo $res['name']; ?>">
  36.                 <div>
  37.                     <input type="text" name="goodsPrice" id="goodsPrice" style="width:50px"
  38.                         value="<?php echo $res['price']; ?>">/
  39.                     <input type="text" name="goodsUnit" id="goodsUnit" style="width:50px"
  40.                         value="<?php echo $res['unit']; ?>">
  41.                 </div>
  42.                 <input type="date" name="goodSdate" id="goodSdate" style="width:120px"
  43.                     value="<?php echo $res['sdate']; ?>">
  44.                 <div style="width:120px"><button type="submit">修改</button></div>
  45.             </form>
  46.         </div>
  47.         <?php
  48.             endforeach;
  49.         ?>
  50.     </div>
  51. </body>
  53. </html>

  • 修改商品

  • 修改成功

5.刪除商品delete.php

  2. <!DOCTYPE html>
  3. <html lang="en">
  5. <head>
  6.     <meta charset="UTF-8">
  7.     <meta name="viewport" content="width=device-width, initial-scale=1.0">
  8.     <link rel="stylesheet" href="style/select.css">
  9.     <title>商品刪除頁</title>
  10. </head>
  12. <body>
  13.     <div class="show">
  14.         <div class="row">
  15.             <div>商品編號</div>
  16.             <div>商品名稱</div>
  17.             <div>商品價(jià)格</div>
  18.             <div>上架時間</div>
  19.             <div>刪除操作</div>
  20.         </div>
  21.         <?php
  22.             require 'autoLoad.php';
  23.             use compotents\conn\DBconn;
  24.             $user =new  DBconn();
  25.             $table = 'tb_goods';//表名
  26.             $where ='*'; //判斷的條件 如果選擇所有數(shù)據(jù)則為*
  27.             //顯示所有用戶信息
  28.             $records = $user->select($table,$where);
  29.             foreach($records as $res):
  30.         ?>
  31.         <div class="row">
  32.             <div><?php echo $res['id']; ?></div>
  33.             <div><?php echo $res['name']; ?></div>
  34.             <div><?php echo $res['price'],'元/',$res['unit']; ?></div>
  35.             <div><?php echo $res['sdate']; ?></div>
  36.             <div><a href="handle.php?action=delete&id=<?php echo $res['id']; ?>">刪除</a></div>
  37.         </div>
  38.         <?php
  39.             endforeach;
  40.         ?>
  41.     </div>
  42. </body>
  44. </html>

  • 刪除商品

  • 刪除成功

批改老師：天蓬老師天蓬老師

批改狀態(tài)：合格

老師批語：不錯 就差一個分頁了
本博文版權(quán)歸博主所有，轉(zhuǎn)載請注明地址！如有侵權(quán)、違法，請聯(lián)系admin@php.cn舉報(bào)處理！
全部評論 文明上網(wǎng)理性發(fā)言，請遵守新聞評論服務(wù)協(xié)議
0條評論
關(guān)于我們 免責(zé)申明 意見反饋 講師合作 廣告合作 最新更新
php中文網(wǎng)：公益在線php培訓(xùn)，幫助PHP學(xué)習(xí)者快速成長！
關(guān)注服務(wù)號 技術(shù)交流群
PHP中文網(wǎng)訂閱號
每天精選資源文章推送
PHP中文網(wǎng)APP
隨時隨地碎片化學(xué)習(xí)
PHP中文網(wǎng)抖音號
發(fā)現(xiàn)有趣的

Copyright 2014-2025 http://ipnx.cn/ All Rights Reserved | php.cn | 湘ICP備2023035733號

    • 登錄PHP中文網(wǎng)，和優(yōu)秀的人一起學(xué)習(xí)！
    全站2000+教程免費(fèi)學(xué)