PostgreSQL query not working in Yii2

Question

I want to execute query in my yii2 application. I'm using PostgreSQl. There is a table called list inside the user schema. If I try to build any query it returns 1. My code is here:

$numUsers = Yii::$app->db->createCommand('
    SELECT COUNT(*) FROM "user"."list"
')->execute();

Please show me my mistake in the query above.

if this is postgresql why did you tag it as mysql? and what is the error? — e4c5
– e4c5, Commented Apr 27, 2016 at 6:11

ScaisEdge · Accepted Answer · 2016-04-27 05:38:46Z

1

This is not related to the DB type in Yii2 if you want the result of a single value you should use queryScalar() instead of execute()

$numUsers = Yii::$app->db->createCommand('
      SELECT COUNT(*) FROM "user"."list" ')->queryScalar();

answered Apr 27, 2016 at 5:38

ScaisEdge

133k10 gold badges98 silver badges111 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Scott Over a year ago

Great! Thanks buddy for your help :-)

Collectives™ on Stack Overflow

PostgreSQL query not working in Yii2

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related