Using a foreach loop with a Yii 2 query

For some reason this isn’t working. The error I get is “undefined index” for 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 />";



You are iterating through the Query object, not the query result.


You probably wanted this:

$rows = (new \yii\db\Query())



    ->where(['creator_id' => $user_id, 'email' => $email])


    foreach ($rows as $row) {

        $cu_id = $row['cu_id'];

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