HTML Editor Dynamic Checkbox

Hello Guys,

I need again your help,. I want to insert a record with specific destination and only that

specific users can view that records ...,.

-------------------------------------------------

for example: Lets say there is a 2 checkboxes: the professor checkbox and the student

checkbox.


now, If the professor checkbox is "checked" only the professors can view the that records

and same as with the student checkbox only the students can view that inserted records.

-------------------------------------------------------------------------

but if the 2 checkboxes are both "checked" ... students and professors are allowed to view

that records ...


Help me please ...

Thanks in Advanced ... :)

set the checked value for the Prfesor checkbox and the student checkbox to 1

in your database, you will need 2 new columns, forProfs, forStudents

bind the forProfs column to the profesors checkbox and the forStudents column to the students checkbox.


you users table will also need a column to mark the userType as student or professor. Lets say we call this column "userType" and give it a value of 1 for students and 2 for professors


In the authenticate user server behavior on the login page, you will set the third step to store the userType column into a session variable when the user logs in.


then where you want to output the record use an if statement:

<?php if(($_SESSION['userType'] == "1" && $row_recordsetName['forStudents'] == "1") ||($_SESSION['userType'] == "2" && $row_recordsetName['forProfs'] == "1"))

<?php echo $row_recordsetName['pageContent']; ?>

<?php } ?>

Thanks for the response Jason,.

  set the checked value for the Prfesor checkbox and the student checkbox to 1

in your database, you will need 2 new columns, forProfs, forStudents

bind the forProfs column to the profesors checkbox and the forStudents column to the students checkbox.  

1.)what data type should I used in that two columns ? the integer or the boolean ?

2.)After I set the value of the checkbox to "1" for professor and student ... Is the name of

the checkboxes of the professor and student are the same ?

3.)do I have to include in the name of the checkbox this bracket " [] " after the name of

the checkboxes ?

4.)In the server behavior panel, the Insert Record(tbl_blah_blah), I will set the value of the

column prof and column students .. that get the value from the checkbox that has been

"checked ". Right ?

------------------------------------------

Thanks a lot Jason ... :)

  1.)what data type should I used in that two columns ? the integer or the boolean ?  

use integer

  2.)After I set the value of the checkbox to "1" for professor and student ... Is the name of

the checkboxes of the professor and student are the same ?  

no, use unique names for the checkboxes

  3.)do I have to include in the name of the checkbox this bracket " [] " after the name of

the checkboxes ?  

No, you would only need to do that if the chackboxes are namedthe same, but they should have unique names

  4.)In the server behavior panel, the Insert Record(tbl_blah_blah), I will set the value of the

column prof and column students .. that get the value from the checkbox that has been

"checked ". Right ?  

yes, by binding the columns to the checkbox form element, it will insert the checked value "1" if the checkbox is checked, or leave it blank if the checkbox is not checked.