重新格式化PHP MYSQL阵列结果深入多个级别

I reformatted this question hoping that the duplicate marking of this question will be changed as that answer doesn't go as far as this need does. It is not clear how to get past the first level of SECTIONS containing all CHAPTERS which the other question explains how to do.

I'm trying to first group by SECTION, then by all the CHAPTERS in that section and then all the PAGES within each chapter. Hope someone can help me.

Here is the result I get back from MYSQL in PHP:

I'm trying to format the array to look like this:

I have attempted several solutions, this is the closest I get, but the groupings are separated in the results:

    foreach ($book_content as $record) {

        $temp_array['SectionName'][] = $record['BookSection'];
        $temp_array['Chapters'][] = array('ChapterTitle' => $record['ChapterTitle']);
        $temp_array['Chapters']['Pages'][] = $record;
    }

echo '<pre>'; print_r($temp_array);
die();

Which gives me:

A second attempt gets me the right structure, but the like-values are not grouped. In other words, each time a page is included in Section 1 > Chapter 1 it shows as unique array instead of grouped within the Section 1 > Chapter 1 array.

$temp_array = array();
$i = 0;
foreach ($book_content as $record) {

    $temp_array[$i]['SectionName'] = $record['BookSection'];
    $temp_array[$i]['Chapters'][$i]['ChapterTitle'] = $record['ChapterTitle'];
    $temp_array[$i]['Chapters'][$i]['Pages'][$i] = $record;
    $i++;
}

写回答
好问题 0 提建议
关注问题
分享
邀请回答
编辑收藏删除结题
收藏举报

1条回答默认最新

dongsu7049 2018-10-01 19:33

关注

You need to use associative arrays that are keyed off the section names and chapter numbers, so you can group these related rows together. You're just adding a new element in the result for each element in the original array, which doesn't do any regrouping.

You go through the original array, checking whether there's already an entry for the section or chapter already in the result. If not, you add an initial entry for it, then fill it in with the details.

$result = array();
foreach ($book_content as $record) {
    $section = $record['BookSection'];
    if (!isset($result[$section])) {
        // Create initial entry for this section
        $result[$section] = array(
            'SectionName' => $section,
            'Chapters' => array());
    }
    $chapter = $record['ChapterNumber']
    if (!isset($result[$section]['Chapters'][$chapter])) {
        // Create initial entry for this chapter
        $result[$section]['Chapters'][$chapter] = array(
            'ChapterNumber' => $chapter,
            'ChapterTitle' => $record['ChapterTitle'],
            'Pages' => array());
    }
    // Add record for this page
    $result[$section]['Chapters'][$chapter]['Pages'][] = array(
        'PageID' => $record['PageID'],
        'PageText' => $record['PageText'],
        'PageNumber' => $record['PageNumber'],
        'PageIsFree' => $record['PageIsFree'],
        'PageAudioUrl' => $record['PageAudioUrl']));
}

The result of this will be an associative array rather than index. If you need it to be indexed, you can use array_values():

$result = array_values($result);
foreach ($result as &$section) {
    $section['Chapters'] = array_values($section['Chapters'];
}
unset($section); // Break the reference variable link

Don't forget the & in the foreach, which makes $section a reference, so that assigning to this affects the array you're iterating over.