html - How to create an interface to record an attendance using PHP, MYSQL and other language? -

html - How to create an interface to record an attendance using PHP, MYSQL and other language? -

i have created few tables such date table records date , time of attendance recorded, pupil table records details of students , status records present, absent or late.

i want create interface teacher can record attendance , mysql php language can used.

i have beingness able echo out list of students class taught specific teacher. want allow teacher utilize checkbox scheme select or deselect , submit , straight update database.

can please help me how can start process?

if want more info please allow me know.

i want create interface such attendance recording interface have create table involves student_id foreign key pupil table. status table records present, late or absent status , date & time record records date , time record added.

when user selects checkboxes of 3 different types , clicks submit php send info mysql saying tim nowadays ashley late recognized student_id means update student’s record think of using insert query command rather update because new records might added everyday.

so formula or query select checkboxes , insert status of pupil student_id = chosen column.

i struggling on right query work out , have utilize javascript create work or utilize php function?

you need understand how post/get resquests work (for interfacing between html , php side), , how phone call mysql request php. here have usefull examples:

get/post requests: http://www.w3schools.com/tags/ref_httpmethods.asp

interfacing mysql php (i recommend read sections, intro, connection database etc)

http://www.w3schools.com/php/php_mysql_intro.asp

mysql insertion database (this 'record' part looking for):

http://www.w3schools.com/php/php_mysql_insert.asp

php html mysql interface record