laravel5.4 后台管理员的增删改查
阅读原文时间:2021年04月21日阅读:1

路由

/*管理员*/
Route::group(array('prefix'=>'user'),function(){

    // 管理员显示
    Route::any('/lst', '\App\Http\Controllers\Admin\UserController@lst');

    //管理员添加页面
    Route::any('/add', '\App\Http\Controllers\Admin\UserController@add');
    //管理员添加逻辑
    Route::any('/store', '\App\Http\Controllers\Admin\UserController@store');


    //管理员修改页面
    Route::any('/edit/{post}', '\App\Http\Controllers\Admin\UserController@edit');
    //管理员修改逻辑
    Route::any('/update/{post}', '\App\Http\Controllers\Admin\UserController@update');


    //管理员删除
    Route::any('/delete/{post}', '\App\Http\Controllers\Admin\UserController@delete');



});

控制器

<?php

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

class UserController extends CommonController

{
    //any.admin/user  全部管理员列表
    public function lst()
    {

        //通过模型查找数据
        $data = Users::orderBy('id','desc')->paginate(3);;//这里的Users 是通过php artisan 创建的模型,而不是本
        //控制器  UserController,使用模型类,必须引入改模型,即 use App\Users;
        return view('admin.user.lst',compact('data'));
    }

    //any.admin/user/add   添加管理员页面
    public function add()
    {

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



    //添加管理员逻辑
    public function store()
    {

        $username=\Request::input('username');
        $password=md5(\Request::input('password'));
        $updated_at=time();
        $time=time();

        $res=DB::table('users')->insert(['username'=>$username,'password'=>MD5($password),'updated_at'=>$updated_at,'time'=>$time]);

        if($res){
            return redirect('admin/user/lst');
        }else{
            return back()->with('errors','管理员添加失败,请稍后重试!');
        }


    }


    // 修改管理员页面
    public function edit($id)
    {
        $field = Users::find($id);
        return view('admin.user.edit',compact('data','field'));
    }

    //修改管理员逻辑
    public function update($id)
    {
        $username=\Request::input('username');
        $password=md5(\Request::input('password'));

        $data=[

            'username'=>$username,
            'password'=>$password,
            'updated_at'=>time(),
            'time'=>time()
        ];

        $re = Users::where('id',$id)->update($data);
        if($re){
            return redirect('admin/user/lst');
        }else{
            return back()->with('errors','修改管理员失败,请稍后重试!');
        }
    }



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

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

        if($re){
            return redirect('admin/user/lst');
        }else{
            return back()->with('errors','删除管理员失败,请稍后重试!');
        }

    }



}

模型

<?php

namespace App\Http\Model;

use Illuminate\Database\Eloquent\Model;

class Users extends Model
{
    //
}

视图

增 

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

    <div class="form-group">
        <label for="username" class="col-sm-2 control-label no-padding-right">管理员名</label>
        <div class="col-sm-6">
            <input class="form-control"  placeholder="" name="username" required="" type="text">
        </div>
        <p class="help-block col-sm-4 red">* 必填</p>
    </div>

    <div class="form-group">
        <label for="group_id" class="col-sm-2 control-label no-padding-right">管理员密码</label>
        <div class="col-sm-6">
            <input class="form-control" placeholder="" name="password" 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/user/update/'.$field->id)}}" method="post">
    <input type="hidden" name="_token" value="<?php echo csrf_token(); ?>">
    <div class="form-group">
        <label for="username" class="col-sm-2 control-label no-padding-right">管理员名</label>
        <div class="col-sm-6">
            <input class="form-control"  placeholder="" name="username" required="" type="text" value="{{$field->username}}">
        </div>
        <p class="help-block col-sm-4 red">* 必填</p>
    </div>

    <div class="form-group">
        <label for="group_id" class="col-sm-2 control-label no-padding-right">管理员密码</label>
        <div class="col-sm-6">
            <input class="form-control" placeholder="" name="password" required="" type="password" value="{{$field->password}}">
        </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->username}}</td>
                            <td align="center">
                                <a href="{{url('admin/user/edit/'.$v->id.'')}}" class="btn btn-primary btn-sm shiny">
                                    <i class="fa fa-edit"></i> 编辑
                                </a>
                                <a href="{{url('admin/user/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>