records with invalid dates being inserted into database

[ramblinollie]

My application uses strtotime to check that a user entered date of birth value is not in the future. I'm aware that strtotime does not work for dates > 2037 so I have written a condition to take this into account. A number of rogue dates have still found there way into the database ALL with dates later than 2041. It's very weird. Can anyone explain why this might be happening? Here's the code...

[FONT="Courier New"]$dt_dob = $str_year . '-' . $str_month . '-' . $str_day;

$dt_today = strtotime(date("Y-m-d"));
$dt_dob_check = strtotime($dt_dob);

if (($dt_dob_check > $dt_today) || (int)$str_year > 2037) {
$bool_date_error = true;
}[/FONT]

Thanks in advance for your help.

[NogDog]

If you have the PEAR Date package installed (or can install it), you could use the Date_Calc class and not have to worry about OS-dependent timestamp restrictions:

require_once 'Date/Calc.php';

function isValidBirthDate($year, $month, $day)
{
   $valid = false;
   $dc = new Date_Calc();
   if ($dc->isValidDate($day, $month, $year))
   {
      list($y, $m, $d) = explode('-', date('Y-m-d'));
      if ($dc->compareDates($day, $month, $year, $d, $m, $y) <= 0)
      {
         $valid = true;
      }
   }
   return $valid;
}

[ramblinollie]

NogDog;10900231 wrote:

If you have the PEAR Date package installed (or can install it), you could use the Date_Calc class and not have to worry about OS-dependent timestamp restrictions:

require_once 'Date/Calc.php';

function isValidBirthDate($year, $month, $day)
{
   $valid = false;
   $dc = new Date_Calc();
   if ($dc->isValidDate($day, $month, $year))
   {
      list($y, $m, $d) = explode('-', date('Y-m-d'));
      if ($dc->compareDates($day, $month, $year, $d, $m, $y) <= 0)
      {
         $valid = true;
      }
   }
   return $valid;
}

Thanks NogDog - I'll look into it.