Two common options are.
A)
1. Create a notification table
2. Create afterinsert,afterupdate and afterdelete mysql triggers for all the
tables you need notification for.
3. Those triggers will insert rows to notifications table.
4. Show notification table in admin dashboard.

Not all host services support mysql triggers, consider using aftersave and
afterdelete callbacks.

B)Create a union view in mysql using modified value to get the recent
changes, show the view in admin dashboard.

In this case you need extra steps to mark notifications the admin already
read.

Check out the new CakePHP Questions site http://cakeqs.org and help others with 
their CakePHP related questions.

You received this message because you are subscribed to the Google Groups 
"CakePHP" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected] For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en

Reply via email to