Validate Date for Mysql Submission


First use the this function to validate the date what we will be getting after hitting post.
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
function _date_is_valid($str) {
 
    if (substr_count($str, '-') == 2) {
 
       list($y, $m, $d) = explode('-', $str);
         
       if(checkdate($m, $d,sprintf('%04u', $y))){
     
           return true;
           }else{
               return false;
 
            
}}
 
    return false;
}
Then prepare the date for Mysql data insertion
1
$date = date('Y-m-d', strtotime(str_replace('-', '/', $_POST['date'])));