INSERT function

ec_stasis · #1 (**permalink**) 08-28-2007, 10:08 AM

How can i make a query like

Code:

INSERT INTO `table` (`datetime`) VALUES (NOW())

with the ZEND_DB::insert method?
The problem is i can't insert a result of a MySQL function.
Please, don't suggest generating datetime in PHP.

borec · #2 (**permalink**) 08-28-2007, 11:42 AM

Use Zend_Db_Expr. An example from ZF docs:

Code:

<?php

$table = new Bugs();

$data = array(
    'created_on'      => new Zend_Db_Expr('CURDATE()'),
    'bug_description' => 'Something wrong',
    'bug_status'      => 'NEW'
);

ec_stasis · #3 (**permalink**) 08-28-2007, 11:52 AM

Quote:

Originally Posted by borec

Use Zend_Db_Expr. An example from ZF docs:

I remember it was somwhere in the docs, but searched for it for 2 days and couldn't find.
Thanks!
Could you provide a link where exactly it was?

borec · #4 (**permalink**) 08-28-2007, 12:12 PM

Quote:

Originally Posted by ec_stasis

Could you provide a link where exactly it was?

Sure: Zend Framework: Documentation

ec_stasis · #5 (**permalink**) 08-28-2007, 12:51 PM

Thanks for help

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode