YII数据库删除记录示例

若要删除数据库中的记录, 请按照下列步骤操作。我们已将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在控制器中创建动作

在ChildController.php文件中创建一个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运行

在浏览器上运行它。

http：//localhost/delete/frontend/web/index.php？r = child％2Findex

查看上面的快照, 单击表最后一行中的”删除”选项。

查看上面的快照, 相应的行将从表中删除。

下载此示例