Yii CRUD

17 Mar 2025 | 6 分钟阅读

Yii 提供了一个 Gii 工具，它是一个代码生成器工具。它可以为你生成 CRUD 的代码。我们将学习如何使用 Gii 生成 CRUD。

这里展示了一个生成 crud 的简单示例。我们将 Yii2 文件夹命名为 crud。 我们的表名为 employees。

步骤 1 打开 Gii

在浏览器中，输入以下内容，https:///crud/frontend/web/index.php?r=gii

步骤 2 生成模型

查看上面的快照，输入表名，在本例中为 employees。将生成 Employees 模型类。向下滚动页面，然后单击“预览”按钮。

查看上面的快照，单击“生成”按钮以生成代码。

您将看到如上所示的成功消息。

步骤 2 生成 CRUD

查看上面的快照，

在模型类中，文件 Employees，路径为 frontend\models\Employees 被生成。

在搜索模型类中，文件 EmployeesSearch，路径为 frontend\controllers\EmployeesSearch 被生成。

在控制器类中，文件 EmployeesController，路径为 @frontend\views\Employees 被生成。

单击“预览”按钮以检查错误。如果没有错误，请单击“生成”按钮以生成代码。再次，您将收到代码生成的成功消息。

现在我们的 CRUD 已成功生成。要检查它，请在浏览器上使用 URL https:///crud/frontend/web/index.php?r=employees/ 运行它

查看上面的快照，Employees 是我们的表名，你可以从这个表中搜索条目。

要在表中插入值，请单击“创建员工”按钮。将出现以下页面。

填写上面的详细信息，然后单击“创建”按钮。数据将插入到表 employees 中。

查看上面的快照，我们已在表中填写了一些条目。在这里你可以看到查看、更新和删除的图标。

单击“查看”图标后，将出现包含 John 信息的以下页面。

单击“更新”图标后，将出现包含 John 信息的以下页面，您可以在其中编辑任何内容。更改后，单击“更新”按钮。

单击“删除”图标后，将出现以下框，询问您是否要删除它。

生成的代码

在控制器中，文件 EmployeesController.php 将包含以下代码。

<?php 

namespace frontend\controllers; 

use Yii; 
use frontend\models\Employees; 
use frontend\models\EmployeesSearch; 
use yii\web\Controller; 
use yii\web\NotFoundHttpException; 
use yii\filters\VerbFilter; 

/** 
 * EmployeesController implements the CRUD actions for Employees model. 
 */ 
class EmployeesController extends Controller 
{ 
    /** 
     * @inheritdoc 
     */ 
    public function behaviors() 
    { 
        return [ 
            'verbs' => [ 
                'class' => VerbFilter::className(), 
 'actions' => [ 
                    'delete' => ['POST'], 
                ], 
            ], 
        ]; 
    } 

    /** 
     * Lists all Employees models. 
     * @return mixed 
     */ 
    public function actionIndex() 
    { 
        $searchModel = new EmployeesSearch(); 
        $dataProvider = $searchModel->search(Yii::$app->request->queryParams); 

        return $this->render('index', [ 
            'searchModel' => $searchModel, 
            'dataProvider' => $dataProvider, 
        ]); 
    } 

    /** 
     * Displays a single Employees model. 
     * @param integer $id 
     * @return mixed 
     */ 
    public function actionView($id) 
    { 
        return $this->render('view', [ 
            'model' => $this->findModel($id), 
        ]); 
    } 

    /** 
     * Creates a new Employees model. 
     * If creation is successful, the browser will be redirected to the 'view' page. 
     * @return mixed 
     */ 
    public function actionCreate() 
    { 
        $model = new Employees(); 

        if ($model->load(Yii::$app->request->post()) && $model->save()) { 
            return $this->redirect(['view', 'id' => $model->id]); 
        } else { 
            return $this->render('create', [ 
                'model' => $model, 
            ]); 
        } 
    } 
            
/** 
     * Updates an existing Employees model. 
     * If update is successful, the browser will be redirected to the 'view' page. 
     * @param integer $id 
     * @return mixed 
     */ 
    public function actionUpdate($id) 
    { 
        $model = $this->findModel($id); 

        if ($model->load(Yii::$app->request->post()) && $model->save()) { 
            return $this->redirect(['view', 'id' => $model->id]); 
        } else { 
            return $this->render('update', [ 
                'model' => $model, 
            ]); 
        } 
    } 

    /** 
     * Deletes an existing Employees model. 
     * If deletion is successful, the browser will be redirected to the 'index' page. 
     * @param integer $id 
     * @return mixed 
     */ 
    public function actionDelete($id) 
    { 
        $this->findModel($id)->delete(); 
 	return $this->redirect(['index']); 
    } 

