PHP：如何创建锯齿状数组结构来表示数据库中的分组记录

发布于 2024-10-19 09:52:46 字数 806 浏览 1 评论 0原文

这似乎是一个简单的挑战，但我正在努力。

我想使用两个数据库表上的联接查询来检索记录，并将它们表示为数组的数组，其中根数组中的每个元素都是父记录，每个嵌套元素代表子记录。

SQL 查询工作正常，它返回一组行，其中 channel_key 列是分组列。

这是我从行填充数组结构的尝试：

$rows = $db->get_results($query);
$key = '';
$programmes = array();

foreach ($rows as $row) {
    $programme = array(
        'title' => $row->title,
        'start' => $row->start,
        'duration' => $row->duration
    );

    $programmes[] = $programme;

    if ($key != $row->channel_key) {
        $channels[] = array(
            'key' => $row->channel_key,
            'programme' => $programmes
        );

        $key = $row->channel_key;
        $programmes = array();
    }
}

不幸的是，这仅填充根级数组（与父记录相对应的数组）。

请问有什么建议吗？

谢谢，蒂姆

原文

This seems like a simple challenge, but I'm struggling.

I want to retrieve records using a join query on two database tables and represent them as an array of arrays, whereby each of the elements in the root array is a parent record and each nested element represents a child record.

The SQL query is working fine, and it returns a set of rows in which the channel_key column is a grouping column.

Here's my attempt at populating the array structure from the rows:

$rows = $db->get_results($query);
$key = '';
$programmes = array();

foreach ($rows as $row) {
    $programme = array(
        'title' => $row->title,
        'start' => $row->start,
        'duration' => $row->duration
    );

    $programmes[] = $programme;

    if ($key != $row->channel_key) {
        $channels[] = array(
            'key' => $row->channel_key,
            'programme' => $programmes
        );

        $key = $row->channel_key;
        $programmes = array();
    }
}

Unfortunately this only populates the root level arrays (the ones that correspond to the parent records).

Any suggestions please?

Thanks,
Tim

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

熟人话多 2024-10-26 09:52:46

当您将其分配给频道时，$programmes 数组中只有一个节目。

另一种方法是使用channel_key 构建通道数组。

例如

<?php
$channels = array();
foreach($rows as $row) {
    // Create the channel node if it doesn't exist
    if (!isset($channels[$row->channel_key])) {
        $channels[$row->channel_key] = array(
            'key' => $row->channel_key,
            'programme' => array()
        );
    }

    $programme = array(
        'title' => $row->title,
        'start' => $row->start,
        'duration' => $row->duration
    );

    // Add to the existing channel node.
    $channels[$row->channel_key]['programme'][] = $programme;
}

You only have one programme in the $programmes array when you assign it to the channel.

An alternative would be to build the channel array with the channel_key.

e.g.

<?php
$channels = array();
foreach($rows as $row) {
    // Create the channel node if it doesn't exist
    if (!isset($channels[$row->channel_key])) {
        $channels[$row->channel_key] = array(
            'key' => $row->channel_key,
            'programme' => array()
        );
    }

    $programme = array(
        'title' => $row->title,
        'start' => $row->start,
        'duration' => $row->duration
    );

    // Add to the existing channel node.
    $channels[$row->channel_key]['programme'][] = $programme;
}

回复收藏 0 原文

猛虎独行 2024-10-26 09:52:46

简单的解决方案即可。

$rows = $db->get_results($query);
$key = '';
$programmes = array();

foreach ($rows as $row) {
    $programme = array(
        'title' => $row->title,
        'start' => $row->start,
        'duration' => $row->duration
    );

$programmes[$row->channel_key][] = $programme;
}

Simple solution can be.

$rows = $db->get_results($query);
$key = '';
$programmes = array();

foreach ($rows as $row) {
    $programme = array(
        'title' => $row->title,
        'start' => $row->start,
        'duration' => $row->duration
    );

$programmes[$row->channel_key][] = $programme;
}

回复收藏 0 原文

~没有更多了~