laravel5.4 后台栏目的增删改查

路由

/*栏目*/
Route::group(array('prefix'=>'cate'),function(){

    // 栏目显示
    Route::any('/lst', '\App\Http\Controllers\Admin\CateController@lst');

    //栏目添加页面
    Route::any('/add', '\App\Http\Controllers\Admin\CateController@add');
    //栏目添加逻辑
    Route::any('/store', '\App\Http\Controllers\Admin\CateController@store');


    //栏目修改页面
    Route::any('/edit/{post}', '\App\Http\Controllers\Admin\CateController@edit');
    //栏目修改逻辑
    Route::any('/update/{post}', '\App\Http\Controllers\Admin\CateController@update');


    //栏目删除
    Route::any('/delete/{post}', '\App\Http\Controllers\Admin\CateController@delete');
});

 

控制器

<?php

namespace App\Http\Controllers\Admin;
use Illuminate\Support\Facades\DB;
use Illuminate\Http\Request;
use App\Http\Model\Cates;
use App\Http\Controllers\Controller;

class CateController extends CommonController

{

    public function lst()
    {

        //通过模型查找数据
        $data = Cates::orderBy('id','desc')->paginate(3);

        return view('admin.cate.lst',compact('data'));
    }

    //any.admin/user/add   添加栏目页面
    public function add()
    {

        return view('admin.cate.add',compact('data'));

    }



    //添加栏目逻辑
    public function store()
    {

        $catename=\Request::input('catename');
        $updated_at=time();
        $time=time();

        $res=DB::table('cates')->insert(['catename'=>$catename,'updated_at'=>$updated_at,'time'=>$time]);

        if($res){
            return redirect('admin/cate/lst');
        }else{
            return back()->with('errors','栏目添加失败，请稍后重试！');
        }


    }


    // 修改栏目页面
    public function edit($id)
    {
        $field = Cate::find($id);
        return view('admin.cate.edit',compact('data','field'));
    }

    //修改栏目逻辑
    public function update($id)
    {
        $catename=\Request::input('catename');

        $data=[

            'catename'=>$catename,
            'time'=>time(),
            'updated_at'=>time()
        ];



        $re = Cate::where('id',$id)->update($data);

        if($re){
            return redirect('admin/cate/lst');
        }else{
            return back()->with('errors','修改栏目失败，请稍后重试！');
        }
    }



    //  删除
    public function delete($id)
    {

        $re = Cate::where('id',$id)->delete();

        if($re){
            return redirect('admin/cate/lst');
        }else{
            return back()->with('errors','删除栏目失败，请稍后重试！');
        }

    }
}




视图

 

模型

<?php

namespace App\Http\Model;

use Illuminate\Database\Eloquent\Model;

class Cates extends Model
{
    //
}

 

 

 

视图

增

<form class="form-horizontal" role="form" action="{{url('admin/cate/store')}}" method="post">
    <input type="hidden" name="_token" value="<?php echo csrf_token(); ?>">

    <div class="form-group">
        <label class="col-sm-2 control-label no-padding-right">栏目名</label>
        <div class="col-sm-6">
            <input class="form-control"  placeholder="" name="catename" required="" type="text">
        </div>

    </div>


    <div class="form-group">
        <div class="col-sm-offset-2 col-sm-10">
            <button type="submit" class="btn btn-default">保存信息</button>
        </div>
    </div>
</form>

 

改

<form class="form-horizontal" role="form" action="{{url('admin/cate/update/'.$field->id)}}" method="post">
    <input type="hidden" name="_token" value="<?php echo csrf_token(); ?>">
    <div class="form-group">
        <label class="col-sm-2 control-label no-padding-right">栏目名</label>
        <div class="col-sm-6">
            <input class="form-control"  placeholder="" name="catename" required="" type="text" value="{{$field->catename}}">
        </div>
    </div>


    <div class="form-group">
        <div class="col-sm-offset-2 col-sm-10">
            <button type="submit" class="btn btn-default">保存信息</button>
        </div>
    </div>
</form>

查

<div class="row">
        <div class="col-lg-12 col-sm-12 col-xs-12">
            <div class="widget">
                <div class="widget-body">
                    <div class="flip-scroll">
                        <table class="table table-bordered table-hover">
                            <thead class="">
                            <tr>
                                <th class="text-center">ID</th>
                                <th class="text-center">栏目名称</th>
                                <th class="text-center">操作</th>
                                <th class="text-center">操作日期</th>

                            </tr>
                            </thead>
                            <tbody>

                            @foreach ($data as $v)
                            <tr>
                                <td align="center">{{$v->id }} </td>
                                <td align="center">{{$v->catename}}</td>
                                <td align="center">
                                    <a href="{{url('admin/cate/edit/'.$v->id.'')}}" class="btn btn-primary btn-sm shiny">
                                        <i class="fa fa-edit"></i> 编辑
                                    </a>
                                    <a href="{{url('admin/cate/delete/'.$v->id.'')}}" class="btn btn-primary btn-sm shiny">
                                        <i class="fa fa-edit"></i> 删除
                                    </a>

                                </td>
                                <td align="center">{{date('Y-m-d H:i:s',$v->time)}}</td>

                            </tr>
                            @endforeach
                            </tbody>
                        </table>
                    </div>
                    <div>
                    </div>
                    {{ $data->links() }}
                </div>
            </div>
        </div>
    </div>