Solved

getting the pc time and date to put in db

Posted on 2008-10-26
8
308 Views
Last Modified: 2013-12-13
Hi,

I have a mysql db on the site server, and add/update it thru a php webpage, two of the db fields are time related, I put the 'datetime' for the type, but it becomes cumbersome to each time insert yyyy-mm-dd hh:mm, so I'd like to just click on a button, and get the date and time from the pc which I input the data, to fill the related form field.

How can I do that?

Thank you
0
Comment
Question by:keneso
  • 5
  • 2
8 Comments
 
LVL 8

Expert Comment

by:MatthiasVance
ID: 22808900
You could use JavaScript to fill in the form field. Just use the Date class.

Kind regards,

Matthias Vance
0
 
LVL 1

Expert Comment

by:Bolter99
ID: 22809557
you can use "UNIX_TIMESTAMP()" in your mysql query.

Example:
INSERT INTO tbl_name (timestamp) VALUES (UNIX_TIMESTAMP());

When you re-call the data then use the date() function in php to convert it to a date.
0
 
LVL 7

Author Comment

by:keneso
ID: 22812527
Thank you both.
I think I should have asked for the code snippet, I had thought about the javascript, but don't know how to do it.
0
 
LVL 7

Author Comment

by:keneso
ID: 22812621
Would this work?

<script type="text/javascript">

document.write(Date());

</script>
0
DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

 
LVL 7

Author Comment

by:keneso
ID: 22812693
I've put the above in the head of the page, and it does show the time, date, and bunch of info on DST, which I don't need BTW.

How do I put it in the form as a button to click to fill the field?
0
 
LVL 7

Accepted Solution

by:
keneso earned 0 total points
ID: 22813146
0
 
LVL 1

Expert Comment

by:Bolter99
ID: 22816984
What format do you want the date to display? DD-MM-YY 00:00 ?
0
 
LVL 7

Author Comment

by:keneso
ID: 22821701
>>DD-MM-YY 00:00 ?

Yes that would be fine.
Please note I have found what does work, though a little overkill, hence I am wiling to give the poinks if I get a simpler, and most important full working code.

Thank you.
0

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Build an array called $myWeek which will hold the array elements Today, Yesterday and then builds up the rest of the week by the name of the day going back 1 week.   (CODE) (CODE) Then you just need to pass your date to the function. If i…
Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
This video teaches users how to migrate an existing Wordpress website to a new domain.
Any person in technology especially those working for big companies should at least know about the basics of web accessibility. Believe it or not there are even laws in place that require businesses to provide such means for the disabled and aging p…

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now