• MAIN …
    • prepare($sql); try{ $query->execute(); while($data=$query->fetch(PDO::FETCH_ASSOC)){ switch($data['menu_type']){ case '1': if($part['1']==$data['menu_url']){$ac=' active ';}else{$ac='';} echo "
  • "; echo ""; echo ""; echo ''; if($_SESSION['user_type_id']=='1'){ echo "$data[menu_id] $data[menu_title]"; }else{ echo "$data[menu_title]"; } echo ''; echo ''; echo ''; echo '
    • '; break; case '3': if($part['1']==$data['menu_url']){$ac='active';}else{$ac='';} echo "
  • "; echo ""; echo ""; echo ''; if($_SESSION['user_type_id']=='1'){ echo "$data[menu_id] $data[menu_title]"; }else{ echo "$data[menu_title]"; } echo ''; echo ''; echo ''; echo '
    • '; break; default: if($part['1']==$data['menu_url']){$ac='active';}else{$ac='';} echo '
  • '; echo ''; echo ""; echo ''; if($_SESSION['user_type_id']==1){ echo "$data[menu_id] $data[menu_title]"; }else{ echo "$data[menu_title]"; } echo ''; echo ''; echo ''; echo '
    '; echo '
      '; $sql2="select menu2_id,menu2_title,menu2_url,rec_order,menu2_icon "; $sql2 .=" from menu2 "; $sql2 .=" where menu_id='$data[menu_id]' "; $sql.="and status not like '2' "; switch($_SESSION['user_type_id']){ case '1': //$sql2 .=" and menu2_id in ('1','2') "; break; case '2': $sql2 .=" and menu2_id in ('9','10','11','12','13') "; break; case '3': $sql2 .=" and menu2_id in ('9','10','11','12','13') "; break; case '4': $sql2 .=" and menu2_id in ('9','10','11') "; break; } $sql2 .=" order by rec_order "; $query2=$conn->prepare($sql2); try{ $query2->execute(); if($query2->rowCount()>0){ while($data2=$query2->fetch(PDO::FETCH_ASSOC)){ if($part['2']==$data2['menu2_url']){$ac2=' active ';}else{$ac2='';} echo "
    • "; echo ""; echo ''; if($_SESSION['user_type_id']==1){ echo "$data2[menu2_id] $data2[menu2_title]"; }else{ echo "$data2[menu2_title]"; } echo ''; echo ''; echo '
      • '; } } }catch(PDOException $er){ echo 'Error :'.$er->getMessage(); } echo '
    '; break; } } }catch(PDOException $er){ echo 'Error :'.$er->getMessage(); } ?>