Follow

Keep Up to Date with the Most Important News

By pressing the Subscribe button, you confirm that you have read and are agreeing to our Privacy Policy and Terms of Use
Contact

PHP api call, but format is strange

JSON Return (Image)

What to do? since if i parse with json i only get the "xx.xx" values

<?php
  header('Access-Control-Allow-Origin: *');
  $url = "https://www.henrikhjelm.se/api/getdata.php?lan=kronobergs-lan";
  $json = file_get_contents($url);
  $json_data = json_decode($json, true);
  
  foreach ($json_data as $value) {
    echo "Value: $value <br>";
  }

?>

this is the code I use, I only get the values that are in "" from the api. But I need both the first value and the value inside "". Don’t know how to do it.

MEDevel.com: Open-source for Healthcare and Education

Collecting and validating open-source software for healthcare, education, enterprise, development, medical imaging, medical records, and digital pathology.

Visit Medevel

var_dump($json)

string(8728) "{"kronobergslan_Ingo_VaxjoSmedjegatan_28__Morners_vag__biodiesel": "34.23","kronobergslan_OKQ8_VaxjoStora_Vagen_6__biodiesel": "10.04","kronobergslan_OKQ8_VaxjoArabygatan_53__etanol": "19.24","kronobergslan_Tanka_MarkarydHassleholmsvagen_2__etanol": "19.24","kronobergslan_Preem_VaxjoOstregardsgatan_51__etanol": "19.24","kronobergslan_OKQ8_MarkarydGlasbruksvagen_15_Stromsnasbruk__etanol": "19.24","kronobergslan_Tanka_AlvestaBladingevagen_20__etanol": "19.24","kronobergslan_OKQ8_LjungbyHelsingborgsvagen__etanol": "19.24","kronobergslan_Tanka_LjungbyNyponvagen_7__etanol": "19.24","kronobergslan_OKQ8_LesseboStorgatan_60__etanol": "19.24","kronobergslan_St1_VaxjoVingavagen_1__etanol": "19.14","kronobergslan_St1_VaxjoMorners_Vag_2__etanol": "19.14","kronobergslan_Ingo_VaxjoSoderleden_2__etanol": "19.14","kronobergslan_Ingo_LjungbyHarabergsgatan__etanol": "19.14","kronobergslan_St1_LjungbyMarta_Ljungbergsvagen_56__etanol": "19.14","kronobergslan_St1_MarkarydDrottninggatan_50__etanol": "19.14","kronobergslan_Ingo_VaxjoSmedjegatan_28__Morners_vag__etanol": "34.23","kronobergslan_Preem_TingsrydLokgatan__etanol": "19.41","kronobergslan_Preem_MarkarydUlvarydsvag__etanol": "19.39","kronobergslan_Circle_K_VaxjoSodra_Vallviksvagen_352_51_Vaxjo__etanol": "19.39","kronobergslan_Circle_K_LjungbyRingvagen_1__etanol": "19.39","kronobergslan_Preem_UppvidingeJarnvagsgatan_Aseda__etanol": "19.39","kronobergslan_Preem_VaxjoVarnamovagen_Lammhult__etanol": "19.39","kronobergslan_Circle_K_UppvidingeVaxjovagen_Lenhovda__etanol": "19.39","kronobergslan_Preem_VaxjoSandviksvagen__etanol": "19.39","kronobergslan_Circle_K_VaxjoJonkopingsvagen_14_Lammhult__etanol": "19.39","kronobergslan_OKQ8_VaxjoSambandsvagen_2__etanol": "19.39","kronobergslan_Preem_LjungbyLanggatan_2__etanol": "19.39","kronobergslan_Circle_K_LjungbyLagan__etanol": "19.39","kronobergslan_OKQ8_VaxjoNorremarksvagen_2__etanol": "19.39","kronobergslan_Circle_K_VaxjoHejaregatan_17__etanol": "19.39","kronobergslan_Circle_K_VaxjoEvedalsvagen__etanol": "19.39","kronobergslan_OKQ8_UppvidingeAspvagen_9_Alstermo__etanol": "19.39","kronobergslan_Preem_AlmhultS_Esplanaden__etanol": "19.24","kronobergslan_OKQ8_AlvestaFabriksgatan_3__etanol": "19.24","kronobergslan_Tanka_AlmhultDanska_Vagen_4__etanol": "19.24","kronobergslan_OKQ8_Almhultalmhult_ringvagen_10__etanol": "19.24","kronobergslan_dinX_TingsrydSodra_vagen_19_urshult__etanol": "19.24","kronobergslan_OKQ8_AlmhultSodra_Ringvagen_10__etanol": "19.24","kronobergslan_Tanka_VaxjoLjungadalsgatan_1__etanol": "19.24","kronobergslan_Preem_LesseboStorgatan_56a__etanol": "19.24","kronobergslan_Preem_VaxjoRadjursvagen__etanol": "19.24","kronobergslan_OKQ8_VaxjoStora_Vagen_6__etanol": "19.24","kronobergslan_Tanka_TingsrydStorgatan_113__etanol": "19.24","kronobergslan_Preem_VaxjoHammerdalsvagen_3__etanol": "19.24","kronobergslan_Tanka_AlvestaBladingevagen_20__diesel": "24.57","kronobergslan_OKQ8_LjungbyHelsingborgsvagen__diesel": "24.57","kronobergslan_Tanka_LjungbyNyponvagen_7__diesel": "24.57","kronobergslan_OKQ8_LesseboStorgatan_60__diesel": "24.57","kronobergslan_Ingo_VaxjoSoderleden_2__diesel": "24.53","kronobergslan_St1_VaxjoVingavagen_1__diesel": "24.47","kronobergslan_St1_VaxjoMorners_Vag_2__diesel": "24.47","kronobergslan_Ingo_LjungbyHarabergsgatan__diesel": "24.47","kronobergslan_St1_LjungbyMarta_Ljungbergsvagen_56__diesel": "24.47","kronobergslan_St1_MarkarydDrottninggatan_50__diesel": "24.47","kronobergslan_dinX_TingsrydSodra_vagen_19_urshult__diesel": "24.46","kronobergslan_OKQ8_VaxjoStora_Vagen_6__diesel": "24.45","kronobergslan_Preem_VaxjoOstregardsgatan_51__diesel": "24.13","kronobergslan_Smart_Energy_LesseboSkruv_Lagervagen_1__diesel": "23.83","kronobergslan_Ingo_VaxjoSmedjegatan_28__Morners_vag__diesel": "100.00","kronobergslan_Tanka_VaxjoLjungadalsgatan_1__diesel": "52.39","kronobergslan_Circle_K_VaxjoSodra_Vallviksvagen_352_51_Vaxjo__diesel": "29.12",

