Sample Page

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);