Count all record in table in yii2 without where clause

Question

I want to count all record from table without specify any condition :

now, i am doing by this way

$result['cms'] = Cms::find()->where([])->count();

and it will give me result,but i don't want to use where clause.

So how to count all records without where clause.

Thank you

$results = Cms::model()->findAll(array(*query criteria here*)); $count = count ( $results ); — vijay nathji, May 20 '16 at 05:39
$records = Cms::findAll(); $count = count($records); But if you have a so many records in table then how will you handle this ? Because it will display all records — vijay nathji, May 20 '16 at 05:59

score 15 · Accepted Answer · answered May 20 '16 at 06:27

simply using

count(): returns the result of a COUNT query.

Cms::find()->count();

all(): returns an array of rows with each row being an associative array of name-value pairs.

Cms::find()->all();

1 Answers1