I am currently facing a problem that I cannot solve. I have a web application that uses a PHP API to send emails via the PHP Mailer library. I also have a MySQL database containing a Person table with attributes such as names, first names, and birth dates.
I would like to automatically send an email to each person in my table on their birthday. I have looked for solutions such as the Windows scheduler, but I prefer a more automated solution.
I am looking for ideas on how to solve this problem using PHP, MySQL, and Angular. If anyone has encountered this problem and has a solution, or ideas on how to proceed, I am open to suggestions.
Thank you very much for your help.
I tried to use windows Scheduler as mentioned before but I have to add every action one by one and it is quite slow.