pasing a html file and getting values from table using php?

Question

I have this long list of courses on a html page done in tables i.e.

<tr class="navyLightgrey">
<td>3ADC7S1</td><td>SOFTWARE PROJECT MANAGEMENT (IIT Sri Lanka)</td><td align="Center">2009/0</td><td align="Center">Y</td><td align="Center">

<a id="dgModules__ctl2_lnkModule" href="http://example.com">View</a>

             </td>

            </tr>

<tr class="navyLightgrey">
<td>3ADC7S2</td><td>SOFTWARE ARCHITECTURE (IIT Sri Lanka)</td><td align="Center">2009/0</td><td align="Center">Y</td><td align="Center">

<a id="dgModules__ctl3_lnkModule" href="http://example.com" target="_self">View</a>

           </td>

             </tr>

It's done in this format. I want to get the value of the second td where it says the course name i.e. SOFTWARE ARCHITECTURE (IIT Sri Lanka) and SOFTWARE PROJECT MANAGEMENT (IIT Sri Lanka) for each tr item. I want to do a while loop through the html page and get each value and echo it. Thanks

Doesn't the site you're stealing data from have an RSS feed that you can interface with, rather than scraping HTML? — Lightness Races in Orbit, Mar 31 '11 at 09:59
*(related)* [Best Methods to parse HTML](http://stackoverflow.com/questions/3577641/best-methods-to-parse-html/3577662#3577662) — Gordon, Mar 31 '11 at 10:14

score 2 · Accepted Answer · answered Mar 31 '11 at 10:09

2

$html = 'your html';
$dom = new DOMDocument();
$dom->loadHTML($html); // or loadHTMLFile

$xpath = new DOMXPath($dom);
$arrNodes = $xpath->query('//tr/td[2]/text()');

foreach($arrNodes as $node)
    echo $node->nodeValue . '<br />';

answered Mar 31 '11 at 10:09

johnlemon

20,761
42
119
178

score 1 · Answer 2 · answered Mar 31 '11 at 09:59

1

Use DOMDocument::loadHTML, then search for the correct element within the DOMDocument.

answered Mar 31 '11 at 09:59

Sjoerd

74,049
16
131
175

score 1 · Answer 3 · answered Mar 31 '11 at 10:00

1

That is done with "HTML DOM Parser". You can use, for example this one.

answered Mar 31 '11 at 10:00

Deele

3,728
2
33
51

thanks for this, when i find the in the html page, how can i tell it to access the second ? :)) +! from me – pingpong Mar 31 '11 at 10:02
for that is "foreach" loop, it will loop through all matched elements. If you want to access "next TR after TR, where is some identifying stuff", you should add some "if matched, set variable found=1" and add in loop "if found = 1 then this is ne one TR I need". – Deele Mar 31 '11 at 10:05

pasing a html file and getting values from table using php?

3 Answers3