增
//a字段是主键 $data['b'] = 'bbb'; $data['c'] = 'c'; $new_id = M('test')->data($data)->add(); //echo $new_id; //返回主键id if($new_id>0) { //success }else { //fail }
删除
$User = M("User"); // 删除所有状态为0的5 个用户数据 按照创建时间排序 !!!!where没有匹配到的话会把所有数据都删除,记得先备份 $return = $User->where('status=0')->order('create_time')->limit('5')->delete(); //成功返回1,失败返回0
更新
//主键是a,为37 $data['a']=37; $data['b']=3722222; $re = M('test')->save($data); echo $re; //更新成功返回1, 失败返回0
读
//a字段是主键 $data['b']='1'; $data = M('test')->where($data)->select();