Array ( [GetTickerJSONResult] => Array ( [0] => Array ( [AvgAbsChange] => -41.23 [AvgPerChange] => -0.23 [AvgPrice] => 17902.5 [Description] => Алкалоид Скопје [Symbol] => ALK [TierCode] => BKO ) [1] => Array ( [AvgAbsChange] => -112.72 [AvgPerChange] => -0.95 [AvgPrice] => 11695.51 [Description] => Комерцијална банка Скопје [Symbol] => KMB [TierCode] => SKO ) [2] => Array ( [AvgAbsChange] => -1099 [AvgPerChange] => -1.59 [AvgPrice] => 68001 [Description] => Макпетрол Скопје [Symbol] => MPT [TierCode] => BKO ) [3] => Array ( [AvgAbsChange] => 0 [AvgPerChange] => 0 [AvgPrice] => 607 [Description] => МЗТ Пумпи Скопје [Symbol] => MZPU [TierCode] => ZKO ) [4] => Array ( [AvgAbsChange] => 0 [AvgPerChange] => 0 [AvgPrice] => 2400 [Description] => Стопанска банка Битола [Symbol] => SBT [TierCode] => BKO ) [5] => Array ( [AvgAbsChange] => -27.01 [AvgPerChange] => -2.08 [AvgPrice] => 1271.53 [Description] => Стопанска банка Скопје [Symbol] => STB [TierCode] => ZKO ) [6] => Array ( [AvgAbsChange] => 0 [AvgPerChange] => 0 [AvgPrice] => 395 [Description] => Македонски Телеком Скопје [Symbol] => TEL [TierCode] => ZKO ) [7] => Array ( [AvgAbsChange] => 77 [AvgPerChange] => 2.51 [AvgPrice] => 3150 [Description] => Тетекс Тетово [Symbol] => TETE [TierCode] => BKO ) [8] => Array ( [AvgAbsChange] => 161.58 [AvgPerChange] => 0.56 [AvgPrice] => 28961.58 [Description] => НЛБ Банка АД Скопје [Symbol] => TNB [TierCode] => ZKO ) [9] => Array ( [AvgAbsChange] => 11 [AvgPerChange] => 0.83 [AvgPrice] => 1340 [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);