If (empty(DATETIME))?

JREAM · November 22, 2009, 1:56am

If you fetch a MySQL DATETIME that’s not set,

Output: 0000-00-00 00:00:00

if (empty($date)) { echo 1; }
if (!isset($date)) { echo 2; }

How do I check if the Date isn’t a real date?

Raffles · November 22, 2009, 2:06am

http://uk.php.net/manual/en/function.strtotime.php

See the first comment.

JREAM · November 22, 2009, 3:10am

Hey, Thanks man ! Sorry for my delayed message I was installing Apache

PHPycho · November 22, 2009, 3:56am

Use some method instead:

function formatDate($format,$dateStr) {
  if (trim($dateStr) == '' || substr($dateStr,0,10) == '0000-00-00') {
    return '';
  }
  $ts = strtotime($dateStr);
  if ($ts === false) {
    return '';
  }
  return date($format,$ts);
}

stonedeft · November 22, 2009, 4:00am

PHPycho:

Use some method instead:

function formatDate($format,$dateStr) {
  if (trim($dateStr) == '' || substr($dateStr,0,10) == '0000-00-00') {
    return '';
  }
  $ts = strtotime($dateStr);
  if ($ts === false) {
    return '';
  }
  return date($format,$ts);
}

nice function this one goes in my function archives thnx man you look good !

Raffles · November 22, 2009, 10:49am

Er, that’s the function in the first comment from the manual entry for strtotime (in my first post). So unless that comment in the manual was PHPycho’s, then no, he doesn’t “look good”.

PHPycho · November 22, 2009, 11:44am

concept matters.
Just take the good concepts.