Using foreach loop with Query Builder in Yii 2

Question

For some reason this isn't working. The error I get is "Undefined index: cu_id" for the line

$cu_id = $rows['cu_id'];

I think I'm just totally using the querybuilder wrong with the foreach loop. Any help with the proper syntax for this? Thanks!

$query = new Query;

            $query->select('cu_id')->from('cu_emails')->where(['creator_id' => $user_id, 'email' => $email]);


    foreach ($query as $rows) {

            $cu_id = $rows['cu_id'];

            echo"CU ID: $cu_id<br /><br />";

    }

Also I'm on the Yii 2 framework in case anyone missed that.

ScaisEdge · Accepted Answer · 2016-09-28 20:15:52Z

2

You should add all() or one() for getting the rows

$query = new Query;

   $myModels=   $query->select('cu_id')
       ->from('cu_emails')
       ->where(['creator_id' => $user_id, 'email' => $email])
       ->all();

and obtained the models in $myModels

foreach ($myModels as $rows) {

        $cu_id = $rows['cu_id'];

        echo"CU ID: $cu_id<br /><br />";

}

edited Sep 28, 2016 at 20:15

answered Sep 28, 2016 at 19:56

ScaisEdge

133k10 gold badges98 silver badges111 bronze badges

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

3 Comments

kevinkt Over a year ago

My error is gone, but it doesn't actually loop through the query with any data. What's a good way to debug my query?

ScaisEdge Over a year ago

Loop without echo a value for cu_id or don't loop ?

kevinkt Over a year ago

This was close, but $rows->cu_id didn't work in this instance. The solution above with $rows['cu_id'] worked.

Sedov Sergey · Accepted Answer · 2016-09-28 20:05:34Z

1

You query not run.

$query->all()

and then foreach records or

$query->one()

and get data from one record

$query = new Query;
$query->select('cu_id')->from('cu_emails')->where(['creator_id' => $user_id, 'email' => $email])
$results = $query->all();

foreach ($results as $rows) {
        $cu_id = $rows['cu_id'];
        echo"CU ID: $cu_id<br /><br />";
}

answered Sep 28, 2016 at 20:05

Sedov Sergey

262 bronze badges

Collectives™ on Stack Overflow

Using foreach loop with Query Builder in Yii 2

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related