generate a php json

Question

hello

I have a problem I believe you can help me, is the following need to have a json of this genus

    {
"nodes":[
{"name":"Barry"},
{"name":"Frodo"},
{"name":"Elvis"},
{"name":"Sarah"},
{"name":"Alice"}
],
"links":[
{"source":"Barry","target":"Elvis","value":2},
{"source":"Frodo","target":"Elvis","value":2},
{"source":"Frodo","target":"Sarah","value":2},
{"source":"Barry","target":"Alice","value":2},
{"source":"Elvis","target":"Sarah","value":2},
{"source":"Elvis","target":"Alice","value":2},
{"source":"Sarah","target":"Alice","value":4}
]}

I’m generating in this way

             $stmt->execute();
        $nodes = $stmt->fetchAll(PDO::FETCH_ASSOC);
        $stmptrabalho->execute();
            $links = $stmptrabalho->fetchAll(PDO::FETCH_ASSOC);
          $array = array(
        'nodes' => $nodes,
        'links' => $links
    );
$fp = fopen('json.json', 'w');
fwrite($fp, json_encode($array,JSON_UNESCAPED_UNICODE));
fclose($fp);

generates me the file only it is all on the same line there is some way to save as the file above another thing happens to me is the value appear with "in value and should not"

new result

 "nodes": [
    {
        "name": "Alentejo Central"
    },
    {
        "name": "Alentejo Litoral"
    },
    {
        "name": "Algarve"
    },
    {
        "name": "Alto Alentejo"
    },
    {
        "name": "Alto Trás-os-Montes"
    },
    {
        "name": "Ave"
    },
    {
        "name": "Baixo Alentejo"
    },
    {
        "name": "Baixo Mondego"
    },
    {
        "name": "Baixo Vouga"
    },
    {
        "name": "Beira Interior Norte"
    },
    {
        "name": "Beira Interior Sul"
    },
    {
        "name": "Cávado"
    },
    {
        "name": "Cova da Beira"
    },
    {
        "name": "Dão-Lafões"
    },
    {
        "name": "Douro"
    },
    {
        "name": "Entre Douro e Vouga"
    },
    {
        "name": "Estrangeiro"
    },
    {
        "name": "Grande Lisboa"
    },
    {
        "name": "Grande Porto"
    },
    {
        "name": "Lezíria do Tejo"
    },
    {
        "name": "Médio Tejo"
    },
    {
        "name": "Minho-Lima"
    },
    {
        "name": "nao se aplica"
    },
    {
        "name": "Não se aplica"
    },
    {
        "name": "Oeste"
    },
    {
        "name": "Península de Setúbal"
    },
    {
        "name": "Pinhal Interior Norte"
    },
    {
        "name": "Pinhal Interior Sul"
    },
    {
        "name": "Pinhal Litoral"
    },
    {
        "name": "Região Autónoma da Madeira"
    },
    {
        "name": "Região Autónoma dos Açores"
    },
    {
        "name": "Serra da Estrela"
    },
    {
        "name": "Tâmega"
    }
],
"links": [
    {
        "source": "Alentejo Central",
        "target": "Alentejo Central",
        "value": "3939"
    },
    {
        "source": "Alentejo Central",
        "target": "Alentejo Litoral",
        "value": "47"
    },
    {
        "source": "Alentejo Central",
        "target": "Algarve",
        "value": "113"
    },

this photo is what I have in the postgres concerning the data I want to show in sankety

Answer 1

json_encode allows the use of bitmask to pass several constants to this method. I have now tested so:

<?php
$array = json_decode('{
"nodes":[
{"name":"Barry"},
{"name":"Frodo"},
{"name":"Elvis"},
{"name":"Sarah"},
{"name":"Alice"}
],
"links":[
{"source":"Barry","target":"Elvis","value":2},
{"source":"Frodo","target":"Elvis","value":2},
{"source":"Frodo","target":"Sarah","value":2},
{"source":"Barry","target":"Alice","value":2},
{"source":"Elvis","target":"Sarah","value":2},
{"source":"Elvis","target":"Alice","value":2},
{"source":"Sarah","target":"Alice","value":4}
]}');

$fp = fopen('json.json', 'w');
fwrite($fp, json_encode($array,JSON_PRETTY_PRINT|JSON_UNESCAPED_UNICODE));
fclose($fp);

Giving this result: