YII2 CURD 增删改查

最新推荐文章于 2021-11-16 19:05:42 发布
最新推荐文章于 2021-11-16 19:05:42 发布
阅读量3.2k 收藏
点赞数 1
分类专栏： Yii2
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/xiaoyangxiaodong/article/details/44995533
版权

backend\controllers\PostController.php 

<?php

namespace backend\controllers;

use Yii;
use common\models\Post;
use common\models\search\PostSearch;
use yii\web\Controller;
use yii\web\NotFoundHttpException;
use yii\filters\VerbFilter;
use frontend\base\BaseFrontController;
use backend\base\BaseBackController;

/**
 * PostController implements the CRUD actions for Post model.
 */
class PostController extends BaseBackController
{
    public function behaviors()
    {
        return [
            'verbs' => [
                'class' => VerbFilter::className(),
                'actions' => [
                    'delete' => ['post'],
                ],
            ],
        ];
    }

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

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

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

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

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

backend\models\Post.php


<?php
namespace common\models;
use Yii;
use base\BaseActiveRecord;

/**
 * This is the model class for table "post".
 *
 * @property integer $id
 * @property integer $thread_id
 * @property integer $user_id
 * @property string $user_name
 * @property string $title
 * @property string $body
 * @property string $create_time
 * @property string $modify_time
 * @property integer $supports
 * @property integer $againsts
 * @property integer $floor
 * @property string $note
 */
class Post extends BaseActiveRecord
{

	/**
	 * @inheritdoc
	 */
	public static function tableName()
	{
		return 'post';
	}

	/**
	 * @inheritdoc
	 */
	public function rules()
	{
		return [
				[
						[
								'thread_id',
								'user_id',
								'user_name',
								'body',
								'create_time'
						],
						'required'
				],
				[
						[
								'thread_id',
								'user_id',
								'supports',
								'againsts',
								'floor'
						],
						'integer'
				],
				[
						[
								'body'
						],
						'string'
				],
				[
						[
								'create_time',
								'modify_time'
						],
						'safe'
				],
				[
						[
								'user_name'
						],
						'string',
						'max' => 32
				],
				[
						[
								'title'
						],
						'string',
						'max' => 128
				],
				[
						[
								'note'
						],
						'string',
						'max' => 64
				]
		];
	}

	/**
	 * @inheritdoc
	 */
	public function attributeLabels()
	{
		return [
				'id' => 'ID',
				'thread_id' => 'Thread ID',
				'user_id' => 'User ID',
				'user_name' => 'User Name',
				'title' => '标题',
				'body' => '内容',
				'create_time' => 'Create Time',
				'modify_time' => 'Modify Time',
				'supports' => '支持数',
				'againsts' => '反对数',
				'floor' => '楼层',
				'note' => 'Note'
		];
	}
}

backend\views\post\index.php 

<?php

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

/**
 * @var yii\web\View $this
 * @var yii\data\ActiveDataProvider $dataProvider
 * @var common\models\search\PostSearch $searchModel
 */

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

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

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

    <p>
        <?= Html::a('Create Post', ['create'], ['class' => 'btn btn-success']) ?>
    </p>

    <?= GridView::widget([
        'dataProvider' => $dataProvider,
        'filterModel' => $searchModel,
        'columns' => [
            ['class' => 'yii\grid\SerialColumn'],

            'id',
            'thread_id',
            'user_id',
            'user_name',
            'title',
            // 'body:ntext',
            // 'create_time',
            // 'modify_time',
            // 'supports',
            // 'againsts',
            // 'floor',
            // 'note',

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

</div>

backend\views\post\create.php 

<?php

use yii\helpers\Html;

/**
 * @var yii\web\View $this
 * @var common\models\Post $model
 */

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

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

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

</div>

backend\views\post\update.php 

<?php

use yii\helpers\Html;

/**
 * @var yii\web\View $this
 * @var common\models\Post $model
 */

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

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

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

</div>

backend\views\post\view.php 

<?php

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

/**
 * @var yii\web\View $this
 * @var common\models\Post $model
 */

$this->title = $model->title;
$this->params['breadcrumbs'][] = ['label' => 'Posts', 'url' => ['index']];
$this->params['breadcrumbs'][] = $this->title;
?>
<div class="post-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',
            'thread_id',
            'user_id',
            'user_name',
            'title',
            'body:ntext',
            'create_time',
            'modify_time',
            'supports',
            'againsts',
            'floor',
            'note',
        ],
    ]) ?>

</div>

backend\views\post\_form.php 

<?php

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

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

<div class="post-form">

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

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

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

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

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

    <?= $form->field($model, 'body')->textarea(['rows' => 6]) ?>

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

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

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

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

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

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

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

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

</div>
backend\views\post\_search.php 

<?php

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

/**
 * @var yii\web\View $this
 * @var common\models\search\PostSearch $model
 * @var yii\widgets\ActiveForm $form
 */
?>

<div class="post-search">

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

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

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

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

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

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

    <?php // echo $form->field($model, 'body') ?>

    <?php // echo $form->field($model, 'create_time') ?>

    <?php // echo $form->field($model, 'modify_time') ?>

    <?php // echo $form->field($model, 'supports') ?>

    <?php // echo $form->field($model, 'againsts') ?>

    <?php // echo $form->field($model, 'floor') ?>

