Sample Page

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