数组中的特定值无法工作。

Question

我有个关于我的数组的问题。如何在我的里程碑数组中只获得里程碑的数据？

我有一个查询，它是一个前缀数组。我得到里程碑和里程碑的数据(这是里程碑部分)。

这是我的密码：

$stones_fases = array();
while ($row = $db->fetchassoc($result)){
    $milestonefase = array();
    $milestone = array();

    foreach ($row as $mkey => $mvalue){
        $milestone[$mkey] = $mvalue;
        foreach ($row as $fkey => $fvalue){
            $milestonefase[$fkey] = $fvalue;
        }
    }

    if (!isset($stones_fases[$milestone['milestone_id']])){
        $stones_fases[$milestone['milestone_id']] = $milestone; //['client']['milestone_verkocht_id']
    }
    $stones_fases[$milestone['milestone_id']][$milestonefase['milestonefase_id']] = $milestonefase['milestonefase_titel'];
}

我得到这个：

Array
(
    [int] => Array
        (
            [milestone_id] => int
            [milestone_titel] => string
            [client] => string
            [milestone_verkocht_id] => 99
            [milestonefase_id] => 10
            [milestonefase_titel] => string
            [milestonefase_milestone_id] => 6
            [10] => string
            [11] => string
        )
)

但我想要这样：

Array
(
    [int] => Array
        (
            [milestone_titel] => string
            [client] => string
            [milestone_verkocht_id] => int
            [10] => string
            [11] => string
        )
)

我的疑问是：

$project = $_COOKIE['project'];
$query = " SELECT 
                 a.id AS `milestone_id`, 
                 a.titel AS `milestone_titel`, 
                 a.client AS `client`,
                 a.verkocht_id AS `milestone_verkocht_id`,

                 b.id AS `milestonefase_id`, 
                 b.titel AS `milestonefase_titel`,
                 b.milestone_id AS `milestonefase_milestone_id`
                 FROM `milestones` a
                 INNER JOIN `milestone_parts` b ON a.id=b.milestone_id
                 WHERE a.verkocht_id = '{$project}' ";
$result= $db->query($dbh, $query);

Answer 1

我自己解决了问题！

如果我这么做：

while ($row = $db->fetchassoc($result)){
    $stones_fases[$row['milestone_id']]['milestone_titel'] = $row['milestone_titel'];
    $stones_fases[$row['milestone_id']]['milestone_client'] = $row['client'];
    $stones_fases[$row['milestone_id']]['milestonesfases'][$row['milestonefase_id']] = $row['milestonefase_titel'];
}

我得到了我所期望的：

Array
(
    [2] => Array
        (
            [milestone_titel] => Beheer opleveren
            [milestone_client] => stackoverflow
            [milestonesfases] => Array
                (
                    [1] => Menu bouwen
                    [2] => Pagina beheer CMS
                    [3] => Projecten CMS
                    [4] => Portfolio
                    [5] => Footer inbouwen
                )

        )

)

看看我一天前写的那堆代码。

你看到我写的那些毫无意义的代码了吗？

看看我一分钟前写的代码！

我挣扎了三天，现在我解决了我自己的问题！