Parsing information from HTML table PHP?

Question

I am trying to parse a table from a website. Which is like :

Desired result I want is something like that :

How to achieve it.

Table is made up of simple <tr> <td> tags and used rowspan and colspan for spacing.

How to achieve it in PHP or JS?

Answer 1

in PHP, use DOMDocument.

foreach((@DOMDocument::loadHTML($html))->getElementsByTagName("tr") as $tr){
    foreach($tr->getElementsByTagName("td") as $td){
        var_dump($td->textContent);
    }    
}

in Javascript, use DOMParser.

var doc=(new DOMParser()).parseFromString(html,"text/html");
var all=doc.querySelectorAll("tr > td");
for(var i=0;i<all.length;++i){
    console.log(all[i].textContent);
}