用于学生管理系统的PHP/MySQL通知 [英] PHP / MySQL Notification for a student management system

问题描述

有人想为学生管理系统创建通知吗?

我正在使用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

推荐答案

根据定义的条件从表中选择学生.

放置一个具有n-n关系的表.1个通知可以有N个学生，而1个学生可以有N个通知.

教师应该是能够添加通知并且只能添加的人.

学生应该能够删除它们.

PHP应该可以帮助您显示信息，登录页面，数据库接口. MySql应该处理数据...

那是某种作业吗?你有尝试过吗?给我们更多的线索，也许我们将有能力提供更多的帮助...

祝你好运.

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.

创建一个表来存储notifications_details.

再创建一个表来存储学生的viewed_notifications，然后
学生查看特定通知时进行输入

然后获取该特定学生在viewed_notifications表中不存在的notifications_details记录.

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.

这篇关于用于学生管理系统的PHP/MySQL通知的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！