YII Delete Record

by Online Tutorials Library July 14, 2022

Delete Record

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

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 Create action in controllers

Create an action actionDelete in ChildController.php file.

  <?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]);       }          /**       * Delete        * @param integer $id        */        public function actionDelete($id)        {            $model = Child::findOne($id);                      // $id not found in database           if($model === null)               throw new NotFoundHttpException(‘The requested page does not exist.’);                          // delete record           $model->delete();                      return $this->redirect([‘index’]);        }         }  

Step 3 Run it

Run it on the browser.

http://localhost/delete/frontend/web/index.php?r=child%2Findex

Look at the above snapshot, click the Delete option in the last row of the table.

Look at the above snapshot, respective row is deleted from the table.

download this example

Next TopicYII Sessions

YII Delete Record

Delete Record

XSLT Element

YII2 Installation

You may also like