How to count number of records in yii2 framework?

Question

I am new in Yii framework. I have a page frontend/site/home.php, I want to display the number of records from companies table at home.php.(DB name yii2advanced)

You need to post some code where you try to fix your problem. Atleast post your model/controller and view code — Solmyr, Dec 08 '17 at 07:57
@Solmyr here's my controller code :public function actionHome() { $result = (new \yii\db\Query) ->select('*') ->from('companies') return $this->render('home'); } and home.php code: use yii\helpers\Html; use yii\bootstrap\ActiveForm;

= "$result"; ?>

Companies — Shailesh Yadav, Dec 08 '17 at 08:12
@ShaileshYadav Please post your code in your question instead of as a comment. — Paul, Dec 08 '17 at 09:29

score 3 · Answer 1 · edited Dec 08 '17 at 11:50

3

Simply use count function to get count of records from a table, like -

$count = YourModel::find()->count();
echo $count;

edited Dec 08 '17 at 11:50

Rohit Suthar

3,528
1
42
48

answered Dec 08 '17 at 08:18

Ajil MV

58
1
7

I get this error:- Undefined variable: count – Shailesh Yadav Dec 08 '17 at 08:57
2

I think it is due to you are not passing '$count' from action to view session. return $this->render('home',['count' => $count]); – Ajil MV Dec 08 '17 at 10:37

How to count number of records in yii2 framework?

= "$result"; ?>

Companies

1 Answers1