Building nested arrays in PHP

Question

So I'm trying to build a JSON object with an array nested inside the main users array.

I'm having a bit of trouble building the data model in the PHP. Can anyone give any pointers?

Desired output:

[{
            id: 2,
            name: "John Wilson",
            profilePic: "fighter-1.jpg",
            activities: [{
                id: 6431,
                time: (57).minutes().ago(),
                points: 20
            }, {
                id: 6431,
                time: new Date(),
                points: 20
            }]
        }, {
            id: 3,
            name: "Christoper Robin",
            profilePic: "fighter-3.jpg",
            activities: [{
                id: 6431,
                time: (1).days().ago,
                points: 20
            }, {
                id: 6431,
                time: (2).days().ago,
                points: 20
            }, {
                id: 6431,
                time: new Date(),
                points: 20
            }]
        }, {
            id: 1,
            name: "Jerry Seinfeld",
            profilePic: "placeholder.jpg",
            activities: [{
                id: 6431,
                time: new Date(),
                points: 20
            }, {
                id: 6431,
                time: new Date(),
                points: 20
            }, {
                id: 6432,
                time: new Date(),
                points: 100
            }]
        }]

The PHP and MySQL:

$getCompUsers = mysql_query("SELECT c.userid, u.name, u.profilePic, a.activity_typeid, a.userid, a.time, a.activity_weight, a.activityname
        FROM competitionmembers c 
        INNER JOIN users1 u ON  u.id = c.userid 
        INNER JOIN activity_entries a ON a.userid = u.id
        WHERE c.competitionid = '$competitionId'") or die("Couldn't select competitions users");

$compUsersArr = array();
while ($row = mysql_fetch_array($getCompUsers,MYSQL_ASSOC)){

$compUsersArr = array(
            'id' => $row["userid"],
            'name'=> $row["name"],
            'profilePic' => $row["profilePic"], 
                $activities = array( //THIS SEEMS TO BE THE PROBLEM
                    'id' => $row["activity_typeid"],
                    'name' => $row["activityname"],
                    'points' => $row["activity_weight"]
                    )
            );
    }

Some pointers for you: 0x3A28213A 0x6339392C, 0x7363682E

Ja͢ck
– Ja͢ck

2014-03-02 14:19:23 +00:00
Commented Mar 2, 2014 at 14:19 — Ja͢ck
– Ja͢ck, Commented Mar 2, 2014 at 14:19

Community · Accepted Answer · 2023-11-17 19:58:40Z

2

The way you are making your array is wrong, to nest arrays you don't have to use variables in array as you did

$compUsersArr = array(
        'id' => $row["userid"],
        'name'=> $row["name"],
        'profilePic' => $row["profilePic"], 
        'activities' => array(
            'id' => $row["activity_typeid"],
            'name' => $row["activityname"],
            'points' => $row["activity_weight"]
        )
);

edited Nov 17, 2023 at 19:58

CommunityBot

11 silver badge

answered Mar 2, 2014 at 14:22

Fabio

23.5k12 gold badges57 silver badges66 bronze badges

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

1 Comment

user2656127 Over a year ago

other than the small typo = should be => when building the 2nd array, that's great. Thanks! :D

Ja͢ck · Accepted Answer · 2014-03-02 14:42:48Z

1

Actually, your code was almost correct; splitting it up will make you see why it didn't:

$activities = array(
    'id' => $row["activity_typeid"],
    'name' => $row["activityname"],
    'points' => $row["activity_weight"]
);

$compUsersArr = array(
    'id' => $row["userid"],
    'name'=> $row["name"],
    'profilePic' => $row["profilePic"], 
    $activities,
);

This will create an array like:

[
    'id' => 123, 
    'name' => 'foo', 
    'profilePic' => 'bar', 
    0 => ['id' => 456, 'name' => 'baz', 'points' => 'quz']
]

You would probably want this:

$compUsersArr = array(
    'id' => $row["userid"],
    'name'=> $row["name"],
    'profilePic' => $row["profilePic"], 
    'activities' => $activities,
);

edited Mar 2, 2014 at 14:42

answered Mar 2, 2014 at 14:34

Ja͢ck

174k39 gold badges269 silver badges317 bronze badges

Collectives™ on Stack Overflow

Building nested arrays in PHP

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related