    /** 
     * Finds the Employees model based on its primary key value. 
     * If the model is not found, a 404 HTTP exception will be thrown. 
     * @param integer $id 
     * @return Employees the loaded model 
     * @throws NotFoundHttpException if the model cannot be found 
     */ 
    protected function findModel($id) 
    { 
        if (($model = Employees::findOne($id)) !== null) { 
            return $model; 
        } else { 
            throw new NotFoundHttpException('The requested page does not exist.'); 
        } 
    } 
}  

在模型中，文件 Employees.php 将包含以下代码。

<?php 

namespace frontend\models; 

use Yii; 

/** 
 * This is the model class for table "employees". 
 * 
 * @property integer $id 
 * @property string $name 
 * @property string $designation 
 * @property integer $contact 
 * @property string $email 
 */ 
class Employees extends \yii\db\ActiveRecord 
{ 
    /** 
     * @inheritdoc 
     */ 
    public static function tableName() 
    { 
        return 'employees'; 
    } 

    /** 
     * @inheritdoc 
     */ 
    public function rules() 
    { 
        return [ 
            [['name', 'designation', 'contact', 'email'], 'required'], 
            [['contact'], 'integer'], 
            [['name'], 'string', 'max' => 20], 
            [['designation'], 'string', 'max' => 50], 
            [['email'], 'string', 'max' => 80], 
        ]; 
    } 

    /** 
     * @inheritdoc 
     */ 
    public function attributeLabels() 
    { 
        return [ 
            'id' => 'ID', 
            'name' => 'Name', 
            'designation' => 'Designation', 
            'contact' => 'Contact', 
            'email' => 'Email', 
       ]; 
    } 
} 

在模型中，文件 EmployeesSearch.php 将包含以下代码。

<?php 

namespace frontend\models; 

use Yii; 
use yii\base\Model; 
use yii\data\ActiveDataProvider; 
use frontend\models\Employees; 

/** 
 * EmployeesSearch represents the model behind the search form about `frontend\models\Employees`. 
 */ 
class EmployeesSearch extends Employees 
{ 
    /** 
     * @inheritdoc 
     */ 
    public function rules() 
    { 
        return [ 
            [['id', 'contact'], 'integer'], 
            [['name', 'designation', 'email'], 'safe'], 
        ]; 
    } 

    /** 
     * @inheritdoc 
     */ 
    public function scenarios() 
    { 
        // bypass scenarios() implementation in the parent class 
        return Model::scenarios(); 
    } 

    /** 
     * Creates data provider instance with search query applied 
     * 
     * @param array $params 
     * 
     * @return ActiveDataProvider 
     */ 
    public function search($params) 
    { 
       $query = Employees::find(); 

        // add conditions that should always apply here 

        $dataProvider = new ActiveDataProvider([ 
            'query' => $query, 
        ]); 

        $this->load($params); 

        if (!$this->validate()) { 
            // uncomment the following line if you do not want to return any 
	records when validation fails 
            // $query->where('0=1'); 
            return $dataProvider; 
        } 

       // grid filtering conditions 
        $query->andFilterWhere([ 
            'id' => $this->id, 
            'contact' => $this->contact, 
        ]); 

        $query->andFilterWhere(['like', 'name', $this->name]) 
            ->andFilterWhere(['like', 'designation', $this->designation]) 
            ->andFilterWhere(['like', 'email', $this->email]); 

        return $dataProvider; 
      } 
  } 

在视图中，文件 view.php 将包含以下代码。

<?php 

use yii\helpers\Html; 
use yii\widgets\DetailView; 

/* @var $this yii\web\View */ 
/* @var $model frontend\models\Employees */ 

$this->title = $model->name; 
$this->params['breadcrumbs'][] = ['label' => 'Employees', 'url' => ['index']]; 
$this->params['breadcrumbs'][] = $this->title; 
?> 
<div class="employees-view"> 

    <h1><?= Html::encode($this->title) ?></h1> 

    <p> 
       <?= Html::a('Update', ['update', 'id' => $model->id], ['class' => 'btn btn-primary']) ?> 
        <?= Html::a('Delete', ['delete', 'id' => $model->id], [ 
            'class' => 'btn btn-danger', 
            'data' => [ 
                'confirm' => 'Are you sure you want to delete this item?', 
                'method' => 'post', 
            ], 
        ]) ?> 
    </p> 

    <?= DetailView::widget([ 
        'model' => $model, 
        'attributes' => [ 
            'id', 
            'name', 
            'designation', 
            'contact', 
            'email:email', 
        ], 
    ]) ?> 

