tp5使用layui表格_tp5+layui增、删、改、查。

html代码：

一、首先要引入layui插件1、添加页面html代码(修改页面差不多) 

产品名称              

autocomplete="off" class="layui-input">

*必填              

立即提交

二、模型代码(根据自己的项目稍作修改)：<?phpnamespaceapp \common\model;usethink\Model;classChanpinextendsModel{protected$pk='cp_id';//主键//设置当前模型对应的完整数据表名称protected$table='jiang_chanpin';//添加public functiontianjia($data){//2.比对$bianma=$this->where('cp_bianma',$data['cp_bianma'])->find();//halt($userInfo);//检查数据是否存在if($bianma){//说明在数据库存在记录return['valid'=>0,'msg'=>'该编码已被占用！'];}//halt($data);$count= count($data['pc_src']);//获取传过来有几张图片if($count){for($i=0;$i$data['pc_src'][$i]);}$data['pics'] = json_encode($data['pics']);//$data['cc'] = json_decode($data['bb']);//halt($data);}$result=$this->validate(true)->allowField(true)->save($data);if($result){// 验证失败 输出错误信息return['valid'=>1,'msg'=>'添加成功'];//dump($this->getError());}else{return['valid'=>0,'msg'=>$this->getError()];}}/*** 编辑*/public functionedit($data){$count= count($data['pc_src']);//获取传过来有几张图片//halt($count);if($count){for($i=0;$i$data['pc_src'][$i]);}$data['pics'] = json_encode($data['pics']);//$data['cc'] = json_decode($data['bb']);//halt($data);}//allowField过滤post数组中的非数据表字段数据$res=$this->validate(true)->allowField(true)->save($data,[$this->pk=>$data['cp_id'] ]);if($res) {return['valid'=>1,'msg'=>'操作成功'];}else{return['valid'=>0,'msg'=>'操作失败'];}}}

三、控制器方法代码：

<?phpnamespaceapp \admin\controller;usethink\Request;classChanpinextendsCommon{//实例化$dbprotected$db;protected function_initialize(){parent::_initialize();$this->db=new\app\common\model\Chanpin();}//添加public functionadd(){if(request()->isPost()){//dump(input('post.'));$res=$this->db->tianjia(input('post.'));if($res['valid']){$this->success($res['msg']);}else{$this->error($res['msg']);}}return$this->fetch();}//修改public functionedit(){if(request()->isPost()){//halt($_POST);$res=$this->db->edit(input('post.'));if($res['valid']){//执行成功$this->success($res['msg'] );}else{$this->error($res['msg'] );}}$cp_id= input('param.cp_id');//halt($cp_id);$oldData= db('chanpin')->find($cp_id);$oldData['pics']= json_decode($oldData['pics'],true);//加true会输出数组,否则输出对象//halt($oldData);$this->assign('oldData',$oldData);return$this->fetch();}//设置状态public functionState(){$cp_id=input('post.cp_id');$is_lock=input('post.is_lock');//halt($is_lock);if(db('chanpin')->where('cp_id='.$cp_id)->update(['is_lock'=>$is_lock])!==false){return['status'=>1,'msg'=>'设置成功!'];}else{return['status'=>0,'msg'=>'设置失败!'];}}//单元格更新事件public functionupdatefield(){$cp_id=input('post.cp_id');$field=input('post.field');$value=input('post.value');//halt($value);$data= db('chanpin')->where('cp_id',$cp_id)->update([$field=>$value]);if($data){return['status'=>1,'msg'=>'修改成功!'];}else{return['status'=>0,'msg'=>'修改失败!'];}}//删除public functiondelwendang(){db('wendang')->where(array('wdid'=>input('wdid')))->delete();return['code'=>1,'msg'=>'删除成功！'];}}