Create array for Data JSON

Question

I'm starting with DataTables (https://datatables.net/)

And I'm trying to reload my table with json source.

From PHP code: I want to create an json array:

$fh = fopen("pv1_consultafolioTorre".".json", 'w');
while($row = mssql_fetch_array($query_result))
  {
     $a = array(
       array(
         'folio' => $row['folio'],
         'MATNR' => $row['MATNR'],
         'sucursalSolcitante' => $sucursalSolcitante,
         'sucursalResponsable' => $sucursalResponsable,
         'fechaSolicitud' => $row['fechaSolicitud'],
         'cantidadSolicitada' => $row['cantidadSolicitada'],
         'MATNR' => $row['MATNR'],
         'fechaConfirmacion' => $row['fechaConfirmacion'],
         'cantidadConfirmada' => $row['cantidadConfirmada'],
         'tiempoConfirmacion' => $result,
         'estatus' => 'Pendiente'
       ));

       $jsonencoded = json_encode($a, 128);
       print json_encode($a);
       fwrite($fh, $jsonencoded);
  }

  fclose($fh);

and I obtain this:

[
    {
        "folio": "99001091347",
        "MATNR": "033999900         ",
        "sucursalSolcitante": " CDG1 MATRIZ",
        "sucursalResponsable": " SC13 TIJUANA CENTRO",
        "fechaSolicitud": "2015-05-23 09:13",
        "cantidadSolicitada": 1,
        "fechaConfirmacion": "2015-05-23 09:14:47",
        "cantidadConfirmada": 1,
        "tiempoConfirmacion": 4,
        "estatus": "Aprobado"
    }
]

But I DataTables need the next structure:

{
    "data": [
        [
            "99001091347",
            "033999900         ",
            " CDG1 MATRIZ",
            " SC13 TIJUANA CENTRO",
            "2015-05-23 09:13",
            "1",
            "2015-05-23 09:14:47",
            "1",
            "4",
            "Aprobado"
        ]
    ]
}

How can I fix this?

tommy · Accepted Answer · 2015-05-23 15:31:13Z

If you need to keep the associative array for writing it to your .json-file and echo the data for DataTables, then you can fetch the array values from your data array and create a new one for the JSON output:

$json_data = array();

while($row = mssql_fetch_array($query_result))
{
    $data = array(
        'folio' => $row['folio'],
        'MATNR' => $row['MATNR'],
        'sucursalSolcitante' => $sucursalSolcitante,
        'sucursalResponsable' => $sucursalResponsable,
        'fechaSolicitud' => $row['fechaSolicitud'],
        'cantidadSolicitada' => $row['cantidadSolicitada'],
        'MATNR' => $row['MATNR'],
        'fechaConfirmacion' => $row['fechaConfirmacion'],
        'cantidadConfirmada' => $row['cantidadConfirmada'],
        'tiempoConfirmacion' => $result,
        'estatus' => 'Pendiente'
    );

    // write the array to a file if needed

    $json_data[] = array_values($data); // Transforming for DataTables
}

// Build the final DataTables array
$data_tables_array = array(
    'data' => $json_data
);

$jsonencoded = json_encode($data_tables_array);
echo $jsonencoded;

Richard · Accepted Answer · 2015-05-23 15:22:16Z

0

try this code

$output['data'] = [];

$fh = fopen("pv1_consultafolioTorre".".json", 'w');
while($row = mssql_fetch_array($query_result))
{
  $output['data'][] = array(
                    $row['folio'],
                    $row['MATNR'],
                    $sucursalSolcitante,
                    $sucursalResponsable,
                    $row['fechaSolicitud'],
                    $row['cantidadSolicitada'],
                    $row['MATNR'],
                    $row['fechaConfirmacion'],
                    $row['cantidadConfirmada'],
                    $result,
                    'Pendiente'
                );
}


print $jsonencoded = json_encode($output, 128);
fwrite($fh, $jsonencoded);

edited May 23, 2015 at 15:22

Richard

2,8154 gold badges27 silver badges37 bronze badges

answered May 23, 2015 at 15:16

Reza1607

581 silver badge8 bronze badges

6 Comments

splash58 Over a year ago

enough $jsonencoded = json_encode(array('data' =>array($a)), 128);

Richard Over a year ago

@splash58: Then you have the keys in the array. I do not know it that works with DataTables.

splash58 Over a year ago

@Richard Reiber here is the output : {"data":[[{"folio":"99001091347"... Whatch there eval.in/369125

Reza1607 Over a year ago

@splash58: In this case, if an object was returned must be in an array.

splash58 Over a year ago

I see that output is that autor of the question wanted, isn't it?

|

Richard · Accepted Answer · 2015-05-23 15:14:18Z

0

Use this instead:

$fh = fopen("pv1_consultafolioTorre".".json", 'w');
$arr = Array();
while($row = mssql_fetch_array($query_result))
  {
     array_push($arr, array(
         $row['folio'],
         $row['MATNR'],
         $sucursalSolcitante,
         $sucursalResponsable,
         $row['fechaSolicitud'],
         $row['cantidadSolicitada'],
         $row['MATNR'],
         $row['fechaConfirmacion'],
         $row['cantidadConfirmada'],
         $result,
         'Pendiente'
       ));
  }

  print $jsonencoded = json_encode(Array("data" => $arr), 128);
  fwrite($fh, $jsonencoded);

  fclose($fh);

answered May 23, 2015 at 15:14

Richard

2,8154 gold badges27 silver badges37 bronze badges

Comments

Sashant Pardeshi · Accepted Answer · 2015-05-23 15:54:24Z

Please try below code. I have inserted $data = array('data' => $a); and changed $row[] in array as well. You will get desired output.

$fh = fopen("pv1_consultafolioTorre".".json", 'w');
        while($row = mssql_fetch_array($query_result))
          {
           $a = array(
                   array(
            $row['folio'],
            $row['MATNR'],
            $sucursalSolcitante,
            $sucursalResponsable,
            $row['fechaSolicitud'],
            $row['cantidadSolicitada'],
            $row['MATNR'],
            $row['fechaConfirmacion'],
            $row['cantidadConfirmada'],
            $result,
            'Pendiente'
           )
        );

    $data = array('data' => $a); // added by me.
    $jsonencoded = json_encode($data, 128);
    print json_encode($jsonencoded);
    fwrite($fh, $jsonencoded);

      }

      fclose($fh);

Collectives™ on Stack Overflow

Create array for Data JSON

4 Answers 4

Comments

6 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

6 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related