*/ ?>
  • Main Menu …
    • 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['member_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['member_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 ''; echo "$data[menu_id] $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['member_type_id']){ case '1': $sql2 .=" and menu2_id in ('1','2') "; break; case '2': $sql2 .=" and menu2_id in ('15','22','50','44','114','61','98','110','104','105','106','107','108','109') "; break; case '3': $sql2 .=" and menu2_id in ('114') "; 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 ''; echo "$data2[menu2_id] $data2[menu2_title]"; echo ''; echo ''; echo '
      • '; } } }catch(PDOException $er){ echo 'Error :'.$er->getMessage(); } echo '
    '; break; } } }catch(PDOException $er){ echo 'Error :'.$er->getMessage(); } ?>