du0531 2014-10-09 11:59
浏览 25
已采纳

动态下拉菜单和子菜单php mysql

I have a menu that needs to be created dynamically from the database. need to have menu and submenu

for example (wht i want):

<ul class="dropdown">
    <li><a href="#">Link 1</a> </li>
    <li><a href="#">Link 2</a> </li>
    <li><a href="#">Link 3</a> </li>
    <li><a href="#">Link 4</a>
    <ul class="sub_menu">
        <li><a href="#">Link 4 - 1</a></li>
        <li><a href="#">Link 4 - 2</a></li>
        <li><a href="#">Link 4 - 3</a></li>
    </ul>
    </li>
    <li><a href="#">Link 5</a></li>
    <li><a href="#">Link 6</a> </li>
</ul>

below is the code i used for menu using function i want submenu as well

function listMenu(){
    $ans = $this->select("cat_id,cat_name","s_category","1");
    if(is_array($ans)){
        foreach($ans as $val){
            echo 
            "<li><a href=\"post-summary.php?cid=$val[0]\" >$val[1]</a></li>";
        }
    }
    else{
        echo "";
    }
}

database is as follows:-

CREATE TABLE IF NOT EXISTS `s_category` (
  `cat_id` int(11) NOT NULL AUTO_INCREMENT,
  `cat_name` varchar(15) NOT NULL,
  `cat_uid` int(2) NOT NULL,
  `cat_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `cat_parent` int(11) DEFAULT '0',
  `cat_sort` int(11) DEFAULT NULL,
  `cat_delete` int(1) DEFAULT '0',
  PRIMARY KEY (`cat_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ;
  • 写回答

3条回答 默认 最新

  • dougua3705 2014-10-09 12:16
    关注

    as far as menus are concerned storing the submenus as a comma seperated values in the database would come handy.

    ie consider a table with id,menus,submenus(several submenus seperated by a comma).

     function listMenu(){
    $ans = $this->select("menus,submenus");
    if(is_array($ans)){
        foreach($ans as $val){
            echo    "<li><a href=\"post-summary.php?cid=$val[0]\" >$val[0]</a>"; //menus
    
            $submenu = explode(",",$val[1]);
    
            foreach($submenu as $values){
            echo    "<li><a href=\"post-summary.php?cid=$val[0]&proname=$values\" >$values</a></li>"; // submenus
            }
            echo "</li>";
        }
     }
    }
    

    try this

    $con    =   db_connect();
    $str    =   "select menus,submenus from your_tabel  ";
    $result =   mysql_query($str,$con);
    
    while($arr = mysql_fetch_array($result))
    {
        echo    "<li><a href=\"post-summary.php?cid=$arr[0]\" >$arr [0]</a>"; //menus
    
            $submenu = explode(",",$arr [1]);
    
    //make sure you have several sub-menus else use a if condition here to avoid foreach error  
            foreach($submenu as $values){
            echo    "<li><a href=\"post-summary.php?cid=$arr[0]&proname=$values\" >$values</a></li>"; // submenus
            }
            echo "</li>";
        }
    

    this works fine for me just tested now

    comment if working. comment if not-working.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(2条)

报告相同问题?

悬赏问题

  • ¥15 求差集那个函数有问题,有无佬可以解决
  • ¥15 【提问】基于Invest的水源涵养
  • ¥20 微信网友居然可以通过vx号找到我绑的手机号
  • ¥15 寻一个支付宝扫码远程授权登录的软件助手app
  • ¥15 解riccati方程组
  • ¥15 display:none;样式在嵌套结构中的已设置了display样式的元素上不起作用?
  • ¥15 使用rabbitMQ 消息队列作为url源进行多线程爬取时,总有几个url没有处理的问题。
  • ¥15 Ubuntu在安装序列比对软件STAR时出现报错如何解决
  • ¥50 树莓派安卓APK系统签名
  • ¥65 汇编语言除法溢出问题