我正在创建一个 yii 应用程序,我想将数据插入到数据库中,但问题是如何插入日期和时间。在我从数据库中删除日期时间列之前,它无法插入每个详细信息。

这是 Controller 类:

<?php
namespace app\controllers;

use amnah\yii2\user\models\User;
use app\models\Influence;
use Yii;
use yii\filters\AccessControl;
use yii\filters\VerbFilter;
use amnah\yii2\user\controllers\DefaultController as SuperDefault;

class DefaultController extends SuperDefault {

    public function behaviors()
    {
        return [
            'access' => [
                'class' => AccessControl::className(),
                'rules' => [
                    [
                        'actions' => ['index', 'confirm', 'resend', 'logout'],
                        'allow' => true,
                        'roles' => ['?', '@'],
                    ],
                    [
                        'actions' => ['account', 'profile','contact', 'resend-change', 'cancel','advertiser_dashboard','influencer_dashboard', 'influenza_info', 'advertiser'],
                        'allow' => true,
                        'roles' => ['@'],
                    ],
                    [
                        'actions' => ['login', 'register','contact','influencer_dashboard', 'advertiser_dashboard','register_advert','forgot', 'reset', 'login-email', 'login-callback'],
                        'allow' => true,
                        'roles' => ['?'],
                    ],
                ],
            ],
            'verbs' => [
                'class' => VerbFilter::className(),
                'actions' => [
                    'logout' => ['post', 'get'],
                ],
            ],
        ];
    }


    public function actionInfluenza_info()
    {
        $u_id = Yii::$app->user->id;
        $user = User::findOne($u_id);
           $influence= new Influence();

        if ($influence->load(Yii::$app->request->post())) {

                    $influence_data = Yii::$app->request->post('Influence', []);
                 $influence->firstname = $influence_data['firstname'];
                 $influence->lastname = $influence_data['lastname'];
                 $influence->email = $influence_data['email'];
                 $influence->city = $influence_data['city'];
                 $influence->type = $influence_data['type'];
                 $influence->pic = $influence_data['pic'];
                 $influence->address = $influence_data['address'];
                 $influence->country = $influence_data['country'];
                 $influence->gender = $influence_data['gender'];
                   $influence->id = $u_id;

                  $influence->save();

            Yii::$app->session->setFlash("Profile-success", Yii::t("user", "Profile updated"));
            return $this->refresh();
        } else {
            return $this->render('influenza_info', [
                 'user' => $user,

                  'influence' =>$influence
            ]);
        }

    }

    }

这是模型类
  <?php

namespace app\models;

use Yii;
use app\controllers\Expression;
/**
 * This is the model class for table "influence".
 *
 * @property integer $id
 * @property integer $user_id
 * @property string $firstname
 * @property string $lastname
 * @property string $email
 * @property string $city
 * @property string $type
 * @property string $pic
 * @property string $address
 * @property string $country
 * @property string $gender
 */
class Influence extends \yii\db\ActiveRecord
{
    /**
     * @inheritdoc
     */
    public static function tableName()
    {
        return 'influence';
    }

    /**
     * @inheritdoc
     */
    public function rules()
    {
        return [
            [['id', 'user_id', 'firstname', 'lastname', 'email', 'city', 'type', 'pic', 'address', 'country', 'gender'], 'required'],
            [['id', 'user_id'], 'integer'],
       [['firstname', 'lastname', 'email', 'city', 'type', 'pic', 'address', 'country', 'gender'], 'string', 'max' => 30]
        ];
    }
public function beforeSave($insert)
{
if ($this->isNewRecord) { // new record only, otherwise time is inserted every time this record is updated
    $this->created_at = new Expression('NOW()');
}
parent::afterSave($insert);
}
    /**
     * @inheritdoc
     */
    public function attributeLabels()
    {
        return [
            'id' => 'ID',
            'user_id' => 'User ID',
            'firstname' => 'Firstname',
            'lastname' => 'Lastname',
            'email' => 'Email',
            'city' => 'City',
            'type' => 'Type',
            'pic' => 'Pic',
            'address' => 'Address',
            'country' => 'Country',
            'gender' => 'Gender',
            'created_at' => 'Created_at',
        ];
    }
}

表 sql
CREATE TABLE `influence` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `firstname` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  `lastname` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  `email` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  `city` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  `type` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  `pic` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  `address` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  `country` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  `gender` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  `created` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP
) ;

如何让它自动插入。如果我从我的管理员那里尝试它可以工作并获取日期和时间。但 yii 则不然。

最佳答案

为此,我从所需规则中删除了 created 属性。
然后我创建了一个 beforeSave() 方法,并在一个新记录上用 Expression 插入它。

public function beforeSave($insert)
{
if ($this->isNewRecord) { // new record only, otherwise time is inserted every time this record is updated
    $this->created = new Expression('NOW()');
}
parent::beforeSave($insert);
}

确保将 Expression 导入模型

更新
更新代码感谢@crafter

关于php - Yii2在sql中插入日期和时间,我们在Stack Overflow上找到一个类似的问题:https://stackoverflow.com/questions/34532404/

10-16 14:57
查看更多