Scheduled tasks in PHP

Question

I have a database with information about books and loans of the same, when the time the book can be borrowed expires then the system must change the status of the loan record. I thought to do this as a programmed task, there is some way to accomplish this task using only PHP (no scheduled windows tasks or equivalent in linux)?

Answer 1

You can create events in Mysql itself, you need to enable the option event_scheduler=1 in the 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 ...;