I am using the DateTime function and want to find out if a date stored in the database has been passed or is yet to happen.
This is for a banlist.
Currently I attempted to use the -> diff function to get the difference only now realising that it produces an absolute value.
e.g. if the end date for the ban is 16/02/2016 or 20/02/2016 the difference will always be 2 days.
How can I test two dates and see if the date has passed using DateTime?
code I have used and failed with:
if ($stmt = $mysqli->prepare("SELECT start, end, length FROM banlist WHERE user_id = ? AND username = ? AND user_email = ?")) {
$stmt->bind_param('iss', $user_id, $username, $email);
$stmt->execute();
$stmt->store_result();
$stmt->bind_result($start, $end, $length);
$stmt->fetch();
if($stmt->num_rows != 0) {
if($length == "inf") {
return 'Indefinitely';
$stmt->close();
}
else {
$startDate = new DateTime($start);
$endDate = new DateTime($end);
$diff=$now->diff($endDate);
$seconds = $diff->format('%s');
$mins = $diff->format('%i');
$hours = $diff->format('%h');
$days = $diff->format('%d');
$months = $diff->format('%m');
$years = $diff->format('%y');
if($seconds > 0 || $mins > 0 || $hours > 0 || $days > 0 || $months > 0 || $years > 0) {
return 'for ' . $length .', starting ' . $startDate->format('d/m/Y') . ' at ' . $startDate->format('H:i:s') . ' and ending on ' . $endDate->format('d/m/Y') . ' at ' .$endDate->format('H:i:s');
$stmt->close();
}
else {
return 'You haven\'t been banned. Please email an admin for assisstance';
$stmt->close();
}
}
}
else {
return 'You haven\'t been banned. Please email an admin for assisstance';
$stmt->close();
}
}