PHP JSON Encoding within foreach loop

Question

I'm trying to generate the following JSON data:

[
    {
        "ID": "A1000",
        "name": "John Simpson",
        "serialID": "S41234",
        "tagID": "ABC6456"
    },  
    {
        "ID": "B2000",
        "name": "Sally Smith",
        "serialID": "B5134536",
        "tagID": "KJJ451345"
    },
    {
        "ID": "A9854",
        "name": "Henry Jones",
        "serialID": "KY4239582309",
        "tagID": "HYG452435"
    }
]

from within a PHP foreach loop which looks like this:

foreach($records as $record) {

        $ID = $record->getField('propertyID');
        $name = $record->getField('assignedName');
        $serialID = $record->getField('serial');
        $tagID = $record->getField('tag');

    }

I've tried using:

$arr = array('ID' => $ID, 'name' => $name, 'serialID' => $serialID, 'tagID' => $tagID);

which works for each record within the loop, but can't work out the syntax to join them together into a single JSON data string?

don't overwrite $arr each iteration, just add []

Kevin
– Kevin

2017-09-15 06:58:03 +00:00
Commented Sep 15, 2017 at 6:58 — Kevin
– Kevin, Commented Sep 15, 2017 at 6:58

Death-is-the-real-truth · Accepted Answer · 2017-09-15 07:07:13Z

6

Problem:- Your are over-writing your $arr variable each-time inside foreach() loop.That cause the issue.

Solution:- Instead of over-writing, assign values to array like below:-

$arr = []; //create empty array

foreach($records as $record) {

    $arr[] = array(
                'ID' => $record->getField('propertyID');
                'name' => $record->getField('assignedName');
                'serialID' => $record->getField('serial');
                'tagID' => $record->getField('tag')
            );//assign each sub-array to the newly created array
} 
echo json_encode($arr);

edited Sep 15, 2017 at 7:07

answered Sep 15, 2017 at 6:58

Death-is-the-real-truth

72.3k10 gold badges59 silver badges105 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

u_mulder · Accepted Answer · 2017-09-15 06:57:57Z

2

Add records to some kind of aggregation array and then json_encode it:

$items = [];
foreach($records as $record) {
    $items[] = [ 
        'ID' => $record->getField('propertyID'),
        'name' = $record->getField('assignedName'),
        'serialID' => $record->getField('serial'),
        'tagID' => $record->getField('tag'),
    ];
}

echo json_encode($items);

answered Sep 15, 2017 at 6:57

u_mulder

54.8k5 gold badges54 silver badges72 bronze badges

Comments

Mayank Pandeyz · Accepted Answer · 2017-09-15 06:58:28Z

0

Try this:

$data= array();
foreach($records as $record) {

$data[] = array(
        'ID' => $record->getField('propertyID');
        'name' => $record->getField('assignedName');
        'serialID' => $record->getField('serial');
        'tagID' => $record->getField('tag')
        );
    }

echo json_encode($data);

Explanation: Make an array, put all the values on one of their numerical index with in the loop, json_enccode() it.

answered Sep 15, 2017 at 6:58

Mayank Pandeyz

26.3k4 gold badges43 silver badges61 bronze badges

Comments

user2686713 · Accepted Answer · 2017-09-15 07:04:42Z

0

<?php
$ArrayName = array();

foreach($records as $record) {

        $ID = $record->getField('propertyID');
        $name = $record->getField('assignedName');
        $serialID = $record->getField('serial');
        $tagID = $record->getField('tag');

$ArrayName[] = array('ID' => $ID, 'name' => $name, 'serialID' => $serialID, 'tagID' => $tagID); //assign each sub-array to the newly created array

    }
echo json_encode($ArrayName);

?

> Blockquote

edited Sep 15, 2017 at 7:04

answered Sep 15, 2017 at 7:00

user2686713

112 silver badges6 bronze badges

Comments

halfer · Accepted Answer · 2019-04-26 05:42:52Z

0

You could use something like array_map() for this:

$result = array_map(function ($record) {
    return [
        'ID'       => $record->getField('propertyID'),
        'name'     => $record->getField('assignedName'),
        'serialID' => $record->getField('serial'),
        'tagID'    => $record->getField('tag'),
    ];
}, $records);

echo json_encode($result);

edited Apr 26, 2019 at 5:42

halfer

20.2k20 gold badges110 silver badges207 bronze badges

answered Sep 15, 2017 at 6:59

Rwd

35.3k7 gold badges71 silver badges85 bronze badges

Comments

Death-is-the-real-truth · Accepted Answer · 2017-09-18 09:36:34Z

-1

this code will help you:

<?php
$resultArray = array();

foreach($records as $record) 
{
        $newResultArrayItem = array();
        $newResultArrayItem['ID'] = $record->getField('propertyID');
        $newResultArrayItem['name'] = $record->getField('assignedName');
        $newResultArrayItem['serialID'] = $record->getField('serial');
        $newResultArrayItem['tagID'] = $record->getField('tag');

        $resultArray[] = $newResultArrayItem;
}

$encodedArray = json_encode($ArrayName);

echo $encodedArray;

?>

edited Sep 18, 2017 at 9:36

Death-is-the-real-truth

72.3k10 gold badges59 silver badges105 bronze badges

answered Sep 15, 2017 at 7:35

Dmitriy Buteiko

6441 gold badge6 silver badges14 bronze badges

Collectives™ on Stack Overflow

PHP JSON Encoding within foreach loop

6 Answers 6

Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related