控制器增删查改模块
<?php
namespace app\admin\controller;
use app\admin\model\UserModel;
use think\Controller;
use think\facade\Request;
class User extends Controller
{
public function index()
{
$user = new UserModel();
//按ID降序排序,并且每一页设为八条数据
$users = $user->order('id','desc')->paginate(8);
$this->view->users = $users;
//渲染管理员界面
return $this->fetch();
}
//渲染管理员添加界面
public function add()
{
return $this->fetch();
}
public function DoAdd()
{
//获取前台提交过来的数据
$data = Request::param();
//获取添加的时间
$data['time'] = time();
$username = $data['username'];
//使用用户名来查询数据库是否有对应的数据
$res = UserModel::where('username',$username)->find();
//判断数据是否已经存在
if($res == true){
return['res'=>0,'msg'=>'用户名已存在!'];
}
//实例化模型
$user = new UserModel();
// 验证数据存入数据库
if($user->save($data)){
return ['res'=>1,'msg'=>'添加成功!'];
}else{
return ['res'=>0,'msg'=>'添加失败!'];
}
}
public function edit()
{
//获取前台提交过来的数据
$userId = Request::param('id');
//通过用户id查询需要更新用户的所有数据
$user = UserModel::get($userId);
//将数据赋值给模板
$this->view->user = $user;
//渲染编辑页面
return $this->fetch();
}
public function DoEdit()
{
$data = Request::param();
$user = new UserModel();
$res = $user->save([
'username'=>$data['username'],
'time'=>time(),
],['id'=>$data['id']]);
if($res){
return ['res'=>1,'msg'=>'修改成功!'];
}
}
public function del()
{
//获取需要删除管理员的id
$userId = Request::param('id');
//实例化模型
$user = new UserModel();
//进行删除并验证操作
if($user->destroy($userId)){
return ['res'=>1,'msg'=>'删除成功!'];
}
}
}