ZF2 Zend\Db Insert/Update Using Mysql Expression (Zend\Db\Sql\Expression?)

Question

Is there any way to include MySQL expressions like NOW() in the current build of ZF2 (2.0.0beta4) through Zend\Db and/or TableGateway insert()/update() statements?

Here is a related post on the mailing list, though it hasn't been answered: http://zend-framework-community.634137.n4.nabble.com/Zend-Db-Expr-and-Transactions-in-ZF2-Db-td4472944.html

It appears that ZF1 used something like:

    $data = array( 
        'update_time'   => new \Zend\Db\Expr("NOW()") 
    );

And after looking through Zend\Db\Sql\Expression I tried:

    $data = array(
        'update_time' => new \Zend\Db\Sql\Expression("NOW()"),
    );

But get the following error:

Catchable fatal error: Object of class Zend\Db\Sql\Expression could not be converted to string in /var/www/vendor/ZF2/library/Zend/Db/Adapter/Driver/Pdo/Statement.php on line 256

As recommended here: http://zend-framework-community.634137.n4.nabble.com/ZF2-beta3-Zend-Db-Sql-Insert-new-Expression-now-td4536197.html I'm currently just setting the date with PHP code, but I'd rather use the MySQL server as the single source of truth for date/times.

    $data = array(
        'update_time' => date('Y-m-d H:i:s'),
    );

Thanks, I appreciate any input!

Joe Cheng · Accepted Answer · 2013-05-07 02:58:24Z

11

Zend_Db_Sql_Expression works for me now.

$data = array(
    'update_time' => new \Zend\Db\Sql\Expression("NOW()"),
);

answered May 7, 2013 at 2:58

Joe Cheng

9,7044 gold badges29 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Max Over a year ago

Would you mind adding a little more info around this answer? Thank you

Boby · Accepted Answer · 2012-06-27 20:27:59Z

2

I am not sure if they fixed this in the latest updates, but it was a know bug and even if they said it was fixed, for me it still didn't work after the fix.

answered Jun 27, 2012 at 20:27

Boby

8325 silver badges9 bronze badges

2 Comments

Alex Ross Over a year ago

Thanks for the response and link, I'll update to the latest source and see if it persists.

ufk Over a year ago

zend framework 2.0 beta 6 and still no solution to this problem!?!?!

mirapole · Accepted Answer · 2013-12-02 13:16:18Z

0

It works for me too. Maybe, your problem was like mine. The string error conversion was because the parameter that I passed to method was elements of array and not the array. Check this and have sure that you are passing $object->method($array).

answered Dec 2, 2013 at 13:16

mirapole

1,0117 silver badges17 bronze badges

Comments

tomekohio · Accepted Answer · 2017-11-20 11:48:06Z

0

You can try:

\Zend\Db\Sql\Predicate\Literal();
//or
\Zend\Db\Sql\Literal();
------------------------------------
$data = array(
    'update_time' => new \Zend\Db\Sql\Literal("NOW()"),
);

https://framework.zend.com/manual/2.2/en/modules/zend.db.sql.html#literal-literal

answered Nov 20, 2017 at 11:48

tomekohio

91 bronze badge

Collectives™ on Stack Overflow

ZF2 Zend\Db Insert/Update Using Mysql Expression (Zend\Db\Sql\Expression?)

4 Answers 4

1 Comment

2 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related