Search code examples
phpmysqldatestrtotime

How to filter date 0000-00-00 00:00:00 If user did not enter in my form

If users did not enter date MySQL inserts 0000-00-00 00:00:00. Now I don't want to show date in textbox if its 0000-00-00 00:00:00

I use this helper in codeigniter

function dateTimeHelp($date, $mysqlDatetime = true) {
if (strtotime($date) === false)
    return null;
else {
    if ($mysqlDatetime) {
        return date('Y-m-d H:i:s', strtotime($date));
    } else {
        return date('d-m-Y H:i:s', strtotime($date));
    }
}

}
Solution

  • Multiple ways, I assume this function is called to display in your form. Just check for 0000-00-00 00:00:00:

    if ($date == '0000-00-00 00:00:00' || strtotime($date) === false)
    return null;