Number Of Affected Rows

[ekerazha]

In Yii, is there a method which returns the number of affected rows from most recent query?

Something like

$this->db->affected_rows()

in CodeIgniter ( http://ellislab.com/...se/helpers.html ).

I looked at CDbConnection methods but I couldn’t find anything.

Thanks.

[Angel_De_La_Noche]

Some methods like updateAll, deleteAll return this number as a result.

Internally they just return $command->execute();

[redguy (Maciej Lizewski)]

read: http://www.yiiframework.com/doc/guide/1.1/en/database.dao

A SQL statement is executed via CDbCommand in one of the following two ways:

execute(): performs a non-query SQL statement, such as INSERT, UPDATE and DELETE. If successful, it returns the number of rows that are affected by the execution.

so:

$affected_rows = Yii::app()->db->createCommand( 'UPDATE ...' )->execute();

[ekerazha]

That’s too easy But I don’t want to execute a command/query, I need the number of affected rows from the most recent query (executed in the past without explicitly saving the number of rows).