Errors converting Array Php to JSON

Question

I am having some troubles to convert a multidimensional PHP Array to JSON. I convert it with json_encode, but it gets null.

I am trying to develop an orgChart, the data is read from an CSV file and saved in an array. The layout and JS code is built to receive a JSON file, so I need it in that format.

This is an slice of the array, it contains 175 arrays within

Array
(
    [2] => Array
        (
            [id] => 1
            [nome] =>  ELOTECH
            [cargo] => "" 
            [idcargo] => 1
            [pai] => 0
        )

    [3] => Array
        (
            [id] => 10
            [nome] => Departamento Pessoal
            [cargo] => 
            [idcargo] => 10
            [pai] => 1
        )

    [4] => Array
        (
            [id] => 20
            [nome] => Comercial
            [cargo] => 
            [idcargo] => 20
            [pai] => 1
        )

)

I am using json_encode to convert the array to JSON OBS: *** $colab is the array's name fed by the CSV

$dados_json = json_encode($colab);
$fp = fopen("jsonOrgan.json", "w");
$write = fwrite($fp, $dados_json);
fclose($fp);

I need it to output on JSON as follow:

[{
    "id": 1,
    "cargo": "ELOTECH",
    "nome": "",
    "idcargo": 1,
    "pai": 0
}]

But it return null

Here is how I create the array from the CSV file.

while ($line = fgetcsv($save, 1000, ";")) {
    if ($linha++ == 0) {
        continue;
    }
 $colab[$linha] = [
                'id' => $line[0],
                'nome' => $line[1],
                'cargo' => $line[4],
                'idcargo' => $line[0],
                'pai' => $line[5],
            ];}

I know what is the problem, but you must accept my edit on your post first. — Roger Russel
– Roger Russel, Commented Nov 13, 2018 at 18:56

Jean Lima · Accepted Answer · 2018-11-13 19:35:15Z

3

With Roger Russel's instructions, my problem got solved.

The JSON was getting NULL because of the encoding. I used the uft8_encode and solved this problem. Then i changed the array creation to fit the pattern that I need the JSON file to be.

I was creating the Array Using a counter as index, as follow:

$colab[$linha] = [
                'id' => $line[0],
                'nome' => $line[1],
                'cargo' => $line[4],
                'idcargo' => $line[0],
                'pai' => $line[5],
            ]

Then changed it to be created without passing the index:

$colab[] = [
                    'id' => $line[0],
                    'nome' => $line[1],
                    'cargo' => $line[4],
                    'idcargo' => $line[0],
                    'pai' => $line[5],
                ]

And that's it, my problem was solved!

Thank you!

edited Nov 13, 2018 at 19:35

answered Nov 13, 2018 at 19:30

Jean Lima

939 bronze badges

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

3 Comments

Motassem Kassab Over a year ago

Good job finding the problem and solution on your own then sharing it for others, keep up the good work :)

Jean Lima Over a year ago

It wasn't on my own, @Roger Russel made all the job

Roger Russel Over a year ago

One is glad to be of service

Collectives™ on Stack Overflow

Errors converting Array Php to JSON

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related