    <?php // echo $form->field($model, 'note') ?>

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

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

</div>



cd ~/Homestead
关注
专栏目录
yii2增删改查，各种操作
shaoyangzhuanyong的博客
07-24 239
增加数据 //增加一条数据 $code= new Code; $code->nickname = 'ceshi01'; $code->is_delete = 0; $code->save(); Yii::$app->db->createCommand()->insert('code', [ 'nickname' =&g...
yii2gii之CURD使用，功能不要太强大
zfeig的专栏
01-06 3427
yii2 gii crud
Yii2深入了解模型之增删改查（读写）
aa545785的博客
10-07 353
1、ActiveRecord 类型的增删改查 以\app\models\Article 模型为准 ， 来操作以下函数 1) 查询数据 ①findAll 查询多条数据 \app\models\Article::findAll([‘status’ => ‘1’]); //查询 Article , status 为 1 的所有数据 ②根据 findOne 进行查询 ， 根式\app\...
yii2的CURD操作
qq_40750454的博客
12-17 820
一.新增 使用model::save()操作进行新增数据 $user= new User; $user-&gt;username =$username; $user-&gt;password =$password; $user-&gt;save() 使用createCommand()进行新增数据 Yii::$app-&gt;db-&gt;createCommand()-&gt;ins...
Yii2 使用十六 数据库操作汇总
热门推荐
编程圈子-谢厂节的博客
05-24 4万+
对象操作 查询 //1.简单查询 $admin=Admin::model()->findAll($condition,$params); $admin=Admin::model()->findAll("username=:name",array(":name"=>$username)); $infoArr= NewsList::model()->findAll("status = '1'
Yii2增删改查之查询 where参数详细介绍
10-21
在Yii2框架中，进行数据操作的增删改查（CRUD）是非常常见的任务。本文将详细介绍Yii2框架中查询操作中where参数的使用方法，其中涉及到了and、or、between、in、like等操作符的具体应用。 首先，我们来谈谈and条件...
Yii2——使用数据库操作汇总（增删查改、事务）
10-20
本篇文章将详细介绍Yii2框架中对数据库进行增删查改（CRUD）操作以及事务处理的实践知识。 首先，Yii2框架使用了Active Record模式来处理数据库操作。Active Record模式是对象关系映射（ORM）技术的一种实现，它...
Yii2 解模型之增删改查
bboyzhouda的博客
09-04 699
一、ActiveRecord活动记录的CURD DQL 1. 查询所有 Article::findAll(['status'=>1]); 2.查询一条 Article::findOne(1); //根据ID查询 Article::findOne(['status' => 1]); //根据条件查询 3.find()方法返回yii\db\ActiveQuery查询 ...
Yii2 增删改查(CRUD) 整理
weixin_42024325的博客
06-26 345
查询数据集合findAll 1.该方法是根据一个条件查询一个集合 $admin=Admin::model()->findAll($condition,$params); $admin=Admin::model()->findAll("username=:name",array(":name"=>$username)); $admin=Admin::model()->f...
Yii2增删改查-查询 find
爱情,是成长的缩影
08-06 3788
概述 这里只是简单讲一下用法，如果想更详细的了解，去看 官方手册 比较好。 Yii内部提供了一套查询方法，方便我们更加规范的查询sql，这些方法安全，并且组合起来会更加高效。小试牛刀$sql = 'SELECT * FROM {{user}} WHERE id = 1'; $userInfo = User::findBySql($sql)->all(); /* 查询出来一条数据 array(1)
yii2 ajax增删改查,Yii2 中常用的增删改查操作总结
weixin_35756690的博客
08-05 186
一、新增1、使用save()$model = new User();$model->name = 'test';$model->phone = '13000000000';$model->email = '123456@qq.com';$model->save();2、使用createCommand 原生sql$sql = "insert into user (name, ...
Yii2基础：数据库的增删改查操作
dcyly2004的专栏
07-16 352
查： 1.findBySql $sql="select * from tablename where condition"Modelname::findBySql($sql，array(':id'=>1 or 1=1))->all();    //返回一个对象。第二个参数是为了防止sql注入 //findBySql是cactiverecord的方法 2.find $results=mo
用yii2进行(curd)接口开发(普通类型)整个流程:
qq_37805832的博客
11-16 5716
第一步： 理解这里的意思. 第二步：
yii2.0 curd操作
oHongHong的博客
02-23 1199
$customer=new Customer();//插入操作 $customer->name=‘小熊‘; $customer->save();   //修改操作 $model=Customer::findOne(1); $model->name=‘小洋‘; $model->save(); /* --------------------修改指定条件集----------------
Yii2 CURD使用心得（一）
简单的世界
05-27 924
第一步先创建model 记住Namespace一定要和真是要生成的目标目录一致，估计这个操作是个文件缓存为下一步操作做了相应的记录 第二步CRUD操作
for dianming system
bonlog的专栏
10-20 706
-- phpMyAdmin SQL Dump -- version 3.5.2.2 -- http://www.phpmyadmin.net -- -- Host: 127.0.0.1 -- Generation Time: Oct 20, 2014 at 11:05 AM -- Server version: 5.5.27 -- PHP Version: 5.4.7 SET SQL_MODE=
yii框架的增删该查
qq_36030342的博客
11-28 303
User::find()->all();    //返回所有用户数据； User::findOne($id);   //返回 主键 id=1  的一条数据；  User::find()->where(['name' => 'ttt'])->one();   //返回 ['name' => 'ttt'] 的一条数据； User::find()->where(['name' => 'ttt'])
Yii框架的增删改查实战与DAO, ActiveRecord详解
本文将深入探讨Yii框架中的数据操作实例，重点涉及数据访问对象（DAO）、Active Record以及Relational Active Record（关联查询）。Yii是一个流行的PHP Web开发框架，它利用PDO（PHP Data Objects）进行数据库访问，...
评论 1
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值