Jump to content

send email on database insert trigger


ahmadmasoood

Recommended Posts

can anyone please help me that i m a new user of PHP and linux so please tell me how i can send an email when mySQL insert trigger have been generated.

 

the scenario is like this, that when new value insert in a table (client_Table), then insert trigger is generated and the functionality of that trigger is that it gets the last inserted row Primary ID (suppose the value is '111') and get the specific audio file (with the name of "111") from specific location in Linux path (/var/lib/audio/"TablePrimaryID".wav) and send Email with audio file attachment and primary ID, to any specific Mail address. (with the help of gmail SMTP).

Link to comment
https://forums.phpfreaks.com/topic/220285-send-email-on-database-insert-trigger/
Share on other sites

can anyone please help me that i m a new user of PHP and linux so please tell me how i can send an email when mySQL insert trigger have been generated.

 

the scenario is like this, that when new value insert in a table (client_Table), then insert trigger is generated and the functionality of that trigger is that it gets the last inserted row Primary ID (suppose the value is '111') and get the specific audio file (with the name of "111") from specific location in Linux path (/var/lib/audio/"TablePrimaryID".wav) and send Email with audio file attachment and primary ID, to any specific Mail address. (with the help of gmail SMTP).

 

Why do you need a trigger?  Untested example that leaves some work for you:

 

//$link = connect
//select db
mysql_query("INSERT INTO table_name (field1, field2) VALUES ('something', 'something else')");
$id = mysql_insert_id($link);
$file = "/var/lib/audio/$id.wav";
// use a mail class that makes sending attachments easy, maybe switfmailer?

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.