</div> 

在视图中，文件 form.php 将包含以下代码。

<?php 

use yii\helpers\Html; 
use yii\widgets\ActiveForm; 

/* @var $this yii\web\View */ 
/* @var $model frontend\models\Employees */ 
/* @var $form yii\widgets\ActiveForm */ 
?> 

<div class="employees-form"> 

    <?php $form = ActiveForm::begin(); ?> 

    <?= $form->field($model, 'name')->textInput(['maxlength' => true]) ?> 

    <?= $form->field($model, 'designation')->textInput(['maxlength' => true]) ?> 

    <?= $form->field($model, 'contact')->textInput() ?> 

    <?= $form->field($model, 'email')->textInput(['maxlength' => true]) ?> 

    <div class="form-group"> 
        <?= Html::submitButton($model->isNewRecord ? 'Create' : 'Update', ['class' => $model->isNewRecord ? 'btn btn-success' : 'btn btn-primary']) ?> 
   </div> 

    <?php ActiveForm::end(); ?> 

</div> 

在视图中，文件 search.php 将包含以下代码。

<?php 

use yii\helpers\Html; 
use yii\widgets\ActiveForm; 

/* @var $this yii\web\View */ 
/* @var $model frontend\models\EmployeesSearch */ 
/* @var $form yii\widgets\ActiveForm */ 
?> 

<div class="employees-search"> 

    <?php $form = ActiveForm::begin([ 
        'action' => ['index'], 
       'method' => 'get', 
    ]); ?> 

    <?= $form->field($model, 'id') ?> 

    <?= $form->field($model, 'name') ?> 

    <?= $form->field($model, 'designation') ?> 

    <?= $form->field($model, 'contact') ?> 

    <?= $form->field($model, 'email') ?> 

    <div class="form-group"> 
        <?= Html::submitButton('Search', ['class' => 'btn btn-primary']) ?> 
       <?= Html::resetButton('Reset', ['class' => 'btn btn-default']) ?> 
    </div> 

    <?php ActiveForm::end(); ?> 

</div> 

在视图中，文件 create.php 将包含以下代码。

<?php 

use yii\helpers\Html; 


/* @var $this yii\web\View */ 
/* @var $model frontend\models\Employees */ 

$this->title = 'Create Employees'; 
$this->params['breadcrumbs'][] = ['label' => 'Employees', 'url' => ['index']]; 
$this->params['breadcrumbs'][] = $this->title; 
?> 
<div class="employees-create"> 

    <h1><?= Html::encode($this->title) ?></h1> 

    <?= $this->render('_form', [ 
        'model' => $model, 
    ]) ?> 

</div> 

在视图中，文件 index.php 将包含以下代码。

<?php 

use yii\helpers\Html; 
use yii\grid\GridView; 

/* @var $this yii\web\View */ 
/* @var $searchModel frontend\models\EmployeesSearch */ 
/* @var $dataProvider yii\data\ActiveDataProvider */ 

$this->title = 'Employees'; 
$this->params['breadcrumbs'][] = $this->title; 
?> 
<div class="employees-index"> 

    <h1><?= Html::encode($this->title) ?></h1> 
    <?php // echo $this->render('_search', ['model' => $searchModel]); ?> 

    <p> 
        <?= Html::a('Create Employees', ['create'], ['class' => 'btn btn-success']) ?> 
    </p> 
    <?= GridView::widget([ 
        'dataProvider' => $dataProvider, 
        'filterModel' => $searchModel, 
        'columns' => [ 
            ['class' => 'yii\grid\SerialColumn'], 

            'id', 
            'name', 
            'designation', 
           'contact', 
            'email:email', 

            ['class' => 'yii\grid\ActionColumn'], 
        ], 
    ]); ?> 
</div> 

在视图中，文件 update.php 将包含以下代码。

<?php 

use yii\helpers\Html; 

/* @var $this yii\web\View */ 
/* @var $model frontend\models\Employees */ 

$this->title = 'Update Employees: ' . $model->name; 
$this->params['breadcrumbs'][] = ['label' => 'Employees', 'url' => ['index']]; 
$this->params['breadcrumbs'][] = ['label' => $model->name, 'url' => ['view', 'id' => $model->id]]; 
$this->params['breadcrumbs'][] = 'Update'; 
?> 
<div class="employees-update"> 

    <h1><?= Html::encode($this->title) ?></h1> 

    <?= $this->render('_form', [ 
        'model' => $model, 
    ]) ?> 

</div> 

下载此示例

下一个主题Yii 结构