Yii Update Tutorials

Upsert is an atomic operation. `Upsert()` will insert new record into a database table If table do not already exist or update them. upsert( $table, $insertColumns, $updateColumns = true, $params = []) Using QueryBuilder $sql = $queryBuilder->upsert('pages', [ 'name' => 'Home page', 'url' => 'http://bsourcecode.com/', // url is unique 'visits' => 10000, ], [ 'visits' => new \yii\db\Expression('visits + 1'), ], $params = array()); Using Command: Yii::$app->db->createCommand()->upsert('pages', [ 'name' => […]... Read More »

In Yii Framework 2.0, This tutorial will help you to understand the models and Update Query command.... Read More »

Functions function update($table, $columns, $conditions='', $params=array()) SampleThe update() method builds and executes an UPDATE SQL statement. <?php $user=Yii::app()->db->createCommand() ->update( 'tbl_user', array( 'username'=>'bsourcecode', ), 'user_id=:id', array(':id'=>1) ); ?> Output UPDATE `tbl_user` SET `username`=:username WHERE user_id=:id... Read More »