Solved

getting the pc time and date to put in db

Posted on 2008-10-26
8
311 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Resolve Critical IT Incidents Fast

If your data, services or processes become compromised, your organization can suffer damage in just minutes and how fast you communicate during a major IT incident is everything. Learn how to immediately identify incidents & best practices to resolve them quickly and effectively.

 
LVL 7

Author Comment

by:keneso
ID: 22812621
Would this work?

<script type="text/javascript">

document.write(Date());

</script>
0
 
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

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!

Question has a verified solution.

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

Suggested Solutions

Does your audience prefer people in photos or no people? How can you best highlight what you’re selling? What are your competitors doing, and what can you do that is different and unique from them?  Continue reading to learn how to make your images …
Many old projects have bad code, but the budget doesn't exist to rewrite the codebase. You can update this code to be safer by introducing contemporary input validation, sanitation, and safer database queries.
The viewer will learn how to dynamically set the form action using jQuery.
The viewer will learn how to count occurrences of each item in an array.

749 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