Email alert when database is updated

[Anon]

I remember reading somewhere that it is possible to make sure that an email is sent to oneself when the sql database is updated via a form on the web.

Can anyone tell me how?

Thanks.

[zhabala]

It depends on the database and on the form and on the language used. Usually when the data is entered into the form, then some script (PHP, ASP, JSP, ... ) is called with those date as a parameters. Then the script is executed and usually it allows to sent mail, SMS, or something else.

Some databases like PostgreSQL allows to program some code as a TRIGGER, which is TRIGGERD by an update of some row. Then some TRIGGER languages allow to sent mail I think.

Hope it helped.

Zdenek

[Anon]

Thanks Zdenek.
I found a link that is useful: http://www.blazonry.com/scripting/phpmail.php
I am using php with a mysql database.

-Rishi

[mikeq]

After your Update/Insert statement execution check for success, if successful then send an email.

e.g.

$Query = "update MYTABLE set blah='1'";
$UpdateResult = MySQL_Query($Query);

$RowsAffected = mysql_affected_rows();

if($RowsAffected){
$Address = "[e-mail]";
$Subject = "Database Updated";
$Body = "Someones updated your database";

mail($Address,$Subject,$Body,"From: [e-mail]");
}