Array ( [GetTickerJSONResult] => Array ( [0] => Array ( [AvgAbsChange] => 52.61 [AvgPerChange] => 0.29 [AvgPrice] => 18245.81 [Description] => Алкалоид Скопје [Symbol] => ALK [TierCode] => BKO ) [1] => Array ( [AvgAbsChange] => 0 [AvgPerChange] => 0 [AvgPrice] => 310 [Description] => Градинар Охрид [Symbol] => GRDN [TierCode] => 3AO ) [2] => Array ( [AvgAbsChange] => 34 [AvgPerChange] => 1.25 [AvgPrice] => 2750 [Description] => Шпаркасе банка Македонија АД Скопје [Symbol] => INB [TierCode] => JPDOA ) [3] => Array ( [AvgAbsChange] => 82.13 [AvgPerChange] => 0.58 [AvgPrice] => 14344.9 [Description] => Комерцијална банка Скопје [Symbol] => KMB [TierCode] => SKO ) [4] => Array ( [AvgAbsChange] => -610.15 [AvgPerChange] => -0.94 [AvgPrice] => 63966.77 [Description] => Макпетрол Скопје [Symbol] => MPT [TierCode] => BKO ) [5] => Array ( [AvgAbsChange] => 1750 [AvgPerChange] => 2.03 [AvgPrice] => 88000 [Description] => Реплек Скопје [Symbol] => REPL [TierCode] => BKO ) [6] => Array ( [AvgAbsChange] => -2.5 [AvgPerChange] => -2.67 [AvgPrice] => 91 [Description] => Р. Македонија - денационализација 22 [Symbol] => RMDEN22 [TierCode] => BKOB ) [7] => Array ( [AvgAbsChange] => 9.61 [AvgPerChange] => 0.74 [AvgPrice] => 1299.96 [Description] => Стопанска банка Скопје [Symbol] => STB [TierCode] => ZKO ) [8] => Array ( [AvgAbsChange] => -1.08 [AvgPerChange] => -0.28 [AvgPrice] => 381.78 [Description] => Македонски Телеком Скопје [Symbol] => TEL [TierCode] => ZKO ) [9] => Array ( [AvgAbsChange] => 184.95 [AvgPerChange] => 0.64 [AvgPrice] => 29209.52 [Description] => НЛБ Банка АД Скопје [Symbol] => TNB [TierCode] => ZKO ) [10] => Array ( [AvgAbsChange] => 7.75 [AvgPerChange] => 0.56 [AvgPrice] => 1387.08 [Description] => ТТК Банка АД Скопје [Symbol] => TTK [TierCode] => BKO ) ) )
// Retrieve JSON data
$json_data = file_get_contents(‘http://feeds.mse.mk/service/FreeMSEFeeds.svc/ticker/JSON/59c389c6-416d-4aeb-9f03-cc7a38b16533’);
$data = json_decode($json_data, true);
// Extract values from JSON data
$values = array();
foreach ($data as $item) {
$values[] = array(
‘AvgAbsChange’ => $item[‘AvgAbsChange’],
‘AvgPerChange’ => $item[‘AvgPerChange’],
‘Description’ => $item[‘Description’]
‘Symbol’ => $item[‘Symbol’]
‘TierCode’ => $item[‘TierCode’]
);
}
// Insert values into table
$table_name = ‘my_table’;
wp_table_insert($table_name, $values);
// Display table on website
echo wp_table_manager($table_name);