douba1214 2014-12-10 02:58
浏览 11

如何将日期时间格式的当前时间添加到yii中的文本字段?

Here's the code i want to work with

<?php echo $form->textField($model,'email_time_created',array('readonly'=>true)); ?>

i want to automatically add the current time to my database

  • 写回答

3条回答 默认 最新

  • dongyan5706 2014-12-10 03:10
    关注

    I recommend it to add it at the database, asuming you're using MySQL you can create a trigger before saving and doing something like this:

    SET NEW.email_time_created=NOW()
    

    If not, you can do it at Yii/PHP level by adding the following function at the model class:

    public function beforeSave(){
        $this->email_time_created = CDbExpression('NOW()'); //Only in MYSQL
        return parent::beforeSave();
    }
    

    It will set the column to the current value before saving the model. Notice that it won't be shown at the form, but you can add it by JS or using php's date() at the form's view.

    评论

报告相同问题?

悬赏问题

  • ¥15 vscode的问题提问
  • ¥50 切换TabTip键盘的输入法
  • ¥15 可否在不同线程中调用封装数据库操作的类
  • ¥15 微带串馈天线阵列每个阵元宽度计算
  • ¥15 keil的map文件中Image component sizes各项意思
  • ¥20 求个正点原子stm32f407开发版的贪吃蛇游戏
  • ¥15 划分vlan后,链路不通了?
  • ¥20 求各位懂行的人,注册表能不能看到usb使用得具体信息,干了什么,传输了什么数据
  • ¥15 Vue3 大型图片数据拖动排序
  • ¥15 Centos / PETGEM