I'm currently working on a project using CodeIgniter web framework. I just have this question in mind: how do I create a notification feature? Specifically, this notification feature would cover some activities that are happening in my application. Like for example, a student requested an appointment with a guidance counselor. How do I create the notification that will be sent to the guidance counselor?
I have an idea about how the notification will be inserted in the database, but I'm not quite so sure. Another question: What if a notification comes from one user and should be sent to many users? How do I write it in the database? And, how do I have a real time notification? I mean, when a user no longer needs to refresh the page if a new notification has been sent to him or her, a notification bubble or whatever will just popout somewhere. Of course, this needs a javascript/jquery/ajax (which I'm really not enthusiastic about haha), and I have an idea how it'll work, but then again, I'm not quite so sure. Can someone help me? I just need a brief walk-through, or something that will get me started or that will give me an idea about the things I need and the things I have to learn.
Thank you in advance for the answers.