Html dom parser php table

Question

Here is my Table

Grapes    1     25     25
Mangoes   2     30     60
Apple     5     10     50

And my Html code for the above table is

<table>
<tr>
<td><font>Grapes</font></td>
<td><font>1</font></td>
<td><font>25</font></td>
<td><font>25</font></td>
</tr>
<tr>
<td><font>Mangoes</font></td>
<td><font>2</font></td>
<td><font>30</font></td>
<td><font>60</font></td>
</tr>
<tr>
<td><font>Apple</font></td>
<td><font>5</font></td>
<td><font>10</font></td>
<td><font>50</font></td>
</tr>
</table>

the above table is 4th table in my html code

my php code is

<?php
include('simple_html_dom.php');
$result = curl_exec($ch);
curl_close($ch);
$src = new DOMDocument('1.0', 'utf-8');
$src->formatOutput = true;
$src->preserveWhiteSpace = false;
@$src->loadHTML($result);
$xpath = new DOMXPath($src);
$values=$xpath->query('//table[4]//tr');

foreach($values as $value)
{
$rowdata = str_replace(">"," ",$value->nodeValue);
$n = explode("\n", $rowdata);
print_r($n);
}

Here $result holds the html code coming from curl execution

and my output is

Array ( [0] => Grapes12525 [1] => ) Array ( [0] => Mangoes23060 [1] => ) Array ( [0] => Apple51050 [1] => )

But i want output as

Array ( [0] => Grapes [1] => 1 [2] => 25 [3] => 25 ) Array ( [0] => Mangoes [1] => 2 [2] => 30 [3] => 60 ) Array ( [0] => Apple [1] => 5 [2] => 10 [3] => 50 )

i have tried with

$values=$xpath->query('//table[4]//tr//td');

but this is printing each value as array

is there any method where we can get the child elements inside for loop for example only td's inside parent tr or any other way to achieve this

Please help me in getting this

Thank you

stackoverflow.com/a/11968441/123415

jcuenod
– jcuenod

2015-06-10 08:21:54 +00:00
Commented Jun 10, 2015 at 8:21 — jcuenod
– jcuenod, Commented Jun 10, 2015 at 8:21

venca · Accepted Answer · 2015-06-10 08:18:14Z

0

I would try:

$rowdata = explode(' ', $value->textContent);

Text content should be whole texts of tr children separated by space.

If this would not working. Do another xpath query in foreach loop with //td and $value as context node.

answered Jun 10, 2015 at 8:18

venca

1,2206 silver badges18 bronze badges

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

Collectives™ on Stack Overflow

Html dom parser php table

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related