Summary on time calculation_PHP tutorial

Calculating the time difference in php is sometimes very troublesome!

But I believe that in any language, as long as you master its regularity, you can find a way, and it will definitely turn decay into magic.

Date calculations are often required at work. Here are some experiences gained from work. Write it down first so you don’t forget it later!

1. The first method is to calculate the time period difference (can be minutes, seconds, days)

$endtime="2004-09-09 18:10:00";
$d1=substr($endtime,17, 2); //Seconds
$d2=substr($endtime,14,2); //Minutes
$d3=substr($endtime,11,2); // Hours
$d4= substr($endtime,8,2); //Day
$d5=substr($endtime,5,2); //Month
$d6=substr($endtime,0,4); // Year

echo $d1.'-'.$d2.'-'.$d3.'-'.$d5.'-'.$d4.'-'.$d6."n";

echo date("Y-m-d H:i:s")."n";
$now_T=mktime(date("H"),date("i"),date("s" ),date("m"),date("d"),date("Y"));
echo $now_T."n";
$now_S=mktime("$d3","$ d2","$d1","$d5","$d4","$d6");
echo $now_S."n";
$end_TS=($now_S-$now_T)/60 ; //Calculate remaining minutes
echo $end_TS;
?>

Note $startdate=mktime("0","0","0","1","1" ,"2000");
//The obtained value is the total number of seconds from 1970-1-1 to the parameter time, then it can be converted into minutes/60 hours/3600 days/3600/24!​​  

If the parameters in mktime() are default, it means using the current date.


2. If you have a database, it will be easy! If it is MSSQL, you can use triggers! Just use the function datediff() that specially calculates the date difference!
If it is MYSQL, use two dates The calculation result of the field difference calculation is saved in another numeric field! Just call it when needed!