Function to determine if date field is correct on form

[webguync]

Hi, I need to add a function for a date field on a form being submitted to MySQL DB. Something similar to this for a website field, except it shoudl make sure the format is in 01/05/2010 or 2numbers/2 numbers/4 numbers format...

 

if(!mb_eregi("^[a-zA-Z0-9-#_.+!*'(),/&:;=?@]*$", $website))
		$this->setError('website', 'invalid website');	
	elseif(mb_strlen(trim($website)) > 120)
		$this->setError('website', 'too long! 120 characters');

 

thanks in advance for any assistance.

[Pikachu2000]

If it's going into a database, shouldn't the format be YYYY-MM-DD?

[ManiacDan]

Seconded, the MySQL data format is very close to ISO 8601: "YYYY-MM-DD HH:ii:ss.uuuu"

 

Also, ereg is deprecated, use preg_*

 

-Dan

[webguync]

well, yea, but this is just for the client side. I think most users are used to putting in dates as mm/dd/yyyy format. At least in the US. In the DB it can display YYYY-MM-DD.

[Pikachu2000]

Depending on how you have the form set up, you may be able to simply use checkdate()

[ManiacDan]

This is why we have JavaScript date pickers.  Have the user click the date on a calendar, and the JS fills in YYYY-MM-DD for you.

 

Validating user input has to be by hand, usually with explode().  How can you tell if 3/14/11 is valid?  If they live in England, it's not valid.

 

-Dan

[webguync]

Thanks I will look into a JS datepicker