PEAR::DB autoexecute and DB built-in functions
| From: | Sebastian Baran | Date: | Fri, 12 Mar 2004 11:52:43 +0000 |
| Subject: | PEAR::DB autoexecute and DB built-in functions | ||
| Groups: | php.pear.general | ||
| Request: | Send a blank email to pear-general+get-11252@lists.php.net to get a copy of this message | ||
Hello
I wonder, is there any way to use DB (mysql in my case) built-in
function in autoexecute()? For example to set datetime field with current
time using NOW() function? It gets escaped and DB treats it like a
string so wrong value is being set.
Of course I can put date("Ymdhis") as the value instead but it's not
good if php server is not the same machine as DB server (it may give
different times). I could also use simle query method.. but I prefer
autoexecute() ;-))
The same is about mysql PASSWORD() function.
--
Best regards,
Sebastian