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

搜索
博主信息
博文 64
粉絲 6
評論 2
訪問量 100620
最新下載
更多>
網(wǎng)站特效
網(wǎng)站源碼
網(wǎng)站素材
前端模板
laravel 使用數(shù)據(jù)庫查詢構(gòu)造器實現(xiàn)數(shù)據(jù)的增刪改查，頁面的渲染，中間件的使用
王嬌
原創(chuàng)
1139人瀏覽過

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

  • 使用laravel中的查詢構(gòu)造器，也就是鏈?zhǔn)秸{(diào)用，實現(xiàn)數(shù)據(jù)庫中數(shù)據(jù)的增刪改查，方便且高效
  • 中間件的注冊和使用，可以很方便的解決用戶操作的控制

1.路由 web.php

  2. <?php
  4. use Illuminate\Support\Facades\Route;
  6. /*
  7. |--------------------------------------------------------------------------
  8. | Web Routes
  9. |--------------------------------------------------------------------------
  10. |
  11. | Here is where you can register web routes for your application. These
  12. | routes are loaded by the RouteServiceProvider within a group which
  13. | contains the "web" middleware group. Now create something great!
  14. |
  15. */
  17. //get方法的第一個參數(shù)'/'代表網(wǎng)站的入口地址，第二個參數(shù)訪問的是app/http/controllers/home下的indexCon控制器的index方法
  18. Route::get('/', 'home\indexCon@index');
  20. //get方法的第一個參數(shù)'/home/article'訪問地址為backstage.com/goods，第二個參數(shù)訪問的是app/http/controllers/home下的goodsCon控制器的index方法
  21. Route::get('/goods','home\goodsCon@index');
  23. //添加商品
  24. Route::get('/goods/add','home\goodsCon@addGoods');
  26. Route::post('goods/add/detail','home\goodsCon@addDetail');
  28. //刪除商品
  29. Route::get('/goods/del/{id}','home\goodsCon@delGoods');
  31. //更新商品
  32. Route::get('/goods/update/{id}','home\goodsCon@updateGoods')->middleware('checkLogin');
  34. Route::post('/goods/update/detail','home\goodsCon@updateDetail')->middleware('checkLogin');

2.goodsCon控制器

  2. <?php
  4. namespace App\Http\Controllers\home;
  6. use App\Http\Controllers\Controller;
  7. use Illuminate\Http\Request;
  8. use DB;
  10. class goodsCon extends Controller
  11. {
  12.     //
  13.     public function index()
  14.     {
  15.        return $this->showGoods();
  16.     }
  18.     //顯示商品頁面
  19.     public function showGoods()
  20.     {
  21.         // $res = DB::select('select * from tb_goods');
  23.         // return view('home/goods',['res'=>$res]);
  25.         $cateids = DB::table('tb_goodscate')->select()->get()->all();
  27.         $goods = DB::table('tb_goods')->orderby('id','asc')->get()->all();
  29.         return view('home/goods',['res'=>$goods,'cates'=>$cateids]);
  30.     }
  32.     //顯示添加商品頁面
  33.     public function addGoods(Request $request)
  34.     {
  35.     //     $date = date('Y-m-d');
  36.     //    $res = DB::insert("insert into `tb_goods` (`name`,`price`,`unit`,`sdate`) values ('黃桃','10','斤','$date') ");
  37.     //     echo $res;
  38.         $res = DB::table('tb_goodscate')->select()->get()->all();
  39.         return view('home/addGoods',['cates'=>$res]);
  41.     }
  43.     //執(zhí)行添加商品操作
  44.     public function addDetail()
  45.     {
  46.         $cateid = $_POST['gCate'];
  47.         $name = $_POST['gName'];
  48.         $price = $_POST['gPrice'];
  49.         $unit = $_POST['gUnit'];
  50.         $sdate = $_POST['gSdate'];
  51.         $insertId = DB::table('tb_goods')->insertGetId([
  52.             'cate_id'=>"$cateid",
  53.             'name'=>"$name",
  54.             'price'=>"$price",
  55.             'unit'=>"$unit",
  56.             'sdate'=>"$sdate"
  58.         ]);
  59.         echo $insertId;
  60.         return redirect('/goods');
  61.     }
  63.     //刪除商品
  64.     public function delGoods($id)
  65.     {
  66.         // $res =  DB::delete('delete from tb_goods where id>22');
  67.         // echo $res;
  68.         $res = DB::table('tb_goods')->where('id',$id)->delete();
  69.         return redirect('/goods');
  70.     }
  72.     //顯示更新商品頁面
  73.     public function updateGoods($id)
  74.     {
  75.         $cateids = DB::table('tb_goodscate')->select()->get()->all();
  77.         $goods = DB::table('tb_goods')->where('id',$id)->select()->get()->first();
  79.         return view('home/updateGoods',['res'=>$goods,'cates'=>$cateids]);
  80.     //    $res = DB::update('update tb_goods set name="西瓜" where id="22"');
  81.     //     echo $res;
  82.     }
  84.     //執(zhí)行更新商品操作
  85.     public function updateDetail()
  86.     {
  87.         $id = $_POST['gId'];
  88.         $cateid = $_POST['gCate'];
  89.         $name = $_POST['gName'];
  90.         $price = $_POST['gPrice'];
  91.         $unit = $_POST['gUnit'];
  92.         $sdate = $_POST['gSdate'];
  93.         $res = DB::table('tb_goods')->where('id',"$id")->update([
  94.             'cate_id'=>"$cateid",
  95.             'name'=>"$name",
  96.             'price'=>"$price",
  97.             'unit'=>"$unit",
  98.             'sdate'=>"$sdate"
  100.         ]);
  101.         return redirect('/goods');
  102.     }
  104. }

3.前端頁面

3.1商品顯示頁面goods.blade.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.     <title>前臺商品展示頁</title>
  9.     <link rel="stylesheet" href="layui/css/layui.css">
  10.     <script src="layui/layui.js"></script>
  11. </head>
  12. <style>
  13. body>div:first-of-type {
  14.     width: 100%;
  15.     margin: 30px 0px;
  16. }
  18. body>div:first-of-type>h2 {
  19.     width: 120px;
  20.     letter-spacing: 1px;
  21.     margin-left: auto;
  22.     margin-right: auto;
  24. }
  25. </style>
  27. <body>
  28.     <div>
  29.         <h2>商品展示頁</h2>
  30.     </div>
  31.     <div>
  32.         <button class="layui-btn addBtn">添加商品</button>
  33.     </div>
  34.     <table class="layui-table">
  35.         <thead>
  36.             <tr>
  37.                 <td>商品編號</td>
  38.                 <td>商品名稱</td>
  39.                 <td>商品類別</td>
  40.                 <td>商品單價</td>
  41.                 <td>商品單位</td>
  42.                 <td>發(fā)布日期</td>
  43.                 <td>操作</td>
  44.             </tr>
  45.         </thead>
  46.         <tbody>
  47.             @foreach($res as $goods)
  48.             <tr>
  49.                 <td><?php echo $goods->id;?></td>
  50.                 <td><?php echo $goods->name;?></td>
  51.                 @foreach($cates as $cate)
  52.                 @if($goods->cate_id===$cate->id)
  53.                 <td>{{$cate->name}}</td>
  54.                 @break;
  55.                 @endif
  56.                 @endforeach
  57.                 <td><?php echo $goods->price;?></td>
  58.                 <td><?php echo $goods->unit;?></td>
  59.                 <td><?php echo $goods->sdate;?></td>
  60.                 <td>
  61.                     <button data-index=<?php echo $goods->id;?> class="layui-btn updateBtn">修改</button>
  62.                     <button data-index=<?php echo $goods->id;?> class="layui-btn delBtn">刪除</button>
  63.                 </td>
  64.             </tr>
  65.             @endforeach
  66.         </tbody>
  67.     </table>
  68. </body>
  70. <script>
  71. //因為layui中的layer依賴jquery
  72. layui.use(['layer'], function() {
  73.     var $ = layui.jquery;
  74.     $('.addBtn').click(function() {
  75.         window.location.href = '/goods/add';
  76.     });
  77.     $('.updateBtn').click(function(ev) {
  78.         //當(dāng)前是第幾條記錄的更新操作
  79.         var uId = $(ev.target).attr('data-index');
  80.         window.location.href = '/goods/update/' + uId;
  81.     });
  82.     $('.delBtn').click(function(ev) {
  83.         var dId = $(ev.target).attr('data-index');
  84.         if (confirm('確認(rèn)刪除該記錄？')) {
  85.             window.location.href = '/goods/del/' + dId;
  86.         }
  88.     })
  89. });
  90. </script>
  93. </html>
  • 頁面效果

3.2添加商品頁面addGoods.blade.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="../../layui/css/layui.css">
  9.     <script src="../../layui/layui.js"></script>
  10.     <title>添加商品</title>
  11. </head>
  12. <style>
  13. .main {
  14.     width: 100%;
  15.     height: 400px;
  16.     display: flex;
  17.     flex-flow: column nowrap;
  18.     justify-content: space-evenly;
  19.     align-items: center;
  20. }
  21. </style>
  23. <body>
  24.     <div class="main">
  25.         <div>
  26.             <h2>添加商品</h2>
  27.         </div>
  28.         <form class="layui-form" method="POST" action="add/detail">
  29.             <!-- 如果使用post方式提交 ，需要添加@csrf -->
  30.             @csrf
  31.             <div class="layui-form-item">
  32.                 <label class="layui-form-label">商品類別：</label>
  33.                 <div class="layui-input-inline">
  34.                     <select name="gCate" id="gCate">
  35.                         <option value=""></option>
  36.                         <!-- 通過類別id,顯示類別名稱 -->
  37.                         @foreach($cates as $cate )
  38.                         <option value="{{$cate->id}}">{{$cate->name}}</option>
  39.                         @endforeach
  40.                     </select>
  41.                 </div>
  42.             </div>
  43.             <div class="layui-form-item">
  44.                 <label class="layui-form-label">商品名稱：</label>
  45.                 <div class="layui-input-inline">
  46.                     <input type="text" name="gName" id="gName" class="layui-input">
  47.                 </div>
  48.             </div>
  49.             <div class=" layui-form-item">
  50.                 <label class="layui-form-label">商品單價：</label>
  51.                 <div class="layui-input-inline">
  52.                     <input type="text" name="gPrice" id="gPrice" class="layui-input">
  53.                 </div>
  54.                 <div class="layui-form-mid layui-word-aux">元</div>
  55.             </div>
  56.             <div class=" layui-form-item">
  57.                 <label class="layui-form-label">商品單位：</label>
  58.                 <div class="layui-input-inline">
  59.                     <input type="text" name="gUnit" id="gUnit" class="layui-input">
  60.                 </div>
  61.             </div>
  62.             <div class=" layui-form-item">
  63.                 <label class="layui-form-label">上架時間：</label>
  64.                 <div class="layui-input-inline">
  65.                     <input type="text" name="gSdate" id="gSdate" class="layui-input">
  66.                 </div>
  67.             </div>
  69.             <div class="layui-form-item">
  70.                 <div class="layui-input-block">
  71.                     <button class="layui-btn" lay-submnt id="addGoodBtn">添加</button>
  72.                     <button type="reset" class="layui-btn layui-btn-primary" id="backBtn">重置</button>
  73.                 </div>
  74.             </div>
  75.             <div></div>
  76.         </form>
  78.     </div>
  79. </body>
  80. <script>
  81. layui.use(['form', 'laydate'], function() {
  82.     var form = layui.form;
  83.     var laydate = layui.laydate;
  85.     laydate.render({
  86.         elem: '#gSdate'
  87.     });
  89. });
  90. </script>
  92. </html>
  • 頁面效果

3.3更新商品頁面updateGoods.blade.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="../../layui/css/layui.css">
  9.     <script src="../../layui/layui.js"></script>
  10.     <title>修改商品</title>
  11.     <style>
  12.     .main {
  13.         width: 100%;
  14.         height: 470px;
  15.         display: flex;
  16.         flex-flow: column nowrap;
  17.         justify-content: space-evenly;
  18.         align-items: center;
  19.     }
  20.     </style>
  22. </head>
  24. <body>
  25.     <div class="main">
  26.         <div>
  27.             <h2 style="margin-bottom: 20px;">更新商品</h2>
  28.         </div>
  30.         <form class="layui-form" method="POST" action="/goods/update/detail">
  31.             <!-- 如果使用post方式提交 ，需要添加@csrf -->
  32.             @csrf
  34.             <div class="layui-form-item">
  35.                 <label class="layui-form-label">商品編號：</label>
  36.                 <div class="layui-input-inline">
  37.                     <input type="text" class="layui-input" value="{{$res->id}}" disabled>
  38.                     <input type="hidden" name="gId" id="gId" value="{{$res->id}}">
  39.                 </div>
  40.             </div>
  42.             <div class="layui-form-item">
  43.                 <label class="layui-form-label">商品類別：</label>
  44.                 <div class="layui-input-inline">
  45.                     <select name="gCate" id="gCate">
  46.                         @foreach($cates as $cate )
  47.                         @if($cate->id===$res->cate_id)
  48.                         <option value="{{$cate->id}}" selected>{{$cate->name}}</option>
  49.                         @else
  50.                         <option value="{{$cate->id}}">{{$cate->name}}</option>
  51.                         @endif
  52.                         @endforeach
  53.                     </select>
  54.                 </div>
  55.             </div>
  56.             <div class="layui-form-item">
  57.                 <label class="layui-form-label">商品名稱：</label>
  58.                 <div class="layui-input-inline">
  59.                     <input type="text" name="gName" id="gName" class="layui-input" value="{{$res->name}}">
  60.                 </div>
  61.             </div>
  62.             <div class=" layui-form-item">
  63.                 <label class="layui-form-label">商品單價：</label>
  64.                 <div class="layui-input-inline">
  65.                     <input type="text" name="gPrice" id="gPrice" class="layui-input" value="{{$res->price}}">
  66.                 </div>
  67.                 <div class="layui-form-mid layui-word-aux">元</div>
  68.             </div>
  69.             <div class=" layui-form-item">
  70.                 <label class="layui-form-label">商品單位：</label>
  71.                 <div class="layui-input-inline">
  72.                     <input type="text" name="gUnit" id="gUnit" class="layui-input" value="{{$res->unit}}">
  73.                 </div>
  74.             </div>
  75.             <div class=" layui-form-item">
  76.                 <label class="layui-form-label">上架時間：</label>
  77.                 <div class="layui-input-inline">
  78.                     <input type="text" name="gSdate" id="gSdate" class="layui-input" value="{{$res->sdate}}">
  79.                 </div>
  80.             </div>
  82.             <div class="layui-form-item">
  83.                 <div class="layui-input-block">
  84.                     <button class="layui-btn" lay-submnt id="addGoodBtn">更新</button>
  85.                     <button type="reset" class="layui-btn layui-btn-primary" id="backBtn">重置</button>
  86.                 </div>
  87.             </div>
  88.             <div></div>
  89.         </form>
  91.     </div>
  93. </body>
  94. <script>
  95. layui.use(['form', 'laydate'], function() {
  96.     var form = layui.form;
  97.     var laydate = layui.laydate;
  99.     laydate.render({
  100.         elem: '#gSdate'
  101.     });
  103. });
  104. </script>
  106. </html>
  • 頁面效果

4.中間件的使用

  • 創(chuàng)建中間件

  • 注冊中間件

  • 使用中間件

  • 使用中間件頁面效果圖

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

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

老師批語：思考:不用中間件方法, 如果完成同樣功能?
本博文版權(quán)歸博主所有，轉(zhuǎn)載請注明地址！如有侵權(quán)、違法，請聯(lián)系admin@php.cn舉報處理！
全部評論 文明上網(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é)