Parse HTML table with PHP [duplicate]

Question

I have been trying to parse the bottom table on this site using different tools.

So far I have had the greatest success using the Simple HTML Dom library, but I still cannot figure out how to parse only that last table.

So far my code is something along the lines of:

<?php

require('simple_html_dom.php');

$table = array();

$html = file_get_html('http://www.waterlevels.gc.ca/cgi-bin/tide-shc.cgi?zone=20&region=1&   language=english&station=9635&queryType=predict&year=2012&month=2&day=9&view=table&TZ=PST');

foreach($html->find('tr') as $row) 
{
//confused as what to do there to parse only last table in given URL
}

echo '<pre>';
print_r($table);
echo '</pre>';

?>

If someone has any suggestiong as how to get the library to only parse the last table it would be greatly appreciated.

Thanks

Justin ᚅᚔᚈᚄᚒᚔ · Accepted Answer · 2012-03-27 22:40:47Z

3

You can use a negative number in the find() call to get a specific element. This should get you the second-to-last table, which contains all of the data:

$table = $html->find('table',-2);
foreach($table->find('tr') as $row)
{
  // Process each row
}

answered Mar 27, 2012 at 22:40

Justin ᚅᚔᚈᚄᚒᚔ

15.4k8 gold badges55 silver badges64 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Paul Dessert · Accepted Answer · 2012-03-27 22:42:22Z

0

You should be able to use something like this:

$ret = $html->find('tr', 0);

Just replace 0 with the correct #

answered Mar 27, 2012 at 22:42

Paul Dessert

6,3879 gold badges50 silver badges74 bronze badges

Collectives™ on Stack Overflow

Parse HTML table with PHP [duplicate]

2 Answers 2

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Linked

Related