基于mysql的通知_用于学生管理系统的PHP / MySQL通知

Anyone having an idea of creating notifications for a student management system?

I am using PHP, MySQL to develop the website of student management system.

This system requires administrator to send notifications to users of the institute...

Multiple notifications can be send to a member and one notification can be send to multiple members of the system.

On receiving notification members are required to click it.Then that notification will erase form his notification board.but it will be available to other members who haven''t viewed it yet.

Thanks

解决方案Select the students from a table following a defined criteria.

Put a table with the n-n relationships 1 notification can have N students and 1 student can have N notifications.

The teacher should be the one capable to add notifications and only add.

The student should be capable to delete them.

PHP should help you to show the information, login page, interface to the database. And MySql should handle the data...

Is that some kind of homework? Have you tried anything? give us more clues and probably we will be capable to help a little bit more...

Good luck.

create a table to store notifications_details.

create one more table to store the student viewed_notifications, and

make the entry when the student viewed the particular notification

Then fetch the records notifications_details which are not present in viewed_notifications table for that particular student.