 |  |  |  |  |  |  |  |
storing date mysql
Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
Thread Solved |
•
•
Join Date: Oct 2007
Posts: 42
Reputation: 
Solved Threads: 2
Light Poster
hi all,
Donn't know much php...........
i want that when user register,his registration date store in db.i want to use server date not his system date in db.
thankx in adva...
Donn't know much php...........
i want that when user register,his registration date store in db.i want to use server date not his system date in db.
thankx in adva...
•
•
Join Date: Jul 2006
Posts: 835
Reputation:
Solved Threads: 136
Practically a Posting Shark
php already uses the server's date.
"If it is NOT source, it is NOT software."
-- NASA
-- NASA
•
•
Join Date: Jul 2007
Posts: 258
Reputation:
Solved Threads: 12
Posting Whiz in Training
•
•
•
•
i want that when user register,his registration date store in db.i want to use server date not his system date in db.
Do you need help coding this or was it just a question?
•
•
Join Date: Oct 2007
Posts: 42
Reputation:
Solved Threads: 2
Light Poster
actually i have a table user_register_mobile in mysql. [Email,MobileNumber,Registratinon_date... are some filed there.] in this table i have a field registration_date.i want to keep date so that i know when user register to our site.
i read about timestamp,some date,time functon of php,but didn't get it. but if u want explain it i am ready to learn
i read about timestamp,some date,time functon of php,but didn't get it. but if u want explain it i am ready to learn
•
•
Join Date: Jul 2007
Posts: 258
Reputation:
Solved Threads: 12
Posting Whiz in Training
In your mysql table you should set the type to 'timestamp' and then set the default to 'CURRENT TIMESTAMP'.
It doesnt really need to be explained. All that is doing is getting the date and time from the server and sticking it in a field. Just remember not to update it when you update the table, that way it will stay the day the user registrated.
Hope this helps, if you need anything else or i've miss understood dont hesitate to ask.
Also, if you need more info on timestamp and storing the date, i suggest you consult the manual. It contains some really usefull stuff.
It doesnt really need to be explained. All that is doing is getting the date and time from the server and sticking it in a field. Just remember not to update it when you update the table, that way it will stay the day the user registrated.
Hope this helps, if you need anything else or i've miss understood dont hesitate to ask.
Also, if you need more info on timestamp and storing the date, i suggest you consult the manual. It contains some really usefull stuff.
Store a UNIX Timestamp in that mysql column.
$iCurrentTime would result in an integer like: 1236884436
Which is the number of seconds since the Unix Epoch.
You can pass that integer into the php date() function and format it any way you want, and you can also calculate against it simply using basic math.
The only drawback is that it can not store dates after 01/2038 because it will exceed the size of a 32bit integer or Before 01/1970. By 2038 I imagine 64bit hardware or greater will pretty much be the norm.
php Syntax (Toggle Plain Text)
$iCurrentTime would result in an integer like: 1236884436
Which is the number of seconds since the Unix Epoch.
You can pass that integer into the php date() function and format it any way you want, and you can also calculate against it simply using basic math.
The only drawback is that it can not store dates after 01/2038 because it will exceed the size of a 32bit integer or Before 01/1970. By 2038 I imagine 64bit hardware or greater will pretty much be the norm.
If you're question/problem is solved don't forget to mark the thread as Solved!
-- Code I post is usually but not always tested. If it is tested it will be against 5.2.11 or 5.3.0
-- Code I post is usually but not always tested. If it is tested it will be against 5.2.11 or 5.3.0
•
•
Join Date: Jan 2009
Posts: 1,335
Reputation:
Solved Threads: 163
likewise sql now()
is equivalent to php time()
is equivalent to php time()
Failure is not an option It's included free
If at first you dont succeed, join the club
Of course its always in the last place you look, you dont keep looking after you find it
Please mark solved problems, solved
If at first you dont succeed, join the club
Of course its always in the last place you look, you dont keep looking after you find it
Please mark solved problems, solved
or UNIX_TIMESTAMP()
If you're question/problem is solved don't forget to mark the thread as Solved!
-- Code I post is usually but not always tested. If it is tested it will be against 5.2.11 or 5.3.0
-- Code I post is usually but not always tested. If it is tested it will be against 5.2.11 or 5.3.0
•
•
Join Date: Oct 2007
Posts: 42
Reputation:
Solved Threads: 2
Light Poster
i did as u told me in last thred,i insert a recode but when i see column Registration_date it shows 0000-00-00 00:00:00?
That is because your column type is set to datetime or timestamp not certain which one actually produces that as I don't use the mysql datetime or timestamp data type.
To store a unix timestamp you just need an INT(10)
To store a unix timestamp you just need an INT(10)
If you're question/problem is solved don't forget to mark the thread as Solved!
-- Code I post is usually but not always tested. If it is tested it will be against 5.2.11 or 5.3.0
-- Code I post is usually but not always tested. If it is tested it will be against 5.2.11 or 5.3.0
 |
Similar Threads
- PHP MySQL date question. (PHP)
- updating multiple columns in single MySQL table (PHP)
- Displaying date from mysql (PHP)
- Events / News Section - PHP/MySQL Question (PHP)
- Help with birthday MySQL Script (MySQL)
- Inserting date in format DD-MM-YYYY in MySQL (MySQL)
- HTML mail subscriiption error (PHP)
Other Threads in the PHP Forum
- Previous Thread: Mysql result in columns
- Next Thread: PHP unlink ERROR !!!
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Related Forum Features
Latest PHP Posts
- Today's Posts
- Unanswered Threads
apache api array basic beginner binary broken cakephp checkbox class cms code computing confirm cron curl customizableitems database date delete display dynamic echo email error external file files filter folder form forms forum function functions gc_maxlifetime google headmethod host href htaccess html iframe image include insert ip javascript joomla limit link login mail malfunction memmory memory menu mlm multiple mysql navigation neutrality oop parsing paypal pdf php problem query question radio random recursion remote root script search server sessions sms snippet soap source space sql syntax system table thesishelp trouble tutorial update upload url validator variable video web xml youtube
