$infoArr= NewsList::model()->findAll("status = '1' ORDER BY id DESC limit 10 ");
//2. findAllByPk(该方法是根据主键查询一个集合,可以使用多个主键)
$admin=Admin::model()->findAllByPk($postIDs,$condition,$params);
$admin=Admin::model()->findAllByPk($id,"name like :name and age=:age",array(':name'=>$name,'age'=>$age));
$admin=Admin::model()->findAllByPk(array(1,2));
//该方法是根据SQL语句查询一组数据,他查询的也是第一条数据
$admin=Admin::model()->findBySql($sql,$params);
$admin=Admin::model()->findBySql("select * from admin where username=:name",array(':name'=>'admin'));
//拼一个获得SQL的方法,在根据find查询出一个对象
$criteria=newCDbCriteria;
$criteria->select='username';// only select the 'title' column
$criteria->condition='username=:username'; //请注意,这是一个查询的条件,且只有一个查询条件.多条件用addCondition
$criteria->params=array(":username=>'admin'");
$criteria->order ="id DESC";
$criteria->limit ="3";
$post=Post::model()->find($criteria);// $params isnot needed
//多条件查询的语句
$criteria= new CDbCriteria;
$criteria->addCondition("id=1");//查询条件，即where id = 1
$criteria->addInCondition('id',array(1,2,3,4,5));//代表where id IN (1,2,3,4,5,);
$criteria->addNotInCondition('id',array(1,2,3,4,5));//与上面正好相法，是NOT IN
$criteria->addCondition('id=1','OR');//这是OR条件，多个条件的时候，该条件是OR而非AND
$criteria->addSearchCondition('name','分类');//搜索条件，其实代表了。。where name like '%分类%'
$criteria->addBetweenCondition('id', 1, 4);//between 1 and 4
$criteria->compare('id', 1); //这个方法比较特殊,他会根据你的参数自动处理成addCondition或者addInCondition.
$criteria->compare('id',array(1,2,3)); //即如果第二个参数是数组就会调用addInCondition
//该方法是根据SQL语句查询一个集合有多少条记录,返回一个int型数字
$n=Post::model()->countBySql($sql,$params);
$n=Post::model()->countBySql("select * from admin where username=:name",array(':name'=>'admin'));
查询
//createCommand(执行原生的SQL语句)
$sql= "SELECT u.account,i.* FROM sys_user as u left join user_info as i on u.id=i.user_id";
$rows=Yii:app->db->createCommand($sql)->query();
foreach($rows as $k => $v){
echo$v['add_time'];
}
查询返回多行：
$command = $connection->createCommand('SELECT * FROM post');
$posts = $command->queryAll();
返回单行：
$command = $connection->createCommand('SELECT * FROM post WHERE id=1');
$post = $command->queryOne();
查询多行单值：
$command = $connection->createCommand('SELECT title FROM post');
$titles = $command->queryColumn();
查询标量值/计算值：
$command = $connection->createCommand('SELECT COUNT(*) FROM post');
$postCount = $command->queryScalar(); 更新
$command = $connection->createCommand('UPDATE post SET status=1 WHERE id=1');
$command->execute(); 插入更新删除
// INSERT
$connection->createCommand()->insert('user', [
'name' => 'Sam',
'age' => 30,
])->execute();
app->db->createCommand($sql)->query();