Scheduled Tasks in PHP

Question

Scheduled Tasks in PHP

Navigation

#1 by (6 votes)

2

I have a database with information about books and loans from them, when the time that the book can be borrowed then the system should change the status of the loan record. I thought of doing this as a scheduled task, is there any way I can accomplish this task using only PHP (without scheduled windows tasks or linux equivalent)?

php mysql

asked by anonymous 16.05.2017 / 20:36

1 answer

Regex to get text into python? How to force a drop table in SQL?

score 6 · Accepted Answer

You can create events in MySQL itself, so you will need to enable the event_scheduler=1 option in My.ini , example:

/*Executa de hora em hora*/
CREATE EVENT e_hourly_book
ON SCHEDULE
  EVERY 1 HOUR
COMMENT 'Altera o Status dos livros'
DO
  UPDATE livro SET ...;