function date_db_encode($str, $db = "mysql") {
if (preg_match('%(0[1-9]|[12][0-9]|3[01])[-/.]?(0[1-9]|1[012])[-/.]?((?:19|20)[0-9]{2})%', $str, $t)
&& checkdate($t[2], $t[1], $t[3])) {
switch (strtolower($db)) {
case "mysql" :
$r = sprintf("%04d-%02d-%02d", $t[3], $t[2], $t[1]);
break;
case "ymd" :
$r = $t[3] . $t[2] . $t[1];
break;
default :
$r = 0;
break;
}
}
else {
$r = 0;
}
return $r;
}
