I need to update column value by + 1 when new records get created :public function actionCreate() { $model = new CreateBookings(); if ($model->load(Yii::$app->request->post())) { Yii::$app->db->createCommand("UPDATE room_types SET total_booked = total_booked + 1 WHERE room_type = '$model->room_type' ")->execute(); $model->save(); return $this->redirect(['view', 'id' => $model->id]); } else { return $this->render('create', [ 'model' => $model, ]); } }What am I doing wrong please guide :) 解决方案 Try this: Yii::$app->db->createCommand("UPDATE room_types SET total_booked=total_booked+1 WHERE room_type = '$model->room_type' ")->execute();ORpublic function actionCreate() { $model = new CreateBookings(); if ($model->load(Yii::$app->request->post())) { $RoomType = new room_types(); // room type replace with model name $RoomType->updateCounters(['total_booked' => 1]); $model->save(); return $this->redirect(['view', 'id' => $model->id]); } else { return $this->render('create', [ 'model' => $model, ]); } }Official link 这篇关于Yii2:无法按 + 1 更新列值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！ 上岸，阿里云！
