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
– Lightness Races in Orbit, Commented Mar 31, 2011 at 9:59

johnlemon · Accepted Answer · 2011-03-31 10:09:15Z

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, 2011 at 10:09

johnlemon

21.6k45 gold badges124 silver badges181 bronze badges

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

Comments

Community · Accepted Answer · 2023-11-17 20:08:53Z

1

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

edited Nov 17, 2023 at 20:08

CommunityBot

11 silver badge

answered Mar 31, 2011 at 9:59

Sjoerd

75.9k16 gold badges140 silver badges180 bronze badges

Comments

Deele · Accepted Answer · 2011-03-31 10:00:14Z

1

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

answered Mar 31, 2011 at 10:00

Deele

3,6792 gold badges35 silver badges52 bronze badges

2 Comments

pingpong Over a year ago

thanks for this, when i find the <tr> in the html page, how can i tell it to access the second <td> ? :)) +! from me

Deele Over a year ago

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".

Collectives™ on Stack Overflow

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

3 Answers 3

Comments

Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related