Yii: Read DB records row by row in Yii

yii-read-db-records-row-by-row.php

<?php
// get data from db:
$cmd = Yii::app()->db->createCommand( "SELECT name, sex, age, position FROM people" );
// get reader object:
$dataReader = $cmd->query();
// read records line by line:
while ( ( $rec = $dataReader->read() ) !== false )
	printf( "Name: %s, Sex: %s, Age: %d, Position: %s", $rec[ 'name' ], $rec[ 'sex' ], $rec[ 'age' ], $rec[ 'position' ] );

// or
foreach ( $dataReader as $rec )
	printf( "Name: %s, Sex: %s, Age: %d, Position: %s", $rec[ 'name' ], $rec[ 'sex' ], $rec[ 'age' ], $rec[ 'position' ] );