<?php

/*
|--------------------------------------------------------------------------
| Web Routes
|--------------------------------------------------------------------------
|
| Here is where you can register web routes for your application. These
| routes are loaded by the RouteServiceProvider within a group which
| contains the "web" middleware group. Now create something great!
|
*/

Route::get('/',function(){
    return '首页';
});
//用户
Route::get('/user', 'UsersController@index');
Route::get('/user/add', 'UsersController@add');
Route::post('/user/doAdd', 'UsersController@doAdd');
Route::get('/user/edit/{id}', 'UsersController@edit');
Route::post('/edit/save', 'UsersController@save');
Route::get('/user/del/{id}', 'UsersController@del');

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use Illuminate\Support\Facades\DB;
class UsersController extends Controller
{
    /**
     *   遍历用户
     */
    public function index()
    {
       $list = DB::table('user')->select('id','name', 'age')->get();
        return view('user.index',['list'=>$list]);
    }


    /**
     *   加载添加用户页面
     */
    public function add()
    {
        return view('user.add');
    }

    /**
     *   执行添加用户页面
     */
    public function doAdd(Request $request)
    {
        $data = $request->post();
        unset($data['_token']);
        $id = DB::table('user')->insertGetId(
            ['name' => $data['name'], 'age' => $data['age']]
        );
        if($id){
            echo '<script>alert("添加成功");window.location.href="/user";</script>';

        }else{
            echo '<script>alert("添加失败");window.location.href="/user";</script>';

        }

    }

    /**
     *
     *   加载用户编辑页面
     *
     *   @param $id  [用户id]
     *
     */

    public function edit($id)
    {
        $list = DB::table('user')->where('id', $id)->first();
        return view('user.edit',['list'=>$list]);
    }

    /**
     *   执行用户编辑
     *   @return boolean
     */
    public function save(Request $request)
    {
        $data = $request->post();
        $id = $data['id'];
        unset($data['_token']);
        unset($data['id']);
       $res = DB::table('user')
            ->where('id', $id)
            ->update(['name'=>$data['name'],'age'=>$data['age']]);
        if($res){
            echo '<script>alert("更新成功");window.location.href="/user";</script>';

        }else{
            echo '<script>alert("更新失败");window.location.href="/user";</script>';

        }
    }


    /**
     *   删除用户
     *
     *  @param $id  [用户id]
     *
     *   @return  boolean
     */

    public  function del( $id)
    {
        $res = DB::table('user')->where('id', $id)->delete();
        if($res){
            echo '<script>alert("删除成功");window.location.href="/user";</script>';

        }else{
            echo '<script>alert("修改失败");window.location.href="/user";</script>';

        }
    }
}

效果:

列表页

　　

添加页

编辑页

要搞其他东西,没做效果,直接弹窗提示

优质内容筛选与推荐>>
1、容易引起重启的一些理解
2、快速获取DB服务器当前 MEM CPU的资源消耗
3、无奈bug太少，只能提出一点对原版软件的改进意见
4、javascript 定义几种类型
5、141. Linked List Cycle（LeetCode）