简单的laravel增删改查+ajax分页

控制器

<?php

namespace App\Http\Controllers;
use Illuminate\Http\Request;
use App\teachers\Teacher;
use function Sodium\compare;
use DB;
class TeachersController extends Controller
{
    /**
     * Display a listing of the resource.
     *
     * @return \Illuminate\Http\Response
     */
     /**ajax分页**/
    public function index()
    {
        $page=isset($_GET['page'])?$_GET['page']:1;
        $count=count(Teacher::get());
        $rev='3';

        $sums=ceil($count/$rev);
        $prev=($page-1)>1?$page-1:1;
        $next=($page+1)<$sums?$page+1:$sums;
        $offset=($page-1)*$rev;
        $data=DB::select("select * from teachers limit $offset,$rev");

        return view('teachers.index',compact('data','prev','next','sums'));
    }

public function create()
{
    return view('teachers.create');
}
/**
 * Store a newly created resource in storage.
 *
 * @param  \Illuminate\Http\Request  $request
 * @return \Illuminate\Http\Response
 */
 /**添加**/
public function store(Request $request)
{
    $title=$_POST['title'];
    $email=$_POST['email'];
    $pwd=$_POST['pwd'];
    $res=DB::table('teachers')->insert([
        'title' => $title,
        'email' => $email,
        'pwd' => encrypt($request->pwd),
        'password' => encrypt($request->password),
    ]);` var_dump($res);die;
    if($res){
        echo '注册成功';
    }else{
        echo '注册失败';
    }
}`

//

/**
 * Display the specified resource.
 *
 * @param  int  $id
 * @return \Illuminate\Http\Response
 */

/**
 * Show the form for editing the specified resource.
 *
 * @param  int  $id
 * @return \Illuminate\Http\Response
 */
 /**修改**/
public function edit($id)
{
    $teacher=Teacher::findOrFail($id);
    return view('teachers.edit',compact('teacher'));
}

/**
 * Update the specified resource in storage.
 *
 * @param  \Illuminate\Http\Request  $request
 * @param  int  $id
 * @return \Illuminate\Http\Response
 */
 //修改
public function update(Request $request, $id)
{
    $this->validate($request, [
        'title' => 'required|max:50',
    ]);

    $teacher = Teacher::findOrFail($id);
    $teacher->update([
        'title' => $request->title,
        'email' => $request->email,
        'pwd'=>$request->pwdd,
        'password'=>$request->password,
    ]);`    return back();
}`



/**
 * Remove the specified resource from storage.
 *
 * @param  int  $id
 * @return \Illuminate\Http\Response
 */
 //删除
public function destroy($id)
{
    $teachers=Teacher::findOrFail($id);
    $teachers->delete($id);
    return back();
}
  }

  
    `## 视图层
    
    /**添加页面**/
    create
    @extends('layouts.app')
    
    @section('content')
        <form action="{{ route('teachers.store') }}" method="post">
            {{ csrf_field() }}
            <label>Title</label>
            <input type="text" name="title" style="width:100%;" value="{{ old('title') }}">
            <label>Title</label>
            <input type="text" name="email" style="width:100%;" value="{{ old('title') }}">
            <label>密码</label>
            <input type="password" name="pwd" style="width:100%;" value="{{ old('pwd') }}">
            <button type="submit">OK</button>
        </form>
    @endsection`
    
/**显示页面**/
    index
    @section('content')
        <`在这里插入代码片`div style="border: 1px solid gray;margin-top: 20px;padding: 20px" id="box">
            @foreach($data as $teacher)
               <td>{{$teacher->id}}</td>
                <h2>{{$teacher->title}}</h2>
                <h3>{{$teacher->email}}</h3>
                <p>{{$teacher->pwd}}</p>
                <p>{{$teacher->password}}</p>

    <a href="{{route('teachers.edit',$teacher->id)}}">Edit</a>

        <form action="{{route('teachers.destroy',$teacher->id)}}" method="post">
            {{csrf_field()}}
            {{method_field('DELETE')}}
            <button type="submit">Delete</button>
        </form>
    @endforeach

        <a href="javascript:void(0)" onclick="page(1)">首页</a>
        <a href="javascript:void(0)" onclick="page({{$prev}})">上一页</a>
        <a href="javascript:void(0)" onclick="page({{$next}})">下一页</a>
        <a href="javascript:void(0)" onclick="page({{$sums}})">尾页</a>
</div>`@endsection
@extends('layouts.app')
<script src="https://code.jquery.com/jquery-3.1.1.min.js"></script>
<script>
    function page(p){
        $.ajax({
          type:'get',
          url:"{{route('index')}}",
          data:{page:p},
          success:function(msg){
              if(msg){
                  $('#box').html(msg);
              }
          }
        })
    }
</script>

/*修改页面*/
edit
@extends('layouts.app')
@section('content')
    <form action="{{route('teachers.update',$teacher->id)}}" method="post">
        {{csrf_field()}}
        {{ method_field('PATCH') }}
        <label>用户名</label>
        `<input type="text" name="title" style="width: 100%;" value="{{$teacher->title}}">
        <label>邮箱</label>
        <input type="text" name="email" style="width: 100%" value="{{$teacher->email}}">
        <label>密码</label>
        <input type="password" name="pwd" style="width: 100%" value="{{$teacher->pwd}}">
        <label>确认密码</label>
        <input type="password" name="password" style="width: 100%;" value="{{$teacher->password}}">
        <button type="submit">Edit</button>
    </form>
@endsection``