FUDforum: comp.lang.php » validating / converting time for insertion into mysql DB??

Home » Imported messages » comp.lang.php » validating / converting time for insertion into mysql DB??

Show: Today's Messages :: Polls :: Message Navigator

Re: validating / converting time for insertion into mysql DB?? [message #172213 is a reply to message #172191]

Fri, 04 February 2011 15:37

Michael Fesser
Messages: 215
Registered: September 2010

Karma:

Senior Member

.oO(Denis McMahon)

> […]
> And you might also want to consider the following field formats:
>
> h/hh:m/mm:s/ss
> hmmss
> hhmmss
> mmss
> mss
>
> The last two give you problems. How do you tell whether 3 or 4 digits is
> hours and minutes or minutes and seconds?
>
> The real problem is that you're allowing your user to give you ambiguous
> input and then trying to make sense of it.
>
> Use more form fields: t1hours t1mins and t2hours t2mins

While this solves the ambiguity problem, it creates a usability problem
and is a pain to use. Even more ugly would be dropdown lists …

The best method for the user is a single field, and the developer should
take care of the correct parsing. You could also enforce a particular
format and reject all other ones (of course then there should be a short
note or an example near the input field how to enter the time).

> You could use select lists for hours and minutes

Arrrgh … ;-)

> although 60 element
> select lists are "too long" for some people's liking.

People who do this also eat little children.

Micha

Report message to a moderator

[Message index]

		validating / converting time for insertion into mysql DB?? By: PAkerly on Thu, 03 February 2011 15:59
		Re: validating / converting time for insertion into mysql DB?? By: Captain Paralytic on Thu, 03 February 2011 17:32
		Re: validating / converting time for insertion into mysql DB?? By: Denis McMahon on Thu, 03 February 2011 17:57
		Re: validating / converting time for insertion into mysql DB?? By: Michael Fesser on Fri, 04 February 2011 15:37
		Re: validating / converting time for insertion into mysql DB?? By: PAkerly on Fri, 04 February 2011 18:00
		Re: validating / converting time for insertion into mysql DB?? By: PAkerly on Fri, 04 February 2011 18:02
		Re: validating / converting time for insertion into mysql DB?? By: Jim Higgins on Sat, 05 February 2011 07:53
		Re: validating / converting time for insertion into mysql DB?? By: P E Schoen on Sat, 05 February 2011 08:11

Previous Topic:	pass variable in php construct
Next Topic:	Looping through Web Service results

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Nov 27 06:21:37 GMT 2024

Total time taken to generate the page: 0.03868 seconds