• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 317
  • Last Modified:

getting the pc time and date to put in db

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
keneso
Asked:
keneso
  • 5
  • 2
1 Solution
 
MatthiasVanceCommented:
You could use JavaScript to fill in the form field. Just use the Date class.

Kind regards,

Matthias Vance
0
 
Bolter99Commented:
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
 
kenesoAuthor Commented:
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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
kenesoAuthor Commented:
Would this work?

<script type="text/javascript">

document.write(Date());

</script>
0
 
kenesoAuthor Commented:
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
 
kenesoAuthor Commented:
0
 
Bolter99Commented:
What format do you want the date to display? DD-MM-YY 00:00 ?
0
 
kenesoAuthor Commented:
>>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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 5
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now