How to update one column of a table of student data for a number of students at one go?
I have a database table of student data like::
CheckBox Stu_Name Stu_ Roll_Num Stu_class
--------------------------------------------
ABC 123 5A
PQR 234 5A
WXY 345 5A
XYZ 567 5A and so on
Every row has a check box.
I select students who will be promoted from 5A to 6A by clicking on the check boxes. There is a promote button at the bottom of the table.
When I select check boxes and click on Promote button, Stu_class will be updated from 5A to 6A and so on for the entire group of students at one go.
That is I need not update one student at a time.
Can anyone give me the code how to do this using PHP, MySql and may be javascript or jquery?
Thank You in advance.
CheckBox Stu_Name Stu_ Roll_Num Stu_class
--------------------------------------------
ABC 123 5A
PQR 234 5A
WXY 345 5A
XYZ 567 5A and so on
Every row has a check box.
I select students who will be promoted from 5A to 6A by clicking on the check boxes. There is a promote button at the bottom of the table.
When I select check boxes and click on Promote button, Stu_class will be updated from 5A to 6A and so on for the entire group of students at one go.
That is I need not update one student at a time.
Can anyone give me the code how to do this using PHP, MySql and may be javascript or jquery?
Thank You in advance.