var_dump($json_data)

array(141) { ["kronobergslan_Ingo_VaxjoSmedjegatan_28__Morners_vag__biodiesel"]=> string(5) "34.23" ["kronobergslan_OKQ8_VaxjoStora_Vagen_6__biodiesel"]=> string(5) "10.04" ["kronobergslan_OKQ8_VaxjoArabygatan_53__etanol"]=> string(5) "19.24" ["kronobergslan_Tanka_MarkarydHassleholmsvagen_2__etanol"]=> string(5) "19.24" ["kronobergslan_Preem_VaxjoOstregardsgatan_51__etanol"]=> string(5) "19.24" ["kronobergslan_OKQ8_MarkarydGlasbruksvagen_15_Stromsnasbruk__etanol"]=> string(5) "19.24" ["kronobergslan_Tanka_AlvestaBladingevagen_20__etanol"]=> string(5) "19.24" ["kronobergslan_OKQ8_LjungbyHelsingborgsvagen__etanol"]=> string(5) "19.24"

I’m trying to build a table with name "kronobergslan_Ingo_VaxjoSmedjegatan_28__Morners_vag__biodiesel" and value "34.23"

>Solution :

Welcome to Stack Overflow community.
First of all, you are looping through values only. You need to slightly modify your foreach loop to include keys. Here is how you do it:

<?php

$url = "https://www.henrikhjelm.se/api/getdata.php?lan=kronobergs-lan";
$json = file_get_contents($url);
$entries = json_decode($json, true);

foreach ($entries as $key => $value) {
    echo("key: $key<br>");
    echo("value: $value<br>");
    echo("<br>");
}

The output is the following:

key: kronobergslan_Ingo_VaxjoSmedjegatan_28__Morners_vag__biodiesel
value: 34.23

key: kronobergslan_OKQ8_VaxjoStora_Vagen_6__biodiesel
value: 10.04

key: kronobergslan_OKQ8_VaxjoArabygatan_53__etanol
value: 19.24

I hope this is the desired result. Let me know if you have any questions left.

Add a comment

Leave a Reply

Keep Up to Date with the Most Important News

By pressing the Subscribe button, you confirm that you have read and are agreeing to our Privacy Policy and Terms of Use

Discover more from Dev solutions

Subscribe now to keep reading and get access to the full archive.

Continue reading