Json.parse does not convert to array

Question

Hello, I am a complete amateur in php and javascript and after a month of fighting with two languages I had never touched got here.

I am trying to pass a JSON from a request back to array in my javascript, but when I use parse and print the typeof variable in the console it continues as string and not array. I will leave below the codes and what appeared on the console, along with more information.

PHP code:

<?php

    include("conexao_postgres.php");

    $ano_base = $_POST["ano_ref"];

    $sql = "SELECT * FROM public.parametros_estaduais WHERE ano_base = $ano_base";
    $resultado = pg_query($dbconn, $sql);
    $resultado_array = pg_fetch_row($resultado);

    echo json_encode($resultado_array, JSON_NUMERIC_CHECK);
?>

To speed up and facilitate, I replicated the query with the test I’m doing in the main code to know faster what is happening in PHP. What comes from echo is that from here:

JSON>> [2016,0.02,347.58,528.51,902.93,1574.08,1745,880,396.49,14,152.84,207,0.35,20]

In my last question I was asked this, so I already put it, pg_query returns a query resourse to BD and pg_fetch_row (I know you have the method that links the table column names, but then I would work with an obj and prefer to work with the array q is more direct, and yes, I have tested using pg_fetch_assoc and it n converts into an obj, continues as string as well and not from the error in JSON.parse in either) returns a resourse query row as an array.

Code snippet from the request:

$.post("query.php", {ano_ref: ano_base},
    function(retorno){
        var resposta = JSON.stringify(retorno);
        console.log("Data retorno: " + retorno + "Data resposta: " + resposta + "É uma string? " + typeof resposta);
        var vetor = JSON.parse(resposta);
        console.log("Data retorno: " + retorno + "Data vetor: " + vetor + "É um array? " + typeof vetor);
});

The results of the console:

I know it’s a mess, but that’s what I’ve been able to do so far. There are n t and s dps that perform the stringfy that I have no idea where it came from. I imagine maybe that’s where the mistake came from. Another detail, I tried to convert the string that comes from the request in hand, putting in a string and doing the same process, and it works, which leads me to conclude that the format of the JSON that comes has no problems, I copied and pasted straight from the page (there is the msm php snippet in the main code, as I said to make it easy for me to see what was happening).

Suggestion of the comments*:

<?php

    include("conexao_postgres.php");

    $sql = "SELECT * FROM public.parametros_estaduais WHERE ano_base = 2016";
    $resultado = pg_query($dbconn, $sql);
    $resultado_array = pg_fetch_row($resultado);

    //echo json_encode($resultado_array, JSON_NUMERIC_CHECK | JSON_HEX_APOS | JSON_HEX_QUOT | JSON_PRESERVE_ZERO_FRACTION | JSON_UNESCAPED_UNICODE);
    $json = array();
    for($i=0; $i < count($resultado_array); $i++){
        $json[$i] = $resultado_array[$i];
    }
    echo(json_encode($json, JSON_NUMERIC_CHECK));
?>

Answer 1

Problem solved as follows:

$.post("query.php", {ano_ref: ano_base},
    function(retorno){
        // Decodificando JSON para object/array
        var dados = eval('(' + retorno.toString() + ')');
        tratarDados(dados);
});