SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
05-10-2008, 02:03 PM
| |||
| |||
 Re: add date/time? Geoff Cox schreef: > Hello, > > I have pages using AJAX and php to add data to MySQL database. > > What's the best way to add the date/time fror each addition of data? > > Thanks > > Geoff use the date/time from your server, not from 'any' client posting. -- Luuk      |
|
05-10-2008, 02:03 PM
| |||
| |||
| Re: add date/time? On Sat, 10 May 2008 09:36:40 +0200, Luuk <Luuk@invalid.lan> wrote: >Geoff Cox schreef: >> Hello, >> >> I have pages using AJAX and php to add data to MySQL database. >> >> What's the best way to add the date/time fror each addition of data? >> >> Thanks >> >> Geoff > >use the date/time from your server, not from 'any' client posting. Luuk, Thanks for your reply. I have just tried adding this to the php file and it seems to work OK. 1. in the php file $dt1 = date("Y-m-d H:i:s"); 2. to create in MySQL dt1 datetime NOT NULL default '0000-00-00 00:00:00', Is this not a good idea? How would I get the server date/time into MySQL? Cheers Geoff |
|
05-10-2008, 02:03 PM
| |||
| |||
| Re: add date/time? Geoff Cox schreef: > On Sat, 10 May 2008 09:36:40 +0200, Luuk <Luuk@invalid.lan> wrote: > >> Geoff Cox schreef: >>> Hello, >>> >>> I have pages using AJAX and php to add data to MySQL database. >>> >>> What's the best way to add the date/time fror each addition of data? >>> >>> Thanks >>> >>> Geoff >> use the date/time from your server, not from 'any' client posting. > > Luuk, > > Thanks for your reply. > > I have just tried adding this to the php file and it seems to work OK. > > 1. in the php file > > $dt1 = date("Y-m-d H:i:s"); > > 2. to create in MySQL > > dt1 datetime NOT NULL default '0000-00-00 00:00:00', > > Is this not a good idea? > > How would I get the server date/time into MySQL? > > Cheers > > Geoff http://dev.mysql.com/doc/refman/5.0/...functions.html -- Luuk |
|
05-13-2008, 06:13 PM
| |||
| |||
| Re: add date/time? On May 10, 12:37*pm, Luuk <L...@invalid.lan> wrote: > Geoff Cox schreef: > > > > > On Sat, 10 May 2008 09:36:40 +0200, Luuk <L...@invalid.lan> wrote: > > >> Geoff Cox schreef: > >>> Hello, > > >>> I have pages using AJAX and php to add data to MySQL database. > > >>> What's the best way to add the date/time fror each addition of data? > > >>> Thanks > > >>> Geoff > >> use the date/time from your server, not from 'any' client posting. > > > Luuk, > > > Thanks for your reply. > > > I have just tried adding this to the php file and it seems to work OK. > > > 1. in the php file > > > $dt1 = date("Y-m-d H:i:s"); > > > 2. to create in MySQL > > > dt1 datetime NOT NULL default '0000-00-00 00:00:00', > > > Is this not a good idea? > > > How would I get the server date/time into MySQL? > > > Cheers > > > Geoff > > http://dev.mysql.com/doc/refman/5.0/...functions.html > > -- > Luuk if you really only want to get the creation time why not use a timestamp column that automatically saves the last update time? saee: http://dev.mysql.com/doc/refman/5.0/en/timestamp.html CVH |
|
05-13-2008, 06:13 PM
| |||
| |||
| Re: add date/time? On Sat, 10 May 2008 10:26:50 +0200, Geoff Cox <gcox@freeuk.notcom> wrote: > On Sat, 10 May 2008 09:36:40 +0200, Luuk <Luuk@invalid.lan> wrote: > >> Geoff Cox schreef: >>> Hello, >>> >>> I have pages using AJAX and php to add data to MySQL database. >>> >>> What's the best way to add the date/time fror each addition of data? >>> >>> Thanks >>> >>> Geoff >> >> use the date/time from your server, not from 'any' client posting. > > Luuk, > > Thanks for your reply. > > I have just tried adding this to the php file and it seems to work OK. > > 1. in the php file > > $dt1 = date("Y-m-d H:i:s"); > > 2. to create in MySQL > > dt1 datetime NOT NULL default '0000-00-00 00:00:00', I usually rather have NULLs for no data, then an invalid one (there is no year 0). > Is this not a good idea? > How would I get the server date/time into MySQL? NOW() -- Rik Wasmus [SPAM] Now temporarily looking for some smaller PHP/MySQL projects/work to fund a self developed bigger project, mail me at rik at rwasmus.nl. [/SPAM] |
|
05-13-2008, 06:14 PM
| ||||
| ||||
| Re: add date/time? Rik Wasmus wrote: > On Sat, 10 May 2008 10:26:50 +0200, Geoff Cox <gcox@freeuk.notcom> wrote: > >> On Sat, 10 May 2008 09:36:40 +0200, Luuk <Luuk@invalid.lan> wrote: >> >>> Geoff Cox schreef: >>>> Hello, >>>> >>>> I have pages using AJAX and php to add data to MySQL database. >>>> >>>> What's the best way to add the date/time fror each addition of data? >>>> >>>> Thanks >>>> >>>> Geoff >>> >>> use the date/time from your server, not from 'any' client posting. >> >> Luuk, >> >> Thanks for your reply. >> >> I have just tried adding this to the php file and it seems to work OK. >> >> 1. in the php file >> >> $dt1 = date("Y-m-d H:i:s"); >> >> 2. to create in MySQL >> >> dt1 datetime NOT NULL default '0000-00-00 00:00:00', > > > I usually rather have NULLs for no data, then an invalid one (there is > no year 0). > >> Is this not a good idea? >> How would I get the server date/time into MySQL? > > NOW() and if you don't want to make "code" changes - add a timestamp column to your table and add a trigger to automatically update it. See the docs for BEFORE INSERT,UPDATE triggers. |
Linear Mode
