I have a customer whose website is hosted on a Linx machine running Apache, generated from a MySQL database using PHP ASP. My requirement is:
Users fill info into a form, which when submitted is loaded by PHP into a table in the MySQL database. OK so far. What I need is a way of notifying the customer that there is new info in the table (info from possibly several users)
What I envisage is a process running o the Linux machine that every 15 minutes, say, kicks a PHP script into action. This PHP script would then query the MySQL database to look for new information, and then, if new info is found, send an email to the customer to notify them.
How can this be done? Can Apache be setup to kick a PHP script at regular intervals? Please help, I'm fairly new at PHP and Linux.