Community Learn Tools Library Leisure
search
English
Home > List of blog posts > laravel 使用数据库查询构造器实现数据的增删改查，页面的渲染，中间件的使用
Blogger Information
Blog 64
fans 6
comment 2
visits 83040
Special Recommendation
More>
Related recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
laravel 使用数据库查询构造器实现数据的增删改查，页面的渲染，中间件的使用
王娇
Original
934 people have browsed it

学习总结

  • 使用laravel中的查询构造器，也就是链式调用，实现数据库中数据的增删改查，方便且高效
  • 中间件的注册和使用，可以很方便的解决用户操作的控制

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方法的第一个参数'/'代表网站的入口地址，第二个参数访问的是app/http/controllers/home下的indexCon控制器的index方法
  18. Route::get('/', 'home\indexCon@index');
  20. //get方法的第一个参数'/home/article'访问地址为backstage.com/goods，第二个参数访问的是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.     //执行添加商品操作
  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.     //执行更新商品操作
  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>发布日期</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.         //当前是第几条记录的更新操作
  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('确认删除该记录？')) {
  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.中间件的使用

  • 创建中间件

  • 注册中间件

  • 使用中间件

  • 使用中间件页面效果图

Correcting teacher：天蓬老师天蓬老师

Correction status：qualified

Teacher's comments：思考:不用中间件方法, 如果完成同样功能?
Statement of this Website
The copyright of this blog article belongs to the blogger. Please specify the address when reprinting! If there is any infringement or violation of the law, please contact admin@php.cn Report processing!
All comments Speak rationally on civilized internet, please comply with News Comment Service Agreement
0 comments
Author's latest blog post