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

validating / converting time for insertion into mysql DB?? [message #172189]

Thu, 03 February 2011 15:59

PAkerly
Messages: 7
Registered: September 2010

Karma:

Junior Member

I've got a form where users enter in time into a textbox.
txttime1
txttime2

usually for 12:15 the user enters 1215 without the :, so basically the
user does not enter :

and in the db the time goes into the db as: 00:12:15 instead of
12:15:00

So what I want to do is somehow fix the time so that when a user
enters it as 1215, it changes the time to 12:15

so than the $_POST[txttime1] would be correct at 12:15 and not 1215

How would this be done?
TIA

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:46:29 GMT 2024

Total time taken to generate the page: 0.17850 seconds