updateByPk how to use with condition ?

[konichiwa (Amisam Sonpx)]

I’m using updateByPk but . I only use with update with PK

a row in my table must change when sql execute.

Post::model()->updateByPk($pk,$attributes,$condition,$params);

then, can you explain for me about :

$condition and $params ??

how to use

please help me

[DARX (Ioxanssen)]

Konichiwa, Konichiwa

The usage of $condition and $params are identical as in find() method:

$criteria

query condition or criteria. If a string, it is treated as query condition (the WHERE clause); If an array, it is treated as the initial values for constructing a CDbCriteria object; Otherwise, it should be an instance of CDbCriteria.

$params

parameters to be bound to an SQL statement. This is only used when the first parameter is a string (query condition). In other cases, please use CDbCriteria::params to set parameters.

So, the usage is such like this:

Post::model()->updateByPk($pks, 'author_id = :author_id', array('author_id'=>$myId));

or

Post::model()->updateByPk($pks, new CDbCriteria(array('condition'=>'author_id = :author_id', 'params'=>array('author_id'=>$myId))));

or you can just create a separate variable that would contain your CDbCriteria object:

$c = new CDbCriteria()

$c->condition=...

...

That is!

[konichiwa (Amisam Sonpx)]

Thank you very much