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 #172216 is a reply to message #172213]

Fri, 04 February 2011 18:00

PAkerly
Messages: 7
Registered: September 2010

Karma:

Junior Member

On Feb 4, 10:37 am, Michael Fesser <neti...@gmx.de> wrote:
> .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

Here is how I display the data on the screen so that even if they
enter 1215 it shows 12:15
.....
<?php echo time_format($_POST[txttime1])?>

Can I also somehow use this to get it into the db this way?

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: Tue Nov 26 04:26:52 GMT 2024

Total time taken to generate the page: 0.04555 seconds