在多个级别的菜单从数据库中的代码 [英] multi level menu from database in codeigniter

问题描述

我的数据库中包含我所有数据库类别的表，我需要转换成多级菜单。表结构如下：

  product_category_id | product_category_name | product_category_description | product_category_parent_id 
 --------------------------------------------- -------------------------------------------------- --------- 
 1 test ulghjbjjjh NULL 
 2 test2 yruktghkug NULL 
 3 test sub 1 yr5y346uij 1 
 4 test sub sub 1 yfghvbnhtd 3 
  

使用我在线教程中修改的功能（这里）和研究的时间，结果代码将只显示顶级（父ID为null）。我确定这是sortMenu函数的一个问题，但是我似乎无法使用它。

这是我提取数据的模型函数：

  public function getProductCategories（）
 {
 $ query = $ this-> db-> get（tbl_product_categories）; 
 return $ query-> result_array（）; 
} 
  

这里是从索引函数调用私有函数的控制器，调用私有create_list函数：

 类产品扩展CI_Controller {
 
 public function __construct ）
 {
 parent :: __ construct（）; 
 $ this-> load-> model（products_model）; 
} 
 
 public function index（）
 {
 $ categories = $ this-> products_model-> getProductCategories（）; 
 echo $ this-> sortMenu（$ categories）; 
 // print_r（$ this-> products_model-> getProductCategories（））; 
} 
 
私有函数sortMenu（$ items）
 {
 //创建一个数组来保存引用
 $ refs = array（）; 
 
 //创建和数组来保存列表
 $ list = array（）; 
 
 //循环结果
 // while（$ data = @mysql_fetch_assoc（$ result））
 foreach（$ items as $ data）
 {
 //通过引用分配
 $ thisref =& $ refs [$ data ['product_category_id']]; 
 
 //添加菜单parent 
 $ thisref ['product_category_id'] = $ data ['product_category_parent_id']; 
 $ thisref ['product_category_title'] = $ data ['product_category_title']; 
 
 //如果没有父代码
 if（is_null（$ data ['product_category_parent_id']））
 {
 $ list [$ data ['product_category_id ']] =& $ thisref; 
} 
 else 
 {
 $ refs [$ data ['product_category_id']] ['children'] [$ data ['product_category_id']]& $ thisref; 
} 
 
} 
 print_r（$ list）; 
 return $ this-> create_list（$ list）; 
} 
 
 / ** 
 * 
 *从数组中创建一个HTML列表
 * 
 * @param array $ arr 
 * @param string $ list_type 
 * @return string 
 * 
 * / 
私有函数create_list（$ arr）
 {
 $ html = \\\
< UL> \\\
; 
 foreach（$ arr as $ key => $ v）
 {
 $ html。='< li>'$ v ['product_category_title']。< / li> ; \\\
; 
 if（array_key_exists（'children'，$ v））
 {
 $ html。=< li>; 
 $ html。= create_list（$ v ['children']）; 
 $ html。=< / li> \\\
; 
} 
 else {} 
} 
 $ html。=< / ul> \\\
; 
 return $ html; 
} 
 
} 
  

这完全让我感到不安：S有人有任何想法吗？

解决方案

根据我的理解，

这行：

  $ refs [$ data ['product_category_id']] ['children'] [$ data ['product_category_id ']] =& $ thisref; 
  

应该是这样的：

  $ refs [$ data ['product_category_parent_id']] ['children'] [$ data ['product_category_id']]& $ thisref; 
  

I have a table in my database containing all of my database categories, which I need to convert into a multi-level menu. The table structure is below:

product_category_id | product_category_name | product_category_description | product_category_parent_id
--------------------------------------------------------------------------------------------------------
1                     test                    ulghjbjjjh                     NULL
2                     test2                   yruktghkug                     NULL
3                     test sub 1              yr5y346uij                     1
4                     test sub sub 1          yfghvbnhtd                     3

Using the functions I have adapted from an online tutorial (here) and hours of research the resulting code will only display the top level (those with a parent id of null). I'm sure it is a problem with the sortMenu function, however, I cannot seem to work it out.

Here is my model function which extracts the data:

public function getProductCategories()
{
    $query = $this->db->get("tbl_product_categories");
    return $query->result_array();
}

Here is the controller which calls the private function from the index function, which, in turn, calls the private create_list function:

class products extends CI_Controller {

public function __construct()
{
    parent::__construct();
    $this->load->model("products_model");
}

public function index()
{       
    $categories = $this->products_model->getProductCategories();
    echo $this->sortMenu($categories);
    //print_r($this->products_model->getProductCategories());
}

private function sortMenu($items)
{
    // create an array to hold the references
   $refs = array();

   // create and array to hold the list
   $list = array();

   // loop over the results
   //while($data = @mysql_fetch_assoc($result))
    foreach($items as $data)
    {
       // Assign by reference
       $thisref = &$refs[ $data['product_category_id'] ];

       // add the the menu parent
       $thisref['product_category_id'] = $data['product_category_parent_id'];
       $thisref['product_category_title'] = $data['product_category_title'];

       // if there is no parent id
       if (is_null($data['product_category_parent_id']))
       {
           $list[ $data['product_category_id'] ] = &$thisref;
       }
       else
       {
           $refs[ $data['product_category_id'] ]['children'][ $data['product_category_id'] ] = &$thisref;
       }

   }
   print_r($list);
   return $this->create_list($list);
}

/**
*
* Create a HTML list from an array
*
* @param    array    $arr
* @param    string    $list_type
* @return    string
*
*/
private function create_list( $arr )
{
    $html = "\n<ul>\n";
    foreach ($arr as $key=>$v) 
    {
        $html .= '<li>'.$v['product_category_title']."</li>\n";
        if (array_key_exists('children', $v))
        {
            $html .= "<li>";
            $html .= create_list($v['children']);
            $html .= "</li>\n";
        }
        else{}
    }
    $html .= "</ul>\n";
    return $html;
}

}

This has completely baffled me :S Does anyone have any ideas?

解决方案

From what I understand,

This line:

$refs[ $data['product_category_id'] ]['children'][ $data['product_category_id'] ] = &$thisref;

should be this:

$refs[ $data['product_category_parent_id'] ]['children'][ $data['product_category_id'] ] = &$thisref;

这篇关于在多个级别的菜单从数据库中的代码的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！