Automatically Insert Unixtime to a field.

[neotrode]

Hello all.

The existing "timestamp=insert" call in the fields.ini file is very useful. However, I would like to do something just like this but with a unixtime timestamp instead. Basically, I have a field in the db set to int(11). In it, I want to store the current "time()" from PHP when a record is inserted. What's the best approach? At first, I was going to look into the Xataface code itself and add a new option like "unixtimestamp=insert" but I hate hacking at the original code in case I decide to do an upgrade. How can I handle this on the application/folder side?

-Frank

[shannah]

The best way is probably to use a beforeInsert() method in the delegate class.

Code: Select all

function beforeInsert($record){
    if ( !$record->val("time_created") ){
        $record->setValue('time_created', time());
    }
}