Count all record in table in yii2 without where clause

33,190

You can see this doc http://www.yiiframework.com/doc-2.0/yii-db-activequery.html

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();

see this guide for more http://www.yiiframework.com/doc-2.0/guide-db-query-builder.html

Share:
33,190
Yasin Patel
Author by

Yasin Patel

Web Developer ( Yii2 and Laravel )

Updated on February 18, 2020

Comments

  • Yasin Patel
    Yasin Patel about 4 years

    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