Re: date problem in MySQL DB

[Justin Patrin <papercrane@xxxxxxxxxxxxxxx>]

Brett King wrote:

> Hi Angelo
>
> Yes you will have to reformat and he is something that may help you.
> Hope it does
>
> 	function dateCheckMysql ($date) {
>
> 		list($dateDay, $dateMonth, $dateYear) = explode("/", $date);
> 		if ((is_numeric($dateDay)) && (is_numeric($dateMonth)) &&
> (is_numeric($dateYear))) {
>
> 			if (!checkdate($dateMonth, $dateDay, $dateYear)) {
> 				return false;
> 			} else {
>
> 				return($dateYear."/".$dateMonth."/".$dateDay);
> 			}
> 		} else {
>
> 			return false;
> 		}
> 	}
>
> 	function dateCheckForm($date) {
>
> 		list($dateYear, $dateMonth, $dateDay) = explode("-", $date);
>
> 		if ((is_numeric($dateDay)) && (is_numeric($dateMonth)) &&
> (is_numeric($dateYear))) {
>
>   			return($dateDay."/".$dateMonth."/".$dateYear);
> 		} else {
> 			return false;
> 		}
> 	}
>
> Many Thanks
> Brett

Wow, that's lots of code. I'd recommend something simpler. Like:

$mysqlDate = date('Y-m-d', strtotime($myDate));

$myDate = date('m/d/Y', strtotime($mysqlDate));

No checking involved, just one line of code.

--
paperCrane <Justin Patrin>
--
Question Everything, Reject Nothing

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php