Yii update query builder

---

Yii update query builder : Yii::app()->db->createCommand()->update(tableName,data,condition) is used to update data in yii.

---

Yii update query builder Syntax with Example

You can update table data as below :

$data = array(
"name" => "John",
"email" => "john@example.com"
);
$update = Yii::app()->db->createCommand()
    ->update('users', 
        $data,
        'id=:id',
        array(':id'=>$id)
    );

Where $id is primary key in user table and $data is associative array containing the column name and values.
Which will produce the following output :

UPDATE users set name = “John” AND email = “john@example.com” where id = “$id”

Add Comment

📖 Read More

• 1. Yii Get Base Url
• 2. Yii Get Current Url
• 3. Yii Redirect to url
• 4. Yii Delete Query Builder
• 5. Yii Get Current Date Time

• 6. Yii Get Last Inserted Id
• 7. Yii session