Home / Questions / 303776
Accepted
Shassain
Asked: 2020-10-26 19:28:06 +0800 CST 2020-10-26 19:28:06 +0800 CST

How to correctly parse a json in php

  • 772

I have the following code that tests a url address, it returns an object JSONbut I can't access its data. I want to access the data listaMesaspecifically, and show only the data that has content:

<?php

set_time_limit(0);
$ch = curl_init();
//$i es el numero de carnet, lo pueden probar con postman si no confían.
for($i=0; $i<13;$i++)
{
curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
//La siguiente linea es la pagina del trep, lo pueden cambiar por computo si desean
curl_setopt($ch, CURLOPT_URL, "https://computo.oep.org.bo/resul/mesaElector/$i");

curl_setopt($ch, CURLOPT_HEADER, 0);

$resp=curl_exec($ch);



$json=json_decode("[$resp]");
//    aqui deberia de ir un if, pero me da error al utilizar $json->listaMesa o $json["listaMesa"]
    var_dump($i,$json);
    echo '<br>';    

}
curl_close($ch);

?>

enter image description here

How to Access the data of a JSON parcemented to show only the data that has content?

php

1 Answers

  1. Best Answer

    The errors you have are:

    • You must indicate curlthat you need it to return the data ( and not print it ) using the option CURLOPT_RETURNTRANSFER.
    • You just have to pass the variable $respto the function json_decode.

    Then you need:

    • Add a ifto validate that the array $json->listaMesais not empty.
    • To loop through the array $json->listaMesayou can use foreach.

    Solution:

    <?php

set_time_limit(0);
$ch = curl_init();
//$i es el numero de carnet, lo pueden probar con postman si no confían.
for ($i = 0; $i < 13; $i++) {

    curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
    curl_setopt($ch, CURLOPT_URL, "https://computo.oep.org.bo/resul/mesaElector/$i");
    curl_setopt($ch, CURLOPT_HEADER, 0);
    curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);

    $resp = curl_exec($ch);
    $json = json_decode($resp);
    // Si la mesa no esta vacia
    if (!empty($json->listaMesa)) {
        foreach ($json->listaMesa as $obj) {
            $mesa = $obj->mesa;
            echo 'ID: ' . $mesa->id . ' - #Mesa: ' . $mesa->numMesa . "<br/>\n";
        }
    }
}
curl_close($ch);
    • 2