YII Update Record

by Online Tutorials Library July 14, 2022

Update Record

To update the records in the database, following these steps. We have named our Yii2 folder as update.

Step 1 Create Model file

Create a model file child.php in frontend/models folder.

  <?php   namespace appmodels;      use Yii;      class Child extends yiidbActiveRecord   {       /**        * @inheritdoc        */       public static function tableName()       {           return ‘child’;       }              /**        * @inheritdoc        */       public function rules()       {           return [               [[‘name’, ‘meaning’, ‘gender’], ‘required’],               [[‘name’, ‘meaning’], ‘string’, ‘max’ => 100],               [[‘gender’], ‘string’, ‘max’ => 15]           ];       }   }  

Step 2 Add action in controllers

Add the update action actionEdit in controllers file ChildController.php.

  <?php   namespace frontendcontrollers;      use Yii;   use appmodelsChild;   use yiiwebController;        /**   * manual CRUD    **/   class ChildController extends Controller   {        /**        * Create        */       public function actionCreate()       {                     $model = new Child();              // new record           if($model->load(Yii::$app->request->post()) && $model->save()){               return $this->redirect([‘index’]);           }                              return $this->render(‘create’, [‘model’ => $model]);       }         /**        * Read        */       public function actionIndex()       {           $child = Child::find()->all();                      return $this->render(‘index’, [‘model’ => $child]);       }         /**        * Edit        * @param integer $id        */       public function actionEdit($id)       {           $model = Child::find()->where([‘id’ => $id])->one();              // $id not found in database           if($model === null)               throw new NotFoundHttpException(‘The requested page does not exist.’);                      // update record           if($model->load(Yii::$app->request->post()) && $model->save()){               return $this->redirect([‘index’]);           }                      return $this->render(‘edit’, [‘model’ => $model]);       }       }  

Step 3 Create View file

Create a file edit.php in frontend/view/child folder.

Step 4 Run it

Run it on the browser.

http://localhost/dbb/frontend/web/index.php?r=child%2Fedit&id=6

YII Update record 1

Click on Update, information will be updated.

YII Update record 2

Look at the last row in above snapshot, data is updated.

download this example

Next TopicDelete Record

YII Update Record

Update Record

XSLT Element

YII2 Installation

You may also like