Multilevel php array for json string. Output wrong

Question

I try to generate a multilevel PHP Array with a DB-Connection that i can encode in JSON. The output have an square-bracket-pair to much that i want to remove.

I have following php-code

## Step 1 #################
    do{
    $tabContent[] = array
        (
            "name" => $row_profile['name'],
            "titel" => $row_profile['titel']
        );
}while ($row_profile = $statement_profile->fetch(PDO::FETCH_ASSOC));

## Step 2 #################
$tabelled['repositories'] = array 
    (
        $tabContent
    );


## Step 3 #################
header('Content-Type: application/json');
echo json_encode($tabelled, JSON_PRETTY_PRINT);

So now i have the following response:

{
    "repositories": [
        [
            {
                "name": "test",
                "titel": "a sdfaf"
            },
            {
                "name": "Frank wieder",
                "titel": "test test"
            }
        ]
    ]
}

but i need following output

{
  "repositories": [
    {
        "name": "test",
        "titel": "a sdfaf"
    },
    {
        "name": "Frank wieder",
        "titel": "test test"
    }
  ]
}

So the error is on step 1 the square bracket after the variable $tabContent. But without i cannot make the multilevel array. What can i do, to remove the second square bracket after "repositories"?

Thomas · Accepted Answer · 2018-05-13 01:15:53Z

1

Your $tabContent is already an array, and you're wrapping it inside of an extra array. Without that, it should come out as expected.

$tabelled['repositories'] = $tabContent;

answered May 13, 2018 at 1:15

Thomas

4524 silver badges11 bronze badges

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

Collectives™ on Stack Overflow

Multilevel php array for json string. Output wrong

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related