1.增(注意,如果字段在此已经用post数据赋值,则post不能为'null',否则添加失败):
$m=M('renwubiao');
$m->state=$_POST['state'];
$m->info=$_POST['info'];
$m->taskid=$_POST['taskid'];
//$m->getLastsql();
$idNum=$m->add();
if($idNum>0){
$this->success('任务添加成功',U('Renwu/renwulist','',''));
}else{
$this->error('任务添加失败',U('Renwu/renwuadd','',''));
}
2.删:
$m=M('renwubiao');
$id=$_GET['id'];
$count=$m->delete($id);
if($count>0){
$this->success('删除成功',U('Renwu/renwulist','',''));
}else{
$this->error('删除失败',U('Renwu/renwulist','',''));
}
或
$User->where('status=1 and id=1')->delete();
3.查(以下只列出常用的)
1)find()——查找出来的数组为一维数组
2) select()——查找出来的数组是二维数组
3)order('id')——按id排序,order('id' DESC)——按id倒序
4) field('id,name,times')——要查找的字段
5)limit(10)——要查询的数据记录数
例子:
$User->where('status=1')->order('create_time')->limit(10)->select();
$name=M('ruanjianbiao');
$softname=$name->where(array('id'=>$taskdata['ruanjian_id']))->field('name,tubiao,daxiao')->select();
$task=M('yhurenwubiao');
$data=$task->where(array('user_id'=>$userid))->field('renwu_id,state,FinishTime,yiwancheng')->order('renwu_id desc')->select();
$step=M('renwubiao');
$taskdata=$step->where(array('id'=>$data[$num]['renwu_id']))->field('zongbushu,ruanjian_id')->find();
4.改:
$user=M('user');
$data['totalTime']=time();
$data['totalnum']=$data['totalnum'];
$data['zongjifen']=$data['zongjifen'];
$data['zongjinbi']=$data['zongjinbi'];
$user->where(array('username'=>$username))->save($data);