在Codeigniter中显示嵌套列表 - Display nested lists in Codeigniter

Display nested lists in Codeigniter

本文关键字：嵌套列表显示 Codeigniter | 更新日期: 2023-09-27

我的数据库中有以下表:

projects(id, name)
subprojects(id, project_id, name)

我想在嵌套列表中显示项目及其子项目。下面是一个例子:

<ul>
    <li><a href="#">Project</a></li>
    <li><a href="#">Project</a>
        <ul>
            <li><a href="#">Sub Project</a></li>
            <li><a href="#">Sub Project</a></li>
        </ul>
    </li>
</ul>

我使用CodeIgniter作为框架，实现结果的最佳方法是什么?

您应该在每个项目的结果数组中执行select

$query = " select * from projects";
$query = $this->db->query($query);
$result = $query->result_array() ;
foreach($result as $key=>$value)
{
   $query = " select * from subprojects where project_id='".$value['id']."' ";
   $query = $this->db->query($query);
   $result[$key]['subproject'] = $query->result_array() ;
}

和视图内部

foreach($result as $row)
{
   echo " <li><a href='#'>".$row['name']."</a>";    
   if(isset($row['subproject']))
   {
    echo "<ul>";
    foreach($row['subproject'] as $sub)
    echo " <li><a href='#'>".$sub['name']."</a>";    
    echo "</ul>";
   }
   else
   {
    echo "</li>";
   }
}