现在日期和数据添加日期之间的日期差异

Question

i need to make a date difference if token had +1 day of being added to database it expires , but the problem i don't know how to calculate the date difference between the date of token adding and the "now" date to check if it's expired or not. I heard about date_diff .. but idk how to use it.

Answer 1

for your accurate need you can just compare two dates.

in php

$now = new DateTime("now");
$now->modify("-1day");
$yourTokenDate = new DateTime($dateFromeDatabase);
if($yourTokenDate > $now){
   echo "ok";
}else{
   echo "expired";
}

in SQL

SELECT yourtocken FROM yourtable 
WHERE tocken_date > DATESUB("1DAY",NOW())