Solved

getting the pc time and date to put in db

Posted on 2008-10-26
8
307 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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
Would this work?

<script type="text/javascript">

document.write(Date());

</script>
0
How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

 
LVL 7

Author Comment

by:keneso
Comment Utility
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
Comment Utility
0
 
LVL 1

Expert Comment

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

Author Comment

by:keneso
Comment Utility
>>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

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Have you tried to learn about Unicode, UTF-8, and multibyte text encoding and all the articles are just too "academic" or too technical? This article aims to make the whole topic easy for just about anyone to understand.
Nothing in an HTTP request can be trusted, including HTTP headers and form data.  A form token is a tool that can be used to guard against request forgeries (CSRF).  This article shows an improved approach to form tokens, making it more difficult to…
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…
The viewer will learn the basics of jQuery including how to code hide show and toggles. Reference your jQuery libraries: (CODE) Include your new external js/jQuery file: (CODE) Write your first lines of code to setup your site for jQuery…

744 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

16 Experts available now in Live!

Get 1:1 Help Now