Insert dynamical exam result of each student

manpreet Best Answer 2 years ago

I have problem with inserting dynamical exam into mysql database. I don't know how to explain in word so this my code for example:

I have table exam this is my exam table structure:

exam table

+----+-----------+
| id | exam_name |
+----+-----------+
|  1 | run test  |
|  2 | swim test |
+----+-----------+

student table :

+----+-------------+
| id |   student   |
+----+-------------+
|  1 | student one |
|  2 | student two |
+----+-------------+

The problem is how to insert into table exam result, for example student one pass exam run test but fail for swim test. so the table exam result will show like this:

+---------+------------+--------+
| id_exam | id_student | status |
+---------+------------+--------+
|       1 |          1 |      1 |
|       2 |          1 |      0 |
+---------+------------+--------+

This is how i fetch every single exam and student into html table to give result of each student:

 class='wp-list-table widefat fixed striped posts'>
      
         class="bgth manage-column ss-list-width1">Participan Name
           class="bgth manage-column ss-list-width1">Complited Pool Requirement
           class="bgth manage-column ss-list-width1">Complited Theory Exam
           class="bgth manage-column ss-list-width1">Medical Sertificate Checked
     class="bgth manage-column ss-list-width" colspan="2">Action
      
   type='hidden' name='exam_total' value='3'> type='hidden' name='exam_names' value='[{"id":"1","exam_name":"Complited Pool Requirement"},{"id":"2","exam_name":"Complited Theory Exam"},{"id":"3","exam_name":"Medical Sertificate Checked"}]'> class='manage-column ss-list-width'>Handri angga riawan
         type='hidden' value='1' name='x-id[]'> class='manage-column ss-list-width'>
           type='checkbox' name='Complited_Pool_Requirement[]' value='1'>check if pass
           type='hidden' name='id_exam[]' value='1' >
           class='manage-column ss-list-width'>
           type='checkbox' name='Complited_Theory_Exam[]' value='1'>check if pass
           type='hidden' name='id_exam[]' value='2' >
           class='manage-column ss-list-width'>
           type='checkbox' name='Medical_Sertificate_Checked[]' value='1'
                                                

                                                                                                        REPLY
                                                    
                                                
                                                


                                                    

                                                        
                                                            0
                                                            views 

                                                            0
                                                                likes 
                                                            
                                                            

                                                            0
                                                            shares

                                                            


    

         Facebook
        
         Twitter
        
        
         Linked In 
        
          WhatsApp