Notifications System Design
Posted: Wed Aug 12, 2009 2:07 pm
I am attempting to design a notification system which will operate similar to Facebook's.
Notifications may look like:
MemberName has invited you to join Group
System Message: Welcome to SPC!!!
Member commented on your vehicle
Your Article "Title" has been approved!
Etc...
How should I store these messages so that I can decipher and link different object references? Everything underlined should be linked to its associated page.
Could this best be done with PHP regular expressions? What would this look Like?
Current MySql Table Structure:
Notification_ID | User_ID | Description | Viewed | TimeStamp
Notifications may look like:
MemberName has invited you to join Group
System Message: Welcome to SPC!!!
Member commented on your vehicle
Your Article "Title" has been approved!
Etc...
How should I store these messages so that I can decipher and link different object references? Everything underlined should be linked to its associated page.
Could this best be done with PHP regular expressions? What would this look Like?
Current MySql Table Structure:
Notification_ID | User_ID | Description | Viewed | TimeStamp