I think my problem is not knowing how newDate comes through if nothing has been entered. I've tried using if(!is_null( )) and !="" etc inside the function
Code: Select all
$newDate = $_POST['newDate'];
function formatMySQLDate($date)
{
if(!is_null($date))
{
$day = substr($date,3,2);
$mon = substr($date,0,2);
$year = substr($date,6);
$newdate= $year.'-'.$mon.'-'.$day;
return $newdate;
}
else {return $date;}
}
$newDate = formatMySQLDate($newDate);
Code: Select all
$newDate = $_POST['newDate'];
function formatMySQLDate($date)
{
$day = substr($date,3,2);
$mon = substr($date,0,2);
$year = substr($date,6);
$newdate= $year.'-'.$mon.'-'.$day;
return $newdate;
}
if ($newDate !=""){
$newDate = formatMySQLDate($newDate);
}
Can anyone help on this?
Thanks