Friday, 20 April 2018

php - How to parse this table and extract data from it?

I have the following table: http://www.nbs.rs/kursnaListaModul/srednjiKurs.faces?lang=lat



It is a currency exchange list and I need to extract some data from it. On left side of the table are currency ID numbers. Would it be possible to extract data from specified rows based on their IDs?



For example, from the table above, I want to extract currencies with IDs 978, 203, and 348.



Output should be:





  • EUR 104,2182

  • CZK 4,2747

  • HUF 38,7919



By looking at similar examples here, I came up with this: http://pastebin.com/hFZs1H7C



I need somehow to detect IDs and the print proper values... I'm noob when it comes to programming and I need your help.




$data = file_get_contents('http://www.nbs.rs/kursnaListaModul/srednjiKurs.faces?lang=lat');

$dom = new domDocument;

@$dom->loadHTML($data);
$dom->preserveWhiteSpace = false;
$tables = $dom->getElementsByTagName('table');

$rows = $tables->item(1)->getElementsByTagName('tr');


foreach ($rows as $row) {
$cols = $row->getElementsByTagName('td');
foreach ($cols as $col) {

echo $col;

}
}


?>

No comments:

Post a Comment

casting - Why wasn't Tobey Maguire in The Amazing Spider-Man? - Movies & TV

In the Spider-Man franchise, Tobey Maguire is an outstanding performer as a Spider-Man and also reprised his role in the sequels Spider-Man...