删除记录

17 Mar 2025 | 阅读 2 分钟

要在数据库中删除记录，请按照以下步骤操作。我们将 Yii2 文件夹命名为delete。

步骤 1 创建模型文件

在 frontend/models 文件夹中创建一个模型文件 child.php。

<?php 
namespace app\models; 
 
use Yii; 
 
class Child extends \yii\db\ActiveRecord 
{ 
    /** 
     * @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] 
        ]; 
    } 
}

步骤 2 在控制器中创建 action

在 ChildController.php 文件中创建一个 action actionDelete。

<?php 
namespace frontend\controllers; 
 
use Yii; 
use app\models\Child; 
use yii\web\Controller; 
 

/** 
 * 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']); 
     }    
   }

步骤 3 运行它

在浏览器上运行它。

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