Extract table data from HTML page in php

Question

I have a html table with multiple rows and each row with multiple columns. A Sample for one row looks like this.

<table class ="classt">
    <tbody>
        <tr class="row">
            <td height="20" valign="top" class="mosttext-new">data</td>
            <td height="20" valign="top" class="mosttext-new"> data</td>
            <td height="20" valign="top" class="mosttext-new">data</td> 
        </tr>
    </tbody>
</table>

I am trying to extract all td elements like this in a php script.

foreach($html->find('table.classt') as $e){
         foreach ($e->find('tr.row') as $tr){
            foreach ($tr->find('td') as $td){
                    $text = $td->innertext;
            }
        }
    }

But in $tr I am not getting row details with td tags. It is just coming the entire row withing double quotes like this

"data data data"

so my third loop is not able to find td as $tr does not have td tags.

Any idea on this?

saravanan · Accepted Answer · 2018-03-17 12:43:57Z

5

I think you have to mention the class name after the 'td' followed by '.' like this

 foreach ($tr->find('td.mosttext-new') as $td)

Hope this should solve your problem. All the best.

answered Mar 17, 2018 at 12:43

saravanan

512 bronze badges

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

1 Comment

saravanan Over a year ago

so my third loop is not able to find td as $tr does not have td tags. From this line what you actually asking? Could not understand what really is your issue. Can you update what output you are expecting?. I tried with your code it's working fine. Update your question then i will answer furtherly.

Collectives™ on Stack Overflow

Extract table data from HTML page in php

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related