美文网首页
laravel7框架实现数据的curd

laravel7框架实现数据的curd

作者: 端木安玉 | 来源:发表于2020-05-28 17:34 被阅读0次

直接上代码
路由

Route::resource('/user', 'UserController');

控制器

<?php

namespace App\Http\Controllers;
use Illuminate\Support\Facades\DB;
use Illuminate\Http\Request;

class UserController extends Controller
{
    // 测试 cdur
    public function index(){
        $res =  DB::table('work_order')->orderBy("id","desc")->paginate(5);
        return view('User.index')->with('res',$res);
    }
    public function create(){
        return view('User.create');
    }
    public function store(Request $request){
        $data = $request->input();
        $datauser['name'] = $data['name'];
        $datauser['area'] = $data['area'];
        $res = DB::table('work_order')->insert($datauser);
        if($res){
            return redirect('/user');
        }else{
            return error('/user/create');
        }
    }
    public function edit(Request $request,$id){
        $res =  DB::table('work_order')->where("id",$id)->first();
        return view('User.edit')->with('res',$res);
    }
    public function update(Request $request, $id)
    {
        $data = $request->input();
        $datauser['name'] = $data['name'];
        $datauser['area'] = $data['area'];
        $res = DB::table('work_order')->where("id",$id)->update($datauser);
        if($res){
            return redirect('/user');
        }else{
            return redirect('/user');
        }
    }
    public function destroy($id)
    {
        $res = DB::table('work_order')->where("id",$id)->delete();
        if($res){
            return redirect('/user');
        }else{
            return error('/user/create');
        }
    }
}

首页 (包括删除页)

<a href="/user/create">添加</a>
<div class="table-responsive table-wrapper">
    <table class="table custom-data-table dataTable dt-checkboxes-select

                 " id="grid-table">
        <thead>
        <tr>

            <th>id<span class="grid-column-header">&nbsp;<a href="http://laraveladmin.com/admin/workuser?_pjax=%23pjax-container&amp;_sort%5Bcolumn%5D=id&amp;_sort%5Btype%5D=desc" class="feather icon-arrow-up "></a></span></th>
            <th>名称</th>
            <th>地点</th>
            <th>时间</th>
            <th>人员</th>
        </tr>
        </thead>


        <tbody>
        @foreach($res as $vo)
            <tr>

                <td>
                    {{$vo->id}}
                </td>
                <td>
                    {{$vo->name}}
                </td>
                <td>
                    {{$vo->area}}
                </td>
                <td>
                    {{$vo->workdate}}
                </td>
                <td>
                    {{$vo->uid}}
                </td>
                <td>
                    <div class="grid-dropdown-actions dropdown">
                        <a href="#" style="padding:0 10px;" data-toggle="dropdown">
                            <i class="feather icon-more-vertical"></i>
                        </a>
                        <ul class="dropdown-menu" style="left: -65px;">

                            <li class="dropdown-item"><a style="cursor: pointer" class="grid-row-action-5ec74891d8f03" href="http://laraveladmin.com/admin/workuser/1"><i class="feather icon-eye"></i> Show</a></li>
                            <li class="dropdown-item"><a style="cursor: pointer" class="grid-row-action-5ec74891d9281" href="{{ route('user.edit',['user'=>$vo->id]) }}"><i class="feather icon-edit-1"></i> Edit</a></li>
                            <li class="dropdown-item">
                                <form action="{{ route('user.destroy', $vo->id) }}" method="post" style="display: inline-block;">
                                    @csrf
                                    @method('DELETE')
                                    <button type="submit" style="color: #F08080;background-color: transparent;border: none;">Delete</button>
                                </form>
                            </li>

                        </ul>
                    </div>
                </td>
            </tr>
        @endforeach
        </tbody>
    </table>
</div>



<div class="box-footer clearfix " style="padding-bottom:5px;">
    {{$res->links()}}
</div>

添加页面

<form method="POST" action="/user">
    @csrf

    name <input type="text" name="name">
    地点 <input type="text" name="area">
    <button type="submit">提交</button>
</form>

修改页面

<form method="POST" action="{{ route('user.update',['user'=>$res->id]) }}">
    @csrf
    @method('PATCH')
    name <input type="text" name="name" value="{{$res->name}}">
    地点 <input type="text" name="area" value="{{$res->area}}">
    <button type="submit">提交</button>
</form>

相关文章

网友评论

      本文标题:laravel7框架实现数据的curd

      本文链接:https://www.haomeiwen.com/subject/zqiaahtx.html