Passing Mysql functions through Zend Framework Update Query

Question

How can I set current_timestamp in Mysql database using Zend Framework?

I do this for an update query:

$data=array("usercode"=>$username,
                "active"=>1,
                "activation_tme"=>"CURRENT_TIMESTAMP()");

The problem is that Zend framework changes CURRENT_TIMESTAMP() to 'CURRENT_TIMESTAMP()' and Mysql get it as a string and the result is 000000000000 in time column.

CP Soni CP Soni · Accepted Answer · 2012-06-21T06:29:16

Use :

$data = array("usercode"       => $username,
              "active"         => 1,
              "activation_tme" => new Zend_Db_Expr('CURRENT_TIMESTAMP()'));

Documentation: Zend_Db_Table Programmer's Reference Guide

Passing Mysql functions through Zend Framework Update Query

1 Answers