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 #172222 is a reply to message #172189]

Sat, 05 February 2011 08:11

P E Schoen
Messages: 86
Registered: January 2011

Karma:

Member

"PAkerly" wrote in message
news:cc56a3eb-87fe-4d5f-bd8e-23c19238abfa(at)g1g2000prb(dot)googlegroups(dot)com...

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

You could use a date/time picker where the user selects a date from a
calendar and the time can be adjusted with spin controls. See an example at:
http://www.pauleschoen.com/SCGBG/EventSubmit.htm

There is a text box where the user can also directly edit it but I use a
simple Javascript format checker in case they screw up:

else if ( (Form1.Start_DT.value.charAt(2) != "/") ||
(Form1.Start_DT.value.charAt(5) != "/") ||
(Form1.Start_DT.value.charAt(10) != " ") ||
(Form1.Start_DT.value.charAt(13) != ":") )
{
alert ("Please use mm/dd/yyyy hh:mm Format for Date/Time");
Form1.Start_DT.focus();
}
else { //Everything seems OK
with (Form1.Start_DT) { //Update hidden variable to be sent
Form1.Entry_Start_DT.value =
value.substring(6,10) + "-" +
value.substring(0,2) + "-" +
value.substring(3,5) + "T" +
value.substring(11,13) + ":" +
value.substring(14,16);
}

Not the best, but it works. Note that I format the date in standard format:
yyyymmddThh:mm

I might use some of the other ideas submitted here.

Thanks,

Paul

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: Fri Sep 20 09:42:24 GMT 2024

Total time taken to generate the page: 0.06234 seconds