1: 通过find方法
$res = findAll(...); (or findAllByAttributes)
$num = count($res)
2: 通过count方法
$res1 = countByAttributes(...);
$res2 = countBySql(...);
3: 通过query方法
$sql = "SELECT COUNT(*) as clients FROM client_table";
$command = Yii::app()->db->createCommand($sql);
$results = $command->queryAll();
$numClients = (int)$results[0]["clients"];
通过queryScalar可以让上面的语句更简单:
$sql = "SELECT COUNT(*) FROM client_table";
$numClients = Yii::app()->db->createCommand($sql)->queryScalar();
iefreer