regex php find data in a table

Question

I am trying to get the total yearly value of solar irradiation and other values from a table I get with curl from European pv_gis.

The table I get is:


  Jan 2.27 70.3 2.86 88.5
  Feb 2.79 78.0 3.56 99.7
  Mar 3.59 111 4.74 147
  Apr 4.23 127 5.68 171
  May 4.46 138 6.13 190
  Jun 4.53 136 6.38 191
  Jul 4.74 147 6.70 208
  Aug 4.59 142 6.53 202
  Sep 4.32 130 5.96 179
  Oct 3.63 113 4.87 151
  Nov 2.64 79.1 3.41 102
  Dec 2.15 66.5 2.72 84.3
 
 Yearly average 3.67 111 4.97 151 
Total for year   1340     1810

As you can see, the Total values are contained in the last tag of that table. Specifically, the total yearly value is in the second tag.

Now, I have tried to use txt2reg tools to build a regular expression, but with success, as I don't know how to target the last row of the above mentioned table.

I get infinite string of numbers, by deleting all TR and TD, but at that point, numbers get confused.

Do you guys have some suggestions?

Thank you very much.

EDIT

I did the following, but I get an error. The error is:

Catchable fatal error: Argument 1 passed to DOMXPath::__construct() must be an instance of DOMDocument, instance of DOMElement given in C:\Users	est\www2	est_pvgis.php on line 49

And the code is:

$doc = new DOMDocument();
libxml_use_internal_errors(true);
$doc->loadHTML($varResponse);

$table = $doc->getElementsByTagName('table')->item(1); 

print_r($table);


$xpath = new DOMXpath($table);

$lastRow = $xpath->query("(//tr)[last()]");

// look for td elements inside the last row we isolated above
// path for td elements is relative
$cells = $xpath->query('./td',$lastRow[0]);

// you can also store the values for later use
foreach($cells as $key=>$cell){
    //we are ignoring the first key, since it holds the "Total for year" bit

    if ($key != 0){
        $store[] = trim($cell->nodeValue); // trim out the leading and trailing spaces
    }
}
print_r($store);

The error is located here: $xpath = new DOMXpath($table); but I have to idea why. Any clue?

Alex Andrei · Accepted Answer

Edit

Assuming you have more tables and the first one is the relevant one.
You need to pass a DOMDocument instance to the DOMXpath constructor.
So you will use the $doc for $xpath = new DOMXpath($doc);
And when you query for the last row, you pass as second parameter the $table element

Here's an example using DOMDocument and DOMXpath

// start edit
$doc = new DOMDocument();
libxml_use_internal_errors(true);
$doc->loadHTML($varResponse);

$table = $doc->getElementsByTagName('table')->item(1); 

print_r($table);

$xpath = new DOMXpath($doc);

$lastRow = $xpath->query("(./tr)[last()]",$table);
// end edit

// look for td elements inside the last row we isolated above
// path for td elements is relative
$cells = $xpath->query('./td',$lastRow->item(0)); // fixed 'Cannot use object of type DOMNodeList as array i'

// you can also store the values for later use
foreach($cells as $key=>$cell){
    //we are ignoring the first key, since it holds the "Total for year" bit

    if ($key != 0){
        $store[] = trim($cell->nodeValue); // trim out the leading and trailing spaces
    }
}
print_r($store);
/*
ouputs
Array
(
    [0] => 1340
    [1] => 1810
)
*/

regex php find data in a table

Answers (1)

Related Questions