Yii Framework Wiki
Difference between
#8 and
#9 of
How to automate timestamps in ActiveRecord models
Revision #9 has been created by Maurizio Domba Cerin on Jun 17, 2011, 10:16:17 AM with the memo:
changed text to mention Gii instead of yiic, and explained better the beforeSave() variant
« previous (#8) next (#10) »
Changes
Title unchanged
How to automate timestamps in ActiveRecord models
Category unchanged
Tutorials
Yii version unchanged
Tags unchanged
Content changed
There are dozens ofmany ways to automate the setting of timestamps in yii ActiveRecord models. Two ways you can dof thisem are:
1. Via rules()
2. Via beforeSave()
To start off we need to create a database table.
[sql]
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
Following this we'll gener;
After we have the table we need to createthea model with the Yii shell tool:
model Node Nodes
To create the crud functionality we need to type this:
crud Nodeand CRUD for it by using Gii.
Check the guide on [How to generate model and CRUD with Gii](http://www.yiiframework.com/doc/guide/1.1/en/quickstart.first-app#implementing-crud-operations "How to generate model and CRUD with Gii").
The first way you can do it is via your model's rules. Here is an example.
$this->created = new CDbExpression('NOW()');
else $this->modified = new CDbExpression('NOW()'); return parent::beforeSave(); } Note that in the above code, when creating a new record only the 'created' field will be assigned/updated, while the 'modified' record will be assigned/updated only when updating an existing record.
If you want to assign/update the 'modified' field even when creating a new record... use this code:
[php]
public function beforeSave() {
if ($this->isNewRecord)
$this->created = new CDbExpression('NOW()');
$this->modified = new CDbExpression('NOW()');
return parent::beforeSave();
}
These are simple and elegant solutions to this issue.
[sql]
[...]
`modified` datetime NOT NULL,PRIMARY KEY (`id`)
)
Following this we'll gener
After we have the table we need to create
model Node Nodes
To create the crud functionality we need to type this:
crud Node
Check the guide on [How to generate model and CRUD with Gii](http://www.yiiframework.com/doc/guide/1.1/en/quickstart.first-app#implementing-crud-operations "How to generate model and CRUD with Gii").
The first way you can do it is via your model's rules. Here is an example.
[...]
if ($this->isNewRecord)$this->created = new CDbExpression('NOW()');
else $this->modified = new CDbExpression('NOW()'); return parent::beforeSave(); } Note that in the above code, when creating a new record only the 'created' field will be assigned/updated, while the 'modified' record will be assigned/updated only when updating an existing record.
If you want to assign/update the 'modified' field even when creating a new record... use this code:
[php]
public function beforeSave() {
if ($this->isNewRecord)
$this->created = new CDbExpression('NOW()');
$this->modified = new CDbExpression('NOW()');
return parent::beforeSave();
}
These are simple and elegant solutions to this issue.
34 followers
Viewed: 181 456 times
Version: 1.1
Category: Tutorials
Written by: dalip
Last updated by: Yang He
Created on: Feb 14, 2009
Last updated: 12 years ago
Revisions
View all history-
12 years ago by
Yang He Removed broken link to Chinese translati...
-
12 years ago by
Narretz fixed the url for possibility 3
-
12 years ago by
Narretz I added a reference to the CTimestampBeh...
-
13 years ago by
Darwin Wen Add chinese version
-
13 years ago by
Maurizio Domba Cerin changed text to mention Gii instead of y...
-
13 years ago by
nye.cat Deleted 'else' in the beforeSave Example
-
15 years ago by
mishhh changed title for organizing purpose
-
15 years ago by
wei add new line to remove horizontal scroll...
-
16 years ago by
jonah we are XSS free
-
16 years ago by
jonah making sure this site is XSS free