Connecting Tech Pros Worldwide Help | Site Map

MySQL date, and time entry issues.

  #1  
Old October 17th, 2006, 09:45 AM
dylan
Guest
 
Posts: n/a
Hi,


Just a few quick questions about date and time entry using html. What
are the preferred methods of entering time data into a database. Eg,
using two drop-down lists.

And also, can anyone suggest a good date picker, or a datetime picker.
(it has to be a free one)


Thanks,

Dylan

  #2  
Old October 17th, 2006, 06:25 PM
Daz
Guest
 
Posts: n/a

re: MySQL date, and time entry issues.



dylan wrote:
Quote:
Hi,
>
>
Just a few quick questions about date and time entry using html. What
are the preferred methods of entering time data into a database. Eg,
using two drop-down lists.
>
And also, can anyone suggest a good date picker, or a datetime picker.
(it has to be a free one)
>
>
Thanks,
>
Dylan
As long as you make the code so that it puts the date into the MySQL
database in the correct format, it shouldn't matter how you choose to
get the information from the user. I personally use 3 or 4 dropdown
boxes, one for the day name (if applicable), one for the week day of
the month, one for the month, and one for the year. My script
dynamically generates the dates it needs to put into the boxes when
needed, and validates it on submition.

If you were really feeling creative, it should be quite simple for you
to create your own calander, using PHP's built-in time and date
functions. This way it works and looks how you want it, rather than how
someone else felt it should look, and be used, and you can always add
more to it or remove functionality if you make it a class.

Good luck!

Daz.

Closed Thread


Similar Threads
Thread Thread Starter Forum Replies Last Post
I am totally stumped..with this on..LOAD_FILE Mysql+PHP= FSCK!! The Natural Philosopher answers 8 September 4th, 2007 09:05 PM
VB6 OR VBA & Webbrowser DOM Tiny $50 Mini Project Programmer help gunimpi answers 0 January 10th, 2007 08:55 PM
Automation of comp.lang.javascript FAQ Bart Van der Donck answers 14 July 25th, 2006 06:15 PM
MySQL 4.0.14 has been released Lenz Grimmer answers 0 July 19th, 2005 11:45 PM