Calling a JSON file with PHP but cant echo in a way i would like to

Question

I would like to follow prices of stocks im interested in with a very simple php file. For this im trying to call certain data from a jsonld file, but unable to do so. Thats mostly because i cant set the correct order. Here is my php code:

<?

// Get the contents of the JSON file
$strJsonFileContents = file_get_contents("data.jsonld");
$datas = json_decode($strJsonFileContents, True);
//var_dump($datas); // print array

$dataname = $datas->currency[ALGYO];
$dataprice = $datas->currency[ALGYO]->price;
echo $data;

?>

I've called the file, can echo with var_dump.

The Json file can be seen here

What i want to do is to call the currency ALGYO, and its price, then in another table or line call lets say ACSEL and its price and so on. I'll only call some certain elements so a list of all elements is not what im looking for. Could someone show me the way? Thanks in advance.

for those who dont want to follow pastebin link im also leavong a readiable version of json below.

{"@context": "http://schema.org",
"@type": "WebPage",
"name": "BORSA",
"mainEntity": {
"@type": "ItemList",
"name": "BORSA",
"itemListElement": [

{
"@type": "ExchangeRateSpecification",
"currency": "ALGYO",
"currentExchangeRate": {
"@type": "UnitPriceSpecification",
"price": 26.14,
"priceCurrency": "TRY"
}
},

{
"@type": "ExchangeRateSpecification",
"currency": "ARZUM",
"currentExchangeRate": {
"@type": "UnitPriceSpecification",
"price": 24.74,
"priceCurrency": "TRY"
}
},

{
"@type": "ExchangeRateSpecification",
"currency": "ACSEL",
"currentExchangeRate": {
"@type": "UnitPriceSpecification",
"price": 22.9,
"priceCurrency": "TRY"
}
},

{
"@type": "ExchangeRateSpecification",
"currency": "ADANA",
"currentExchangeRate": {
"@type": "UnitPriceSpecification",
"price": 12.19,
"priceCurrency": "TRY"
}
},

{
"@type": "ExchangeRateSpecification",
"currency": "ADBGR",
"currentExchangeRate": {
"@type": "UnitPriceSpecification",
"price": 8.62,
"priceCurrency": "TRY"
}
},

{
"@type": "ExchangeRateSpecification",
"currency": "PAMEL",
"currentExchangeRate": {
"@type": "UnitPriceSpecification",
"price": 22.02,
"priceCurrency": "TRY"
}
}
]
}
}

json_decode($str, true) returns array, not object, so you should do $datas['currency']['ALGYO'] — Justinas
– Justinas, Commented Feb 3, 2021 at 8:39
When i do that nothing shows up, also i want to call price of ALGYO, how can i call it? Thank you. — alkinkasap
– alkinkasap, Commented Feb 3, 2021 at 8:43

berend · Accepted Answer · 2021-02-03 09:01:29Z

0

You could use a function, which allows you to get 'item'(stock) specific data from the json.

You can(should) tailor the function to fit your needs, here's an example that searches for an item and returns its price:

$json = file_get_contents('data.json');
$arr = json_decode($json, true);

getItem($arr, 'ALGYO'); // item : ALGYO price: 26.14
getItem($arr, 'ACSEL'); // item : ACSEL price: 22.9

function getItem($arr, $item)
{
    $records = $arr['mainEntity']['itemListElement']; // the records
    foreach ($records as $record) {
        if ($record['currency'] == $item) {
            echo 'item : ' . $item;
            echo '<br />';
            echo 'price : ' . $record['currentExchangeRate']['price'];
            echo '<br />';
        }
    }
}

answered Feb 3, 2021 at 9:01

berend

6414 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Nigel Ren Over a year ago

It will also process the whole list of items each time you want 1 item.

Nigel Ren · Accepted Answer · 2021-02-03 08:47:11Z

Although you say you don't want a list of all elements is not what im looking for, if you want to pick out specific ones in your own order it may be easier.

This just extracts the currentExchangeRate sub-array and indexes it by the currency...

$rates = array_column($datas['mainEntity']["itemListElement"],
         "currentExchangeRate", "currency");

echo "ALGYO rate=" . $rates['ALGYO']['price'];
print_r($rates);

gives...

ALGYO rate=26.14
Array
(
    [ALGYO] => Array
        (
            [@type] => UnitPriceSpecification
            [price] => 26.14
            [priceCurrency] => TRY
        )

    [ARZUM] => Array
        (
            [@type] => UnitPriceSpecification
            [price] => 24.74
            [priceCurrency] => TRY
        )

    [ACSEL] => Array
        (
            [@type] => UnitPriceSpecification
            [price] => 22.9
            [priceCurrency] => TRY
        )

    [ADANA] => Array
        (
            [@type] => UnitPriceSpecification
            [price] => 12.19
            [priceCurrency] => TRY
        )

    [ADBGR] => Array
        (
            [@type] => UnitPriceSpecification
            [price] => 8.62
            [priceCurrency] => TRY
        )

    [PAMEL] => Array
        (
            [@type] => UnitPriceSpecification
            [price] => 22.02
            [priceCurrency] => TRY
        )

)

Collectives™ on Stack Overflow

Calling a JSON file with PHP but cant echo in a way i would like to

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related