Jump to content

Using MySQL to create a High School Demerits Points System


ishvir

Recommended Posts

Hello,

 

I am helping my wife set up a PHP Powered Demerit System at her school. I have basic PHP and MySQL skills.

 

Basically she wants a web interface where a student logs in with Student Number and Password.

 

Demerits and merits accrue to the students as below:

Coming late to school, 1 Demerit

Handing an assignment late, 2 Demerits

No Demerits in 3 months equals 1 Merit assigned

Student suspended after 6 / more Demerits

Parent / Gaurdian emailed

 

The student will see the table below once logged in:

Student Name

Student ID Date                 Action                     Demerit Merit         Total

A123         2012/02/26 Late Sign In               1         0         1

                2012/02/28 Late Assignment       1         0         2

                2012/05/29 3 month Merit earned    0         1         1

                2012/06/08 Late Assignment       2         0         3

                2012/06/10 Late Assignment       2         0         5

                2012/06/12 Late Assignment       2         0         7

                                                                              Student suspended

                                                                              Send email to parent/gaurdian

                   

I would really appreciate any help you can offer.

 

Thanks,

Ishvir

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.