How to create this array structure in PHP

Question

I am trying to create an array structure like the initial one found here: D3 JSON data conversion

Mine would look something like the below, be dynamic, and then be passed to json_encode() to make a json object.

[
  { "name": "Table1", "lab": "name1", "cell": "c1", "avg": avgUsage1},
  { "name": "Table1", "lab": "name2", "cell": "c2", "avg": avgUsage2},
  { "name": "Table1", "lab": "name3", "cell": "c3", "avg": avgUsage3},
  { "name": "Table1", "lab": "name4", "cell": "c4", "avg": avgUsage4},
  { "name": "Table1", "lab": "name5", "cell": "c5", "avg": avgUsage5} ...
]

The problem is that I cannot have an array that has the same values for the key. What is this data structure and how can I create something like it to then create a nested structure (I will follow the linked post to create the nested structure)?

charlietfl · Accepted Answer · 2016-09-25 23:34:14Z

3

Not sure why you think there would be same keys. You would have a multidimensional array in php that would look like:

$arr = array(
    array( "name"=> "Table1", "lab"=> "name1", "cell"=> "c1", "avg"=>$avgUsage1),
    array( "name"=> "Table2", "lab"=> "name2", "cell"=> "c2", "avg"=>$avgUsage2),
    //....
);

or each element could also be a stdClass object

answered Sep 25, 2016 at 23:34

charlietfl

172k14 gold badges125 silver badges154 bronze badges

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

4 Comments

noc_coder Over a year ago

Is it possible to add multiple mysql table values in the "avg" field to be displayed along with the avg? Something like: Value1, Value2..... AVG(Values)?

noc_coder Over a year ago

Thats the thing... Its for a d3 visualization. Each nest will mean something different. stackoverflow.com/questions/19317115/… So instead of this: { "dep": "First Top", "name": "First child", "model": "value1", "size": "320" }, I am looking for this: {"lab": "labname", "cell", "cell_name", "usage": Week1, Week2, Week3, Week4, Week5, Avg( Week1 + Week2 + Week3 + Week4 + Week5) }.

charlietfl Over a year ago

that's not a valid javascript structure. Also note that it isn't what you asked in question either

noc_coder Over a year ago

I thought so. Ill see if I can concat the values as a string or something. Thanks for the help.

Dominique Lorre · Accepted Answer · 2016-09-25 23:34:32Z

1

You can initialize it like that:

$arrayJSON = array(
    array(
        "name" => "Table1",
        "lab" => "name1",
        "cell" => "c1",
        "avg" => "avgUsage1"
    ),
    array(
    ....
    )
);

You can also make an array of class instances.

answered Sep 25, 2016 at 23:34

Dominique Lorre

1,1561 gold badge10 silver badges20 bronze badges

2 Comments

noc_coder Over a year ago

Array of class instances? stackoverflow.com/questions/8612190/array-of-php-objects Something like this?

Dominique Lorre Over a year ago

@noc_coder like this

Collectives™ on Stack Overflow

How to create this array structure in PHP

2 Answers 2

4 Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related