search

博客列表 >laravel 使用数据库查询构造器实现数据的增删改查，页面的渲染，中间件的使用

laravel 使用数据库查询构造器实现数据的增删改查，页面的渲染，中间件的使用

王娇
王娇原创
2020年06月07日 18:10:46942浏览

学习总结

  • 使用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.中间件的使用

  • 创建中间件

  • 注册中间件

  • 使用中间件

  • 使用中间件页面效果图

上一条：lavarel基础1：数据库查询、新增、删除、修改（一）下一条：Laravel基础1： MVC之控制器、路由、视窗
声明：本文内容转载自脚本之家，由网友自发贡献，版权归原作者所有，如您发现涉嫌抄袭侵权，请联系admin@php.cn 核实处理。
全部评论
文明上网理性发言，请遵守新闻评论服务协议

相关文章

查看更多