MySQL data insert and notiify by email

[togethercomms]

Hi i was wondering if it is possible to be notified when someone has uploaded something to the MySQL server?

For example; someone uploaded a picture i want the picture to be uploaded and then a notification email comes to me aswell to tell me that something has been uploaded.

Many Thanks

[jatar_k]

absolutely, you could do it a couple ways

1. include the sending of the email at the end of the upload script

2. use a cron to check if anything new has been added every X amount of time and email you if there is something new

[togethercomms]

The cron would be good, i have never coome across this before, would it be easy to set up as this job is a cheap job so don't want to spen to much time on it.

Thanks foor your reply

[jatar_k]

if it is available from the host, it isn't always an option. you would search crontab for *nix servers or scheduled tasks for a windows server.

if it's quick then just throw in the email at the end of the upload

maybe something simple like

$to = "[e-mail]";
$from .= "From: [e-mail]\n";
$from .= "Return-Path: [e-mail]\n";
$from .= "Reply-To: [e-mail]\n";
$subject = "someone uploaded a new picture";
$message = "someone uploaded a new picture\n\n";
@mail($to,$subject,$message,$from);

just change it to your email, edit the subject and message and that's that

[togethercomms]

fantastic thank you, i will test this, byut it seems like the normal mailto: php funtion that is used on forms, correct?

Thank you again for your help

[jatar_k]

>> normal mailto: php funtion that is used on forms, correct?

I think so, not 100% sure I read that right

>> Thank you

my pleasure