?
Solved

getting the pc time and date to put in db

Posted on 2008-10-26
8
Medium Priority
?
315 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
Get MongoDB database support online, now!

At Percona’s web store you can order your MongoDB database support needs in minutes. No hassles, no fuss, just pick and click. Pay online with a credit card. Handle your MongoDB database support now!

 
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

Want to be a Web Developer? Get Certified Today!

Enroll in the Certified Web Development Professional course package to learn HTML, Javascript, and PHP. Build a solid foundation to work toward your dream job!

Question has a verified solution.

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

FAQ pages provide a simple way for you to supply and for customers to find answers to the most common questions about your company. Here are six reasons why your company website should have a FAQ page
When it comes to security, close monitoring is a must. According to WhiteHat Security annual report, a substantial number of all web applications are vulnerable always. Monitis offers a new product - fully-featured Website security monitoring and pr…
This video teaches users how to migrate an existing Wordpress website to a new domain.
The viewer will learn the basics of jQuery, including how to invoke it on a web page. 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.: (CODE)
Suggested Courses

800 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