控制器
<?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``