Detailed explanation of the steps to implement database addition, deletion, query and modification in PHP

display("school/stu"); } public function getdata(){ $Studata = M('stu'); $data['id']=''; $data['name']=I('get.name'); $data['age']=I('get.age'); $data['num']=I('get.num'); $data['address']=I('get.add'); $Studata->add($data); $this->success("正在。。。",U('Stu/showdata')); } public function showdata() { $Studata = M('stu'); $data=$Studata->select(); $this->assign('info',$data); $this->display('school/showdata'); } public function del(){ $id = I('get.id'); $Studata = M('stu'); $bool = $Studata->where(['id'=>$id])->delete(); if($bool){ echo 1; }else{ echo 0; } } public function updata() { $id = I('get.id'); $Studata = M('stu'); $data = $Studata->where(['id'=>$id])->find(); $this->assign('data',$data); $this->display("school/upshowdata"); } public function updatadeal() { $Studata = M('stu'); $id = I('get.id'); $data['name']=I('get.name'); $data['age']=I('get.age'); $data['num']=I('get.num'); $data['address']=I('get.add'); $bool = $Studata->where(['id'=>$id])->save($data); if($bool){ $this->showdata(); }else{ echo 0; } } }

     
   
学生信息展示
  
 
编号
 
姓名
 
年龄
 
学号
 
籍贯
 
操作
 
操作
 
 
{$vo['id']}
 
{$vo['name']}
 
{$vo['age']}
 
{$vo['num']}
 
{$vo['address']}
 
删除
 
修改
 
  
     

       
  
 
 名字:  
 年龄:  
 学号: 
 籍贯: 
  
 
  

       
  
  
 名字:  
 年龄:  
 学号: 
 籍贯: