*/ ?>
  • ดูหน้าเว็บ
    • 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_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_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_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 '3': //$sql2 .=" and menu2_id in ('114') "; break; case '7': $sql2 .= " and menu2_id in ('4','5','6','7','11') "; break; case '9': //$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_title]"; echo ''; echo ''; echo '
      • '; } } } catch (PDOException $er) { echo 'Error :' . $er->getMessage(); } echo '
    '; break; } } } catch (PDOException $er) { echo 'Error :' . $er->getMessage(); } ?>