How to remove html element from string based on child value using php?

Question

There's a html table assigned to a variable $text. (The table can have different number of rows)

What would be the easiest way to get rid of the rows that do not have a value in column 2 (in this example it would be row 2)

Example:

$text = <<<EOT
<table style="width: 430px;">
<tbody>
<tr>
<td style="width: 199px;"><b>Row 1:</b></b></td>
<td style="width: 413px;">6754</td>
</tr>
<tr>
<td style="width: 199px;"><b>Row 2:</b></td>
<td style="width: 413px;"></td>
</tr>
<tr>
<td style="width: 199px;"><b>Row 3</b></td>
<td style="width: 413px;">7567</td>
</tr>
</tbody>
</table>

EOT;

Expected result:

$text = <<<EOT

<table style="width: 430px;">
<tbody>
<tr>
<td style="width: 199px;"><b>Row 1:</b></b></td>
<td style="width: 413px;">6754</td>
</tr>
<tr>
<td style="width: 199px;"><b>Row 3</b></td>
<td style="width: 413px;">7567</td>
</tr>
</tbody>
</table>

EOT;

Also you can use `$xpath->query("//tr[td[2]='']")` to selecting `tr` that second `td` of it is empty — Mohammad, Sep 24 '18 at 11:17

score 0 · Answer 1 · answered Sep 24 '18 at 11:25

I think using DOMXPath is best way to removing target elements from your html. Using xpath you can select trs that seconds td of it is empty.

$doc = new DOMDocument();
$doc->loadHTML($text);
$xpath = new DOMXPath($doc);
$row = $xpath->query("//tr[td[2]='']")->item(0);
$row->parentNode->removeChild($row);
$newText = $doc->saveHTML();

Check it in demo

How to remove html element from string based on child value using php?

1 Answers1