date field

thread_PHP

hi
i enter date manually in the form but it is accepting illegal formats like "2005-04-31" in the form but not storing them in database showing null field there. How to estrict the user if he enters like this in the form validation

thanks in advance

Weedpacket

You mean you want to check to see if a date is valid? Something like what [man]checkdate[/man] does?

thread_PHP

yes i want to check the date if the input is 2005-04-31 it should throw me error and should halt my execution. in checkdate function what is meant by gregarian date

Houdini

I might be a little off here but 4/31/2005 is an invalid date but 2005-04-31 is a legal format for MySQL database as is 04-31-2005 or 04/31/2005 even 04 31 2005 (since MySQL expects dates as mmddyyyy) So it seems that you are just wanting to check the date to see if it is valid which you would do with

var_dump(checkdate(4, 31, 2005));

which will output

bool(false)

So is what you are trying to do is validate a date?

thread_PHP

hi Houdini
Thanks for your reply, i am trying to validate the date field. I am validating the date field the input like 2005-04-31 like that should not be accepted

thread_PHP

hi Houdini

MySQL allows you to store some wrong date values into DATE and DATETIME
columns (like '2000-02-31' or '2000-02-00'). The idea is that it’s not the job
of the SQL server to validate dates. If MySQL can store a date value and retrieve
exactly the same value, MySQL stores it as given. If the date is totally wrong
(outside the server’s ability to store it), the special date value '0000-00-00' is
stored in the column instead.
If you set an ENUM column to an unsupported value, it is set to the error value
empty string, with numeric value 0.

I want exactly like this if the user has entered wrong date the field should the special date value '0000-00-00' is stored in the column instead . and it should prompt the user to enter the correct date.

and what is ¡ If you set an ENUM column to an unsupported value, it is set to the error value
empty string, with numeric value 0.

The MySQL server performs only basic checking on the validity of a date: The ranges
for year, month, and day are 1000 to 9999, 00 to 12, and 00 to 31. Any date containing
parts not within these ranges is subject to conversion to '0000-00-00'. Please note
that this still allows you to store invalid dates such as '2002-04-31'. To ensure a date
is valid, perform a check in your application.

Weedpacket

thread_PHP wrote:
yes i want to check the date if the input is 2005-04-31 it should throw me error and should halt my execution. in checkdate function what is meant by gregarian date

http://www.google.com/search?q=Gregorian+calendar