如何从一列时间值中将它们与当前时间进行比较并获得当前时间之后的最接近值？

Question

Say you have a list of time values in a column in a MySQL database.

Time
-----
10:15 AM
10:35 AM
10:55 AM

And say that right now is 10:27 AM. How would I get the 10:35 AM value specifically in a variable in PHP?

I know that I could get the current time with

$currenttime = time();

and then operate on the time values with

$some_time = strtotime($row['time']);

But how do I get the closest one into that $some_time variable?

Answer 1

Try taking the absolute values of the differences between the current time and possible times. Whichever value is lowest is the closest. The only thing from there you would have to worry about is if a given time is equally close to two times which you can handle in whichever way you please (it seems most reasonable to me to simply round up at that point)

Regards,
Dennis M.