Treat Json return array with CURL

Question

The code below returns real estate code results from a Rest API, and it comes with array within array, expected to treat the list to get only a Code array with its value, e.g.:

<?php
$dados = 'Codigo';

$key         =  'c9fdd79584fb8d369a6a579af1a8f681'; //Informe sua chave aqui
$postFields  =  json_encode( $dados );
$url         =  'http://sandbox-rest.vistahost.com.br/imoveis/listar?key=' . $key;
$url        .=  '&pesquisa=' . $postFields;

$ch = curl_init($url);
curl_setopt( $ch, CURLOPT_RETURNTRANSFER, true );
curl_setopt( $ch, CURLOPT_HTTPHEADER , array( 'Accept: application/json' ) );
$result = curl_exec( $ch );

$result = json_decode( $result, true );

$totalImovel = count($result);

echo '<pre>';
print_r( $result );
echo '</pre>';

Upshot:

Array
(
    [3152] => Array
        (
            [Codigo] => 3152
        )

    [3153] => Array
        (
            [Codigo] => 3153
        )

    [2448] => Array
        (
            [Codigo] => 2448
        )

    [3141] => Array
        (
            [Codigo] => 3141
        )

    [3151] => Array
        (
            [Codigo] => 3151
        )

    [25] => Array
        (
            [Codigo] => 25
        )

    [38] => Array
        (
            [Codigo] => 38
        )

    [3378] => Array
        (
            [Codigo] => 3378
        )

    [42] => Array
        (
            [Codigo] => 42
        )

    [54] => Array
        (
            [Codigo] => 54
        )

)

How to make this result look like the example below, this could not do:

{
'Codigo': 3152,
........
}

And I tried to print the results in a for:

$totalImovel = count($result);

for($i=0;$i<$totalImovel;$i++) {

echo $i."<br>";
echo $result[$i]['Codigo']."<br>";

}

But I don’t get any results.

Answer 1

Solution:

echo '<pre>';
//print_r( $result );
foreach ($result as $item) {
    echo $item['Codigo'];
    echo '<br>';
}
echo '</pre>';

What it takes is that when you call "for" with index 0 the object is not found, because the index is already coming as "3152", etc. Also you can take the direct code in the index this way:

echo '<pre>';
foreach ($result as $key => $item) {
    echo 'Código: '. $key;
    echo '<br>';
}
echo '</pre>';

Answer 2

Another option to create an array from another array using a key like index would be to use the function array_column of PHP.

$lista = array(
    3152=>array('codigo'=>3152),
    3153=>array('codigo'=>3153),
    2448=>array('codigo'=>2448),
    3141=>array('codigo'=>3141),
    3151=>array('codigo'=>3151),
);

$arr2= array_column($lista, 'codigo');

Answer 3

You can do it this way:

<?php
    $lista = array(
        3152=>array('codigo'=>3152),
        3153=>array('codigo'=>3153),
        2448=>array('codigo'=>2448),
        3141=>array('codigo'=>3141),
        3151=>array('codigo'=>3151),
    );
    $lista2 = array();
    foreach($lista as $chave => $valor){
        array_push($lista2,$valor);
    }

    $jsonObj = json_encode($lista2);
    print_r($jsonObj);
?>

If you did not want to work with JSON you can use the contents of the array $lista2