Toggle navigation
Dashboard
Dashboard Tracker
Add / Edit My Forums
System Announcements
Discussion
Active Thread Feed
Top Threads Today
Top Threads This Week
Top Threads Library
Go!
View All
View All
Login
Logout
Home
Forums Index
Server Side
/
PHP Server Side Scripting
2:26 pm May 21, 2026
This page requires javascript.
Forum Moderators:
coopster
Message Too Old, No Replies
Mysql PHP help?
mysql triggers works
rootlk
Msg#:4242145
8:41 am on Dec 14, 2010
(gmt 0)
Can someone post a simple example of how a trigger can be built to send an email on update of a table row?
Matthew1980
Msg#:4242213
11:30 am on Dec 14, 2010
(gmt 0)
Hi there Rootlk,
Welcome to WebmasterWorld!
An example, in pseudo form:-
<?php
//If the query is successful, and the sql returns true on completion of query
//send a mail
if($update_query){
if(mail(SEND YOUR EMAIL HERE)){
echo "Update complete";
exit;
}
else{
echo "Something went wrong";
exit;
}
}
else{
//something went wrong, show error or redirect to holding/index page
header(REDIRECT HERE);
exit;
}
?>
That will be something like the logic as you need there.
Cheers,
MRb
rootlk
Msg#:4242595
6:32 am on Dec 15, 2010
(gmt 0)
thx for the well come,
and
thx for the support
Join The Conversation
Register
For Free! -
Become a
Pro Member
!
See forum categories
-
Enter the Forum
Moderators and Top Contributors
Moderator List
| Top Contributors:
This Week
,
This Month
,
Apr
,
Mar
,
Archive
,
Top 100 All Time
,
Top Voted Members
Hot Threads This Week
May 2026 Google Search Observations
AdSense Earnings and Observations - May 2026
AI visibility audit
Adsense / Personal Manager / Support
Hacker spoofing as GoogleBot
Page indexed but live url test gets 500 error
Link collaboration strategies
in case you missed it .
Microsoft, AS8075. Google, AS396982.
Bad actor claiming to be OpenAi
Home
Forums Index
Server Side
/
PHP Server Side Scripting
2:26 pm May 21, 2026