php - MySQL Monitoring Notificaation System
I'm building an APP with a website linked to a MySQL Online Database (OVH). Everything connects and works perfectly, but my knowledge on MySQL/PHP is limited.
I would like to create some kind of Notification that tells me when a new id is created in my database. Basically, when I have a new user account on my website.
I don't really know what do I need: a PHP page that refresh constantly the database ? A trigger that sends me a Notification by E-mail ? I'm looking for quick and simple solution to get notified when I have a new user on my MySQL database.
Thank you for your time,
Answer
Solution:
You can add a email notification in your "Register" function , so whenever user registers on your website you will get notified.
Use php mail() function to get e-mails.
<?php
// the message
$msg = "First line of text\nSecond line of text";
// send email
mail("your@email.com","New User Registered",$msg);
?>
Source