yii2 框架的 AR 和 DAO 增删改查

自己做个总结  方便以后查找使用

/**
* yii 的增删改查
*/
//增
public function add1($data)
{
$data = [
'title'=>$data['YiiNews']['title'],
'msg'=>$data['YiiNews']['msg'],
'img'=>$data['News']['img'],
];
$this->setAttributes($data) ;
return $this->insert();
}

public function add2($data)
{
$this->setAttributes($data);
$this->isNewRecord = true;
$this->id = 0;
return $this->save(0);
}

public function add3($data)
{
$sql = "insert into yii_news (title,msg) values ('{$data['title']}','{$data['msg']}')";
return \yii::$app->db->createCommand($sql)->execute();
}

//删
public function del1($id)
{
$this->deleteAll('id = '.$id);//作死写法 不要这么写
$this->deleteAll(['id'=>$id]);
}

public function del2($id)
{
$sql = "delete from yii_news where id = '$id'";
return \yii::$app->db->createCommand($sql)->execute();
}

//改
public function save1($data)
{
return $this->updateAll($data,['id'=> 1]);
}

//查
public function sel1()
{
return $this->find()->where("title = 'title11'")->andWhere("id > 0")->asArray(true)->all();
// return $this->find()->select()->where("title = 'title11'")->orWhere("id = 9")->asArray(true)->one();
}

public function sel2()
{
$sql = "select * from yii_news ";
return \yii::$app->db->createCommand($sql)->queryAll();
}

 

更具体欢迎访问 http://www.php20.com/forum.php?mod=viewthread&tid=158&extra=page%3D1