Home / Questions / 269580
Accepted
Javier
Asked: 2020-06-05 13:21:32 +0800 CST 2020-06-05 13:21:32 +0800 CST

Form a json in php

  • 772

How could one form jsonlike this:

enter image description here

I do it this way but I don't know how to complete what follows from the json:

<?php
  $respuestas = array("fecha"=>'8850',"glosa"=>'8900',"gasto_no_deducible"=>'8875','prefijo'=>'512');
  $json = json_encode($respuestas);
  echo $json;
?>
php

3 Answers

  1. Best Answer

    Try to do it this way, it's an example:

    $data = array(
    array("valor1" => 1, "valor2" => 2, "valor3" => array(
        array("valora" => 1, "valorb" => 2),
        array("valora" => 3, "valorb" => 4),
        array("valora" => 5, "valorb" => 6),
        array("valora" => 7, "valorb" => 8)
    ))
);

echo json_encode($data, JSON_PRETTY_PRINT);

    Which gives me this result:

    [
    {
        "valor1": 1,
        "valor2": 2,
        "valor3": [
            {
                "valora": 1,
                "valorb": 2
            },
            {
                "valora": 3,
                "valorb": 4
            },
            {
                "valora": 5,
                "valorb": 6
            },
            {
                "valora": 7,
                "valorb": 8
            }
        ]
    }
]

    Explanation

    • I create a multidimensional array, so there is one statement arraythat wraps the others.
    • I create a second arrayinternal one that has the keys and values ​​of: date, gloss, expense_no_dducible, prefix and details
    • To form the group of values, which are linked to the details key , we do this: detalles: array(....., so that the value of said key will be a collection of records, the 4 groups that it has inside.

    your exercise

    $data = array(
    array("fecha" => "16/05/2017", "glosa" => "Asiento VIP", "gasto_no_deducible" => 0, "prefijo" => "ASI",  "detalles" => array(
        array("cuenta_id" => "dfsdsf", "valor" => 10, "tipo" => "D", "centro_costo_id" => "dfssdffsd"),
        array("cuenta_id" => "dfsdsf", "valor" => 150, "tipo" => "D", "centro_costo_id" => "dfssdffsd"),
        array("cuenta_id" => "dfsdsf", "valor" => 100, "tipo" => "H", "centro_costo_id" => "dfssdffsd"),
        array("cuenta_id" => "dfsdsf", "valor" => 150, "tipo" => "H", "centro_costo_id" => "dfssdffsd"),
    ))
);

echo json_encode($data, JSON_UNESCAPED_SLASHES | JSON_PRETTY_PRINT);

    Resulting:

    [
    {
        "fecha": "16/05/2017",
        "glosa": "Asiento VIP",
        "gasto_no_deducible": 0,
        "prefijo": "ASI",
        "detalles": [
            {
                "cuenta_id": "dfsdsf",
                "valor": 10,
                "tipo": "D",
                "centro_costo_id": "dfssdffsd"
            },
            {
                "cuenta_id": "dfsdsf",
                "valor": 150,
                "tipo": "D",
                "centro_costo_id": "dfssdffsd"
            },
            {
                "cuenta_id": "dfsdsf",
                "valor": 100,
                "tipo": "H",
                "centro_costo_id": "dfssdffsd"
            },
            {
                "cuenta_id": "dfsdsf",
                "valor": 150,
                "tipo": "H",
                "centro_costo_id": "dfssdffsd"
            }
        ]
    }
]

    Necessary

    Lastly you can use the PHP constant called JSON_UNESCAPED_SLASHESwhich will prevent escaping slashes.

    In addition to the above.

    Optional

    I also use JSON_PRETTY_PRINTto be able to get the result in an indented way and similar to your image, it is important to remember to separate the 2 previous constants by the | symbol. although this constant is not strictly necessary

    • 1

  2. The only thing you have to do is put little ones arrayinside a arraymain, when doing json_encodeit they will become a single arrayobject:

    <?php 

$respuestas = [
    "fecha"=>'8850',
    "glosa"=>'8900',
    "gasto_no_deducible"=>'8875',
    'prefijo'=>'512',
    "detalles"=>[
        [
            "cuenta_id"=>"MZN.....",
            "valor"=>10,
            "tipo"=>"D",
            "centro_costo_id"=>"EGO..."
        ],
        [
            "cuenta_id"=>"x5o.....",
            "valor"=>150,
            "tipo"=>"D",
            "centro_costo_id"=>"EGO..."
        ],
        [
            "cuenta_id"=>"EGO.....",
            "valor"=>100,
            "tipo"=>"H",
            "centro_costo_id"=>""
        ],
        [
            "cuenta_id"=>"qlw.....",
            "valor"=>150,
            "tipo"=>"H",
            "centro_costo_id"=>""
        ]
    ]
];
$json = json_encode($respuestas);
echo $json;

?>

    enter image description here

    • 0

  3. You would have to create an array of arrays for the missing element, something like this:

    <?php
  $respuestas = array("fecha"=>'8850',"glosa"=>'8900',"gasto_no_deducible"=>'8875','prefijo'=>'512', 'detalles' => array(array('cuenta_id' => '123a', 'valor' => 10),array('cuenta_id' => '123b', 'valor' => 11) ));
  $json = json_encode($respuestas);
  echo $json;
?>

    enter image description here

    • 0