Hi,
I would like to create a PHP script that checks my Mysql datbase for any changes, i.e. whether someone has added a record, deleted a record etc ?
thank you,
Mark
QUESTION -Checking whether my MySQL datbase has been updated
Moderator: General Moderators
- mhouldridge
- Forum Contributor
- Posts: 267
- Joined: Wed Jan 26, 2005 5:13 am
- mhouldridge
- Forum Contributor
- Posts: 267
- Joined: Wed Jan 26, 2005 5:13 am
- mhouldridge
- Forum Contributor
- Posts: 267
- Joined: Wed Jan 26, 2005 5:13 am
if you want an email every time then you could check out http://www.php.net/function.mail and build a simple emailer to let you know when someone inserts, updates, or deletes something in the db as part of the script that does the inserting, updating or deleting.
What I meant was that your script should check to make sure that any sql query is succesful and if it is then send yourself an email.
What I meant was that your script should check to make sure that any sql query is succesful and if it is then send yourself an email.