查找PHP中格式为“mm / dd / yyyy”的两个日期之间的天数

Question

I am getting random numbers on converting to days

CODE

$myDateValue = sql::readOne("SELECT `myDateValue` FROM table WHERE id = Value");
// the myDateValue is collected as TEXT in MYSQL

$futureDate =$myDateValue->myDateValue;
$now =time();
$futureDateTimestamp = strtotime($futureDate);

$days = number_format(($futureDateTimestamp - $now)/86400,2,'.',' '); 

echo $days ;

This is giving random numbers OUTPUTS

  OUTPUT1:  -14566.25566
  OUTPUT2:  1452.33655

Answer 1

Everything else is fine, Just add This

    $diff = $futureDateTimestamp - $now;
    $days = intval($diff /86400) ;
    // to find the remaining hours
    $rem_sec = $diff % 86400
    $rem_hr = intval ($rem_sec/3600);

<p> You have total of <?php echo $days .'days and'  $rem_hr ?> hours Left  </p>