从 PHP 循环创建嵌套数组 - create nested arrays from PHP loop

create nested arrays from PHP loop

本文关键字：嵌套数组创建循环 PHP | 更新日期: 2023-09-27

我需要在这里创建嵌套数组，其中有一个包含每个$forum_topic_name的数组，然后在该数组中，我需要列出每个关联的$subtopic_name

$find_forum_topics = mysqli_query($con, "SELECT * FROM forumTopics ORDER BY listValue ASC");
while ($find_forum_topics_row = mysqli_fetch_array($find_forum_topics)) {
    $forum_topic_name[] = $find_forum_topics_row['topicName'];
    $find_forum_subtopics = mysqli_query($con, "SELECT id, subTopicName FROM forumSubTopics WHERE topicID='$forum_topic_id' ORDER BY listValue ASC");
    while ($find_forum_subtopics_row = mysqli_fetch_array($find_forum_subtopics)) {
        $subtopic_name[] = $find_forum_subtopics_row['subTopicName']; 
    }
}

我的最终目标是将其编码为 JSON，以便我可以显示以下内容：

<div class="topic">
    <div class="topicname">Topic 1</div>
    <div class="subtopics">
        <div class="subtopicname">Subtopic 1</div>
        <div class="subtopicname">Subtopic 2</div>
    </div>
</div>
<div class="topic">
    <div class="topicname">Topic 2</div>
    <div class="subtopics">
        <div class="subtopicname">Subtopic 1</div>
        <div class="subtopicname">Subtopic 2</div>
    </div>
</div>
etc...

可以有几个选项，但你可以选择：

$find_forum_topics = mysqli_query($con, "SELECT * FROM forumTopics ORDER BY listValue ASC");
while ($find_forum_topics_row = mysqli_fetch_array($find_forum_topics)) {
    $topicName = $find_forum_topics_row['topicName']; // get topic name
    $forum_topic_name[$topicName] = array(); // use it as key to array
    $find_forum_subtopics = mysqli_query($con, "SELECT id, subTopicName FROM forumSubTopics WHERE topicID='$forum_topic_id' ORDER BY listValue ASC");
    while ($find_forum_subtopics_row = mysqli_fetch_array($find_forum_subtopics)) {
        $forum_topic_name[$topicName][] = $find_forum_subtopics_row['subTopicName']; // add sub topics
    }
}