for some weeks now, i have been trying to develop an attendance system with php and mysql.
I HAVE LOOKED EVERYWHERE!!
what i have done is this:
user select date (calendar).
date is processed in php page. if attendance has not been filled,then new attendance
sheet is provided.
else, redirected to choose another field.
The user is using checkbox to select which student is present( value true )
in the db: the date is stored like this:
columns: stud_id dat(date) Present
rows: 1 , 18/08/2011 , TRUE
there is no false, because of checkbox..
See, it is hard for me to create a view.
i need a report shown like normal attendance sheet in classrooms:
columns stud id lname fname date
rows x , x , x , present
y , y , y , absent
because the table in database and the html table have different format, i am struggling
to output it in a proper way.!!