YII数据库操作（CURD操作）

2022-10-26 17:05:00

数据库操作

获得模型对象

$model = 模型名::model();或$model = new 模型名();

1、查询多条记录(返回值：二维数组)

$result = $model->findAll();

$result = $model->findAll(条件);

$result = $model->findAll(array("select"=>"字段,字段,字段..."));//限制查询显示的字段

$result = $model->findAll(array("select"=>"字段,字段,字段...","condition"=>"条件"));//限制查询显示的字段与条件

$result = $model->findAll(array("select"=>"字段,字段,字段...","condition"=>"条件","order"=>"字段 desc"));//限制查询显示的字段、条件、排序

$result = $model->findAll(array("select"=>"字段,字段,字段...","condition"=>"条件","order"=>"字段 desc","limit"=>条数,"offset"=>起始值));//限制查询显示的字段、条件、排序、limit、offset

$result = $model->findAllBySql("select语句");

2、查询一条记录(返回值：一维数组)

$model = 模型名::model();或$model = new 模型名();

$result = $model->find();

$result = $model->find(条件);

$result = $model->findByPK(主键);

$result = $model->findByPK(array(主键1,主键2...));

$result = $model->findBySql("select语句");

3、添加记录(返回值：受影响的行数)

$model = new 模型名();

$model->字段 = 值;

$result = $model->save();

4、删除记录(返回值：受影响的行数)

$model = 模型名::model();或$model = new 模型名();

$result = $model->deleteAll("条件");

$result = $model->deleteByPK(主键值);

$result = $model->deleteByPK(array(主键1,主键2...));

5、修改记录(返回值：受影响的行数)

$model = 模型名::model();或$model = new 模型名();

$result = $model->updateAll(关联数组,条件);

$result = $model->updateByPK(主键,关联数组);

$result = $model->updateByPK(array(主键1,主键2...),关联数组);

6、执行sql语句(返回值：二维数组)

$db = Yii::app()->db;