ThinkPHP3.2.3对数据的添、删、改、查(CURD)

对数据的添加：

public function form()
{
        parent::common();

$obj = D('Leave');
if (IS_POST) {
$data = I('post.');
if ($obj->create($data)) {
$rs = $obj->add();
if ($rs) {
//$this->success('新增成功', 'Approval/approval');
$this->redirect('Approval/approval');
                }
            } else {
$this->assign('error', json_encode($obj->getError()));
$error1 = $obj->getError();
$this->assign('error1', $error1);
            }
}

对数据的修改：

 $data = I('post.');

D('Leave')->Approver = $data['Approver'];

D('Leave')->where("id={$data['id']}")->save(); 

对数据的查询：

//控制器中关联查询(leave表与user表关联)

D('Leave')->relation(true)->where('Leave.depart_id=2and Leave.job_id!=5')->select();

//leave模型中

protected $_link = [
'user' => self::BELONGS_TO
];