Re: Saving NOW() in model
I use the same way as Stephen Because what if MySQL is hosted on another server than Apache/PHP ? You'll save Apache/PHP time which can be different of MySQL time (no the same meridian for instance). Of course, it's a very specific case. And my servers are time synchronised together, but some time differences appeared once or twice a year. On 22 mai, 07:47, Stephen Orr [EMAIL PROTECTED] wrote: I believe I used this method: 'last_login' = '!-NOW()' Which makes Cake stop trying to quote it. But I'm pretty sure the latest SVN revision recognises NOW() and doesn't quote it anyway. Maybe I'm confused. Steve On May 22, 2:12 am, Alex Ciobanu [EMAIL PROTECTED] wrote: Zifnab wrote: I'm trying to figure out how to implicitly make a mysql NOW() call when doing a model save...here's an example of the code: $aUserData = array( 'User' = array( 'id' = 4, 'last_login' = 'NOW()' ) ); $this-User-save( $aUserData, false, array( 'last_login' ) ); Naturally the save doesn't work, because NOW() saves as a string NOW() instead of as a mysql function NOW()How do I get it to save as a mysql function? $aUserData['User']['last_login'] = date(Y-m-d H:i:s); $this-User-save($aUserData); Not using NOW(), but does the trick. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups CakePHP group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Re: Saving NOW() in model
It doesn't really matter whether or not you obtain the date from Apache/PHP or MySQL; as long as you are consistent. On May 22, 4:01 am, djiize [EMAIL PROTECTED] wrote: I use the same way as Stephen Because what if MySQL is hosted on another server than Apache/PHP ? You'll save Apache/PHP time which can be different of MySQL time (no the same meridian for instance). Of course, it's a very specific case. And my servers are time synchronised together, but some time differences appeared once or twice a year. On 22 mai, 07:47, Stephen Orr [EMAIL PROTECTED] wrote: I believe I used this method: 'last_login' = '!-NOW()' Which makes Cake stop trying to quote it. But I'm pretty sure the latest SVN revision recognises NOW() and doesn't quote it anyway. Maybe I'm confused. Steve On May 22, 2:12 am, Alex Ciobanu [EMAIL PROTECTED] wrote: Zifnab wrote: I'm trying to figure out how to implicitly make a mysql NOW() call when doing a model save...here's an example of the code: $aUserData = array( 'User' = array( 'id' = 4, 'last_login' = 'NOW()' ) ); $this-User-save( $aUserData, false, array( 'last_login' ) ); Naturally the save doesn't work, because NOW() saves as a string NOW() instead of as a mysql function NOW()How do I get it to save as a mysql function? $aUserData['User']['last_login'] = date(Y-m-d H:i:s); $this-User-save($aUserData); Not using NOW(), but does the trick. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups CakePHP group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Re: Saving NOW() in model
yes you're right! I care about that because we have 1 MySQL central server and several servers that request it. And we have not always full control of theses servers (apps can be coded by others teams/companies). On 22 mai, 14:16, Joel Perras [EMAIL PROTECTED] wrote: It doesn't really matter whether or not you obtain the date from Apache/PHP or MySQL; as long as you are consistent. On May 22, 4:01 am, djiize [EMAIL PROTECTED] wrote: I use the same way as Stephen Because what if MySQL is hosted on another server than Apache/PHP ? You'll save Apache/PHP time which can be different of MySQL time (no the same meridian for instance). Of course, it's a very specific case. And my servers are time synchronised together, but some time differences appeared once or twice a year. On 22 mai, 07:47, Stephen Orr [EMAIL PROTECTED] wrote: I believe I used this method: 'last_login' = '!-NOW()' Which makes Cake stop trying to quote it. But I'm pretty sure the latest SVN revision recognises NOW() and doesn't quote it anyway. Maybe I'm confused. Steve On May 22, 2:12 am, Alex Ciobanu [EMAIL PROTECTED] wrote: Zifnab wrote: I'm trying to figure out how to implicitly make a mysql NOW() call when doing a model save...here's an example of the code: $aUserData = array( 'User' = array( 'id' = 4, 'last_login' = 'NOW()' ) ); $this-User-save( $aUserData, false, array( 'last_login' ) ); Naturally the save doesn't work, because NOW() saves as a string NOW() instead of as a mysql function NOW()How do I get it to save as a mysql function? $aUserData['User']['last_login'] = date(Y-m-d H:i:s); $this-User-save($aUserData); Not using NOW(), but does the trick. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups CakePHP group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Re: Saving NOW() in model
Ok, well for consistency's sake, do you know if cakePHP's automatic filling of 'created', 'updated', and 'modified' fields uses PHP's time or MYSQL's time? Thanks for all the quick responses everyone :) On May 22, 7:11 am, djiize [EMAIL PROTECTED] wrote: yes you're right! I care about that because we have 1 MySQL central server and several servers that request it. And we have not always full control of theses servers (apps can be coded by others teams/companies). On 22 mai, 14:16, Joel Perras [EMAIL PROTECTED] wrote: It doesn't really matter whether or not you obtain the date from Apache/PHP or MySQL; as long as you are consistent. On May 22, 4:01 am, djiize [EMAIL PROTECTED] wrote: I use the same way as Stephen Because what if MySQL is hosted on another server than Apache/PHP ? You'll save Apache/PHP time which can be different of MySQL time (no the same meridian for instance). Of course, it's a very specific case. And my servers are time synchronised together, but some time differences appeared once or twice a year. On 22 mai, 07:47, Stephen Orr [EMAIL PROTECTED] wrote: I believe I used this method: 'last_login' = '!-NOW()' Which makes Cake stop trying to quote it. But I'm pretty sure the latest SVN revision recognises NOW() and doesn't quote it anyway. Maybe I'm confused. Steve On May 22, 2:12 am, Alex Ciobanu [EMAIL PROTECTED] wrote: Zifnab wrote: I'm trying to figure out how to implicitly make a mysql NOW() call when doing a model save...here's an example of the code: $aUserData = array( 'User' = array( 'id' = 4, 'last_login' = 'NOW()' ) ); $this-User-save( $aUserData, false, array( 'last_login' ) ); Naturally the save doesn't work, because NOW() saves as a string NOW() instead of as a mysql function NOW()How do I get it to save as a mysql function? $aUserData['User']['last_login'] = date(Y-m-d H:i:s); $this-User-save($aUserData); Not using NOW(), but does the trick. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups CakePHP group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Re: Saving NOW() in model
Most likely uses php's time (didn't check), but a good reason for this is to allow supporting of multiple databases (or even flat files) instead of db specific functions. On May 22, 10:25 am, Zifnab [EMAIL PROTECTED] wrote: Ok, well for consistency's sake, do you know if cakePHP's automatic filling of 'created', 'updated', and 'modified' fields uses PHP's time or MYSQL's time? Thanks for all the quick responses everyone :) On May 22, 7:11 am, djiize [EMAIL PROTECTED] wrote: yes you're right! I care about that because we have 1 MySQL central server and several servers that request it. And we have not always full control of theses servers (apps can be coded by others teams/companies). On 22 mai, 14:16, Joel Perras [EMAIL PROTECTED] wrote: It doesn't really matter whether or not you obtain the date from Apache/PHP or MySQL; as long as you are consistent. On May 22, 4:01 am, djiize [EMAIL PROTECTED] wrote: I use the same way as Stephen Because what if MySQL is hosted on another server than Apache/PHP ? You'll save Apache/PHP time which can be different of MySQL time (no the same meridian for instance). Of course, it's a very specific case. And my servers are time synchronised together, but some time differences appeared once or twice a year. On 22 mai, 07:47, Stephen Orr [EMAIL PROTECTED] wrote: I believe I used this method: 'last_login' = '!-NOW()' Which makes Cake stop trying to quote it. But I'm pretty sure the latest SVN revision recognises NOW() and doesn't quote it anyway. Maybe I'm confused. Steve On May 22, 2:12 am, Alex Ciobanu [EMAIL PROTECTED] wrote: Zifnab wrote: I'm trying to figure out how to implicitly make a mysql NOW() call when doing a model save...here's an example of the code: $aUserData = array( 'User' = array( 'id' = 4, 'last_login' = 'NOW()' ) ); $this-User-save( $aUserData, false, array( 'last_login' ) ); Naturally the save doesn't work, because NOW() saves as a string NOW() instead of as a mysql function NOW()How do I get it to save as a mysql function? $aUserData['User']['last_login'] = date(Y-m-d H:i:s); $this-User-save($aUserData); Not using NOW(), but does the trick. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups CakePHP group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Re: Saving NOW() in model
I use date(DATE_ATOM) for date / timestamp fields, one could argue that there might be different time-zone between the web-server and the db server :-) If you really need the DB timestamp, better using '!- NOW()' as Stephen mentionned. On May 22, 4:35 pm, fr3nch13 [EMAIL PROTECTED] wrote: Most likely uses php's time (didn't check), but a good reason for this is to allow supporting of multiple databases (or even flat files) instead of db specific functions. On May 22, 10:25 am, Zifnab [EMAIL PROTECTED] wrote: Ok, well for consistency's sake, do you know if cakePHP's automatic filling of 'created', 'updated', and 'modified' fields uses PHP's time or MYSQL's time? Thanks for all the quick responses everyone :) On May 22, 7:11 am, djiize [EMAIL PROTECTED] wrote: yes you're right! I care about that because we have 1 MySQL central server and several servers that request it. And we have not always full control of theses servers (apps can be coded by others teams/companies). On 22 mai, 14:16, Joel Perras [EMAIL PROTECTED] wrote: It doesn't really matter whether or not you obtain the date from Apache/PHP or MySQL; as long as you are consistent. On May 22, 4:01 am, djiize [EMAIL PROTECTED] wrote: I use the same way as Stephen Because what if MySQL is hosted on another server than Apache/PHP ? You'll save Apache/PHP time which can be different of MySQL time (no the same meridian for instance). Of course, it's a very specific case. And my servers are time synchronised together, but some time differences appeared once or twice a year. On 22 mai, 07:47, Stephen Orr [EMAIL PROTECTED] wrote: I believe I used this method: 'last_login' = '!-NOW()' Which makes Cake stop trying to quote it. But I'm pretty sure the latest SVN revision recognises NOW() and doesn't quote it anyway. Maybe I'm confused. Steve On May 22, 2:12 am, Alex Ciobanu [EMAIL PROTECTED] wrote: Zifnab wrote: I'm trying to figure out how to implicitly make a mysql NOW() call when doing a model save...here's an example of the code: $aUserData = array( 'User' = array( 'id' = 4, 'last_login' = 'NOW()' ) ); $this-User-save( $aUserData, false, array( 'last_login' ) ); Naturally the save doesn't work, because NOW() saves as a string NOW() instead of as a mysql function NOW()How do I get it to save as a mysql function? $aUserData['User']['last_login'] = date(Y-m-d H:i:s); $this-User-save($aUserData); Not using NOW(), but does the trick. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups CakePHP group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Saving NOW() in model
I'm trying to figure out how to implicitly make a mysql NOW() call when doing a model save...here's an example of the code: $aUserData = array( 'User' = array( 'id' = 4, 'last_login' = 'NOW()' ) ); $this-User-save( $aUserData, false, array( 'last_login' ) ); Naturally the save doesn't work, because NOW() saves as a string NOW() instead of as a mysql function NOW()How do I get it to save as a mysql function? --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups CakePHP group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Re: Saving NOW() in model
Try: $aUserData = array( 'User' = array( 'id' = 4, 'last_login = NOW()' ) ); On Wed, May 21, 2008 at 6:55 PM, Zifnab [EMAIL PROTECTED] wrote: I'm trying to figure out how to implicitly make a mysql NOW() call when doing a model save...here's an example of the code: $aUserData = array( 'User' = array( 'id' = 4, 'last_login' = 'NOW()' ) ); --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups CakePHP group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Re: Saving NOW() in model
Just get the PHP equivalent timestamp; it'll be easier and yield the same result, unless your application takes minutes/hours/days to insert or update a DB row. In which case, you have much bigger problems ;-) $aUserData = array( 'User' = array( 'id' = 4, 'last_login' = date('Y-m-d h:i:s') ) ); Where I believe the MySQL datetime is in the format Year-Month-Day Hour:Minute:Second; please forgive me if I'm wrong, it's late here. -Joel. On May 21, 6:55 pm, Zifnab [EMAIL PROTECTED] wrote: I'm trying to figure out how to implicitly make a mysql NOW() call when doing a model save...here's an example of the code: $aUserData = array( 'User' = array( 'id' = 4, 'last_login' = 'NOW()' ) ); $this-User-save( $aUserData, false, array( 'last_login' ) ); Naturally the save doesn't work, because NOW() saves as a string NOW() instead of as a mysql function NOW()How do I get it to save as a mysql function? --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups CakePHP group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Re: Saving NOW() in model
Zifnab wrote: I'm trying to figure out how to implicitly make a mysql NOW() call when doing a model save...here's an example of the code: $aUserData = array( 'User' = array( 'id' = 4, 'last_login' = 'NOW()' ) ); $this-User-save( $aUserData, false, array( 'last_login' ) ); Naturally the save doesn't work, because NOW() saves as a string NOW() instead of as a mysql function NOW()How do I get it to save as a mysql function? $aUserData['User']['last_login'] = date(Y-m-d H:i:s); $this-User-save($aUserData); Not using NOW(), but does the trick. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups CakePHP group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Re: Saving NOW() in model
I believe I used this method: 'last_login' = '!-NOW()' Which makes Cake stop trying to quote it. But I'm pretty sure the latest SVN revision recognises NOW() and doesn't quote it anyway. Maybe I'm confused. Steve On May 22, 2:12 am, Alex Ciobanu [EMAIL PROTECTED] wrote: Zifnab wrote: I'm trying to figure out how to implicitly make a mysql NOW() call when doing a model save...here's an example of the code: $aUserData = array( 'User' = array( 'id' = 4, 'last_login' = 'NOW()' ) ); $this-User-save( $aUserData, false, array( 'last_login' ) ); Naturally the save doesn't work, because NOW() saves as a string NOW() instead of as a mysql function NOW()How do I get it to save as a mysql function? $aUserData['User']['last_login'] = date(Y-m-d H:i:s); $this-User-save($aUserData); Not using NOW(), but does the trick. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups CakePHP group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---