php加ajax增删改查,thinkphp 增删改查 ajaxreturn

//根据条件查询

public function zaixiao_basic() {

$tab=M('drivestutab');

$name =I('Name');

$idcard =I('IDcard');

$sql = " Name like '$name%' and IDcard like '$idcard%'" ;

$result=$tab->where($sql)->select();

if($result){

$this->ajaxReturn($result);

}

}

//增加数据

public function zaixiao_basic_save(){

$tab=M("drivestutab");

if($tab->create())

{

$tab->add();

$this->ajaxReturn("添加成功");

}

else{

$this->ajaxReturn("添加失败");

}

}

//更新数据，必须有一个主键的隐藏域，才能实现数据的更新，如：

ID

public function zaixiao_basic_update()

{

$tab=M('drivestutab');

$id=I('ID');

$vo = $tab->where("ID=$id")->save();

$tab->create();

$vo=$tab->save();

if($vo) {

$this->ajaxReturn("更新成功");

}else{

$this->ajaxReturn("更新失败");

}

}

//根据所选那一行id，删除那一行对应的所有数据

public function zaixiao_basic_delete() {

$tab=M('drivestutab');

$id =I('id');

if ($vo=$tab->where("ID=$id")->delete()){

$this->ajaxReturn("删除成功");

}else{

$this->ajaxReturn("删除失败");

}

}