难以解析网站上的表格内容

Question

I've written a script in PHP to get the tabular data from a webpage. When I execute my script I can get them in a single column. However, I wish to parse them as a list, as in how they look like in that webpage.

Website link

To be clearer:

My current output are like:

978
EMU
EUR
1
118.2078
36
Australija
AUD
1
73.1439

My expected output are like:

['978', 'EMU', 'EUR', '1', '118.2078']
['36', 'Australija', 'AUD', '1', '73.1439']
['124', 'Kanada', 'CAD', '1', '77.7325']
['156', 'Kina', 'CNY', '1', '14.6565']
['191', 'Hrvatska', 'HRK', '1', '15.9097']

This is my try so far:

<?php
$url = "http://www.nbs.rs/kursnaListaModul/srednjiKurs.faces?lang=lat";
$dom = new DomDocument;
$dom->loadHtmlFile($url);
$xpath = new DomXPath($dom);

$rowData = array();
foreach ($xpath->query('//tbody[@id="index:srednjiKursList:tbody_element"]//tr') as $node) {
    foreach ($xpath->query('td', $node) as $cell) {
        $rowData[] = $cell->nodeValue;
    }
}
foreach($rowData as $rows){
    echo $rows . "<br/>";
}
?>

Answer 1

You are adding each element one at a time to the output array, you probably wanted to build up a row at a time and output that...

$rowData = array();
foreach ($xpath->query('//tbody[@id="index:srednjiKursList:tbody_element"]//tr') as $node) {
    $row = array();
    foreach ($xpath->query('td', $node) as $cell) {
        $row[] = $cell->nodeValue;
    }
    $rowData[] = $row;
}
foreach($rowData as $rows){
    print_r($rows);    // Format the data as needed
}