=1 AND $Role_id!='') { $sql = "Delete from $TABLENAME2 where role_id='".$Role_id."'"; $res=mysqli_query($conn,$sql); $msg="Menu assigned Successfully"; //$qery =""; for($i=0;$i<$count_menu;$i++) { $suffix=$i; $query_prefix='INSERT INTO '; $query_suffix=""; if(isset(${"report_id$suffix"}) && ${"report_id$suffix"}!=''){ $query_main="(role_id, report_id,access_level,modified_by) values('".$Role_id."','".${"report_id$suffix"}."','".${"accesslevel$suffix"}."','".$_SESSION['user_id']."')"; $sql=$query_prefix.$TABLENAME2.$query_main.$query_additional.$query_suffix; //$qery.=$sql; $res=@mysqli_query($conn,$sql); } } } //echo $qery; //echo ""; } ?>

Assign Menues   Role Name Menu Items Select All Report ID Report Name Report Type Report Code Access Level onclick="checkParent();"> Access Level: checked/> Read checked /> Write checked /> Execute