Question

然而,我有一套数据库成果,我需要将其整理成一个多层面的阵列,以便我能够把其结果传递给用户一个电子邮件而不是多个电子邮件。

我从db中得出的数值是姓名、电子邮件、路线_名称、路线_细节。理想的情况是,我要根据用户电子邮件把路线集中起来,因为这是他们独特的识别特征。我认为,对我来说,这样一些东西会奏效。

    Array
    (
       [[email protected]] => Array
                          (
                            [0] => name
                            [1] => Array
                                 (
                                   [0] => route_name
                                   [1] => route_details
                                 )
                             [2] => Array
                                 (
                                   [0] => route_name
                                   [1] => route_details
                                 )
                           )
       [[email protected]] => Array
                          (
                            [0] => name
                            [1] => Array
                                 (
                                   [0] => route_name
                                   [1] => route_details
                                 )
                            [2] => Array
                                 (
                                   [0] => route_name
                                   [1] => route_details
                                 )
                            [3] => Array
                                 (
                                   [0] => route_name
                                   [1] => route_details
                                 )

                           )
    )

任何帮助都会受到高度赞赏,我已在我的成果圈子里尝试过以下工作,但我不知道如何根据电子邮件将结果归类,我认为这确实是我所需要的。

    $routeArray = array($data->email ,array($data->route_name, $data->route_details));

    $userEmailArray[] = $flightArray;

成就

Answer 1

我认为,以下工作将有利于你。该法典将增加关键名称,而不是数字指数。

// Add order by email clause
$sql = "select name, email, route_name, route_details from YOUR SQL QUERY ORDER BY    email";
$res = mysql_query($sql);

$desired_format = array();

while($row = mysql_fetch_assoc($res)){
    $tmp = array( route_name =>$row[ route_name ], route_details =>$row[ route_details ]);
    $desired_format[$row[ email ]][ name ] = $row[ name ];
    $desired_format[$row[ email ]][] = $tmp;
}

友情链接