如何使用 PHP 获得与我需要的完全相同的 JSON 格式？

Question

我需要这种 JSON 格式：{ "1" : [{"start": "", "end": ""}], "2" : [{"start": "", "end": ""}], "3" : [{"start": "", "end": ""}], "4" : [{"start": "", "end": ""}], "5" : [{"start": "", "end": ""}], "6" : [{"start": "", "end": ""}], "7" : [{"start": "", "end": ""}]}     但是使用 PHP 我得到了这种格式：[ {"1" : [{"start": "", "end": ""}]}, {"2" : [{"start": "", "end": ""}]}, {"3" : [{"start": "", "end": ""}]}, {"4" : [{"start": "", "end": ""}]}, {"5" : [{"start": "", "end": ""}]}, {"6" : [{"start": "", "end": ""}]}, {"7" : [{"start": "", "end": ""}]},]索引“1”、“2”……对应于一周中的一天。每个索引都有 'n' 个小时范围（数组），格式为 {start: "", end: ""},...例如：{start: "12:00:00",end:"14:00:00"},{start: "14:00:00","15:00:00"},...我使用 PHP 函数从表中获取天数，然后使用“foreach”进行迭代以在每次迭代中获取同一表中的小时范围，然后迭代这些范围以创建所需的格式。最后一步是使用“json_encode”进行格式化。    //Getting all days data from DB given user ID     $aDays = Schedule::getDays($nIdUser);    //Array to Store Data    $aJson = [];    //Iteration    foreach ($aDays as  $aInfoDay) {        //Getting single day hour range given day ID         $aRangesHours = Schedule::getDayRanges("id_day = {$aInfoDay['id_day']} AND id_user = {$nIdUser}");        $aParsedDay = [];        //Iterate Ranges        foreach ($aRangesHours as $aRangeHour) {            $aParsedDay[$aRangeHour['id_day']][] = array('start' => $aRangeHour['startHour'],'end' => $aRangeHour['endHour']);        }        //Store Data in aJson Array        $aJson[] = $aParsedDay;    }

Answer 1

尝试这个 ：

let arr = [

 {"1" : [{"start": "", "end": ""}]},

 {"2" : [{"start": "", "end": ""}]},

 {"3" : [{"start": "", "end": ""}]},

 {"4" : [{"start": "", "end": ""}]},

 {"5" : [{"start": "", "end": ""}]},

 {"6" : [{"start": "", "end": ""}]},

 {"7" : [{"start": "", "end": ""}]},

];

let obj = {};

arr.map((item,index) => {

    obj[index + 1] = item[index + 1];

});

console.log(obj);

Answer 2

感谢您的编辑建议。在对 JSON 格式进行了一些挖掘后，我发现我需要创建数组对象而不是数组：

    //Getting all days data from DB given user ID

    $aDays = Schedule::getDays($nIdUser);

    //Object Array to Store Data

    $oJson = (object)array();

    //Iteration

    foreach ($aDays as  $aInfoDay) {

        //Getting single day hour ranges given day ID

        $aRangesHours = Schedule::getDayRanges("id_day = {$aInfoDay['id_day']} AND id_user = {$nIdUser}");

        //Array to Store all Hour Ranges in a Day

        $aParsedDay = array();

        //Iterate Ranges

        foreach ($aRangesHours as $aRangeHour) {

            //Object Array to Store Single Hour Range

            $oRange = (object)array();

            $oRange->start = $aRangeHour['startHour'];

            $oRange->end = $aRangeHour['endHour'];

            //Pushing Range object to $aParsedDay Array, this is for keeping the [{"start":"","end":""},...}] format 

            array_push($aParsedDay,$oRange);

            //Saving $aParsedDay in $oJson Object, the name of the index will be the current 'id_day'

            $oJson->{$aRangeHour['id_day']} = $aParsedDay;

        }

    }

    //result

    echo json_encode($oJson);

获取所需的格式：

{

 "1" : [{"start": "12:00:00", "end": "13:00:00"}],

 "2" : [{"start": "09:00:00", "end": "10:00:00"},{"start": "10:00:00", "end": "12:00:00"}],

 "3" : [{"start": "15:00:00", "end": "16:00:00"},{"start": "16:00:00", "end": "17:00:00"}]

} 

Answer 3

当你这样做时$aJson[] = $aParseDay;，你正在考虑$aJson一个$aParseDay对象数组。您需要做的是更改要分配的第二个 foreachstart和内部end的id_day键$aJson。

foreach ($aDays as  $aInfoDay) {

    $aRangesHours = Schedule::getDayRanges("id_day = {$aInfoDay['id_day']} AND id_user = {$nIdUser}");

    $aParsedDay = [];

    foreach ($aRangesHours as $aRangeHour) {

        $aJson[$aRangeHour['id_day']][] = ['start' => $aRangeHour['startHour'],'end' => $aRangeHour['endHour']];

    }

}