Zend Framework Table插入MySQL Expression

Question

Just wanted to ask if there is an easyer way to do this (to use the FROM_UNIXTIME expression):

$table = $this->getDbTable();
$db = $table->getAdapter();

$table->insert(array(
    'date'=>new Zend_Db_Expr($db->quoteInto('FROM_UNIXTIME(?)', time())),
    'name'=>$name,
    'password'=>'',
    'passworddate'=>'0000-00-00 00:00:00'
));

I mean it's a lot overhead just to use FROM_UNIXTIME. And it's looks not very clean in my opptinion.

Answer 1

You can simply use MySQL's NOW() function unless there's a time difference between your application and database servers.

'date' => new Zend_Db_Expr('NOW()'),

If the application server time takes priority, why not simply try

'date' => date('Y-m-d H:i:s'),