如何在db中连续比较当前时间和datetime字段？

Question

I'm am working on an bootstrap website where I have get a list of tasks to do from mysql db which starts on different times of the day. I also have to pop up a reminder when each task is about to start. Table has 4 columns task_id(int), task_name(varchar), start_time(datetime), and details(varchar).

I've managed to get the data from the table and display it in a table in my website,using the mysql_fetch_array loop.

I understand and am using the bootstrap modal to do the pop up of the reminder.

But I'm not sure on how to do the triggering of the pop up, and how to continuously check for tasks which match with the current time, to trigger the pop ups.

Any idea on how I can go about doing this?

Answer 1

You can do the check on each page load. And if you expect a user to stay on the same page for a long time, you can setup a timer (setInterval in JS) that will make an ajax request to check if there is a task to display