XPath Traverse: Moving outside of tbody to the next row

Question

I'm trying to select a row that is after a tbody

My code to scrape the above HTML is below. The issue I have is with finding element 5. I believe it's because that falls outside the /tbody. However, I can't figure out how to access that via $dom->query. You can see my attempted path below, but it is empty.

query('//tbody[@style="page-break-inside: avoid"]') as $key => $tr) {

  $value = $dom->query('tr[1]/td[@id="column2"]', $tr);
  $value = isset($value->item(0)->nodeValue) ? trim($value->item(0)->nodeValue) : "";
  if ($value != "") {

  
    if (!is_numeric($value[0])) {
      $d = array();

      $element_1 = $dom->query('tr[1]/td[@id="column3"]', $tr);
      $element_2 = isset($value2->item(0)->nodeValue) ? trim($value2->item(0)->nodeValue) : "";
      
      //saves elements 1 and two
      $d[] = $element_1 . $element_2;

      //saves element 3
      $element_3 = $dom->query('tr[1]/td[@id="column4"]/a', $tr);
      $element_3 = isset($element_3->item(0)->nodeValue) ? trim($element_3->item(0)->nodeValue) : "";
      $d["element3"] = $element_3;

      //saves element 4
      $element_4 = $dom->query('tr[1]/td[@id="column4"]/a/@href', $tr);
      $element_4 = isset($element_4->item(0)->nodeValue) ? "http://miamibeach.novusagenda.com/agendapublic/" . trim($element_4->item(0)->nodeValue) : "";
      $d["element 4"] = $element_4;

      //saves element 5
      $element_5 = $dom->query('tr[5]/td[@id="column5"]', $tr);
      $element_5 = isset($element_5->item(0)->nodeValue) ? trim($element_5->item(0)->nodeValue) : "";
      $d["element 5"] = $element_5;           

      //enters all the $d array data into the $data array
      $data[] = $d;
    }
  }
}

user_14717238 · Answer

To get all TR from your html source you can try the following XPath query

$xpath = 
  '//tbody[@style="page-break-inside: avoid"]/tr|' .
  '//tbody[@style="page-break-inside: avoid"]/following-sibling::tr';

$rows = $dom->query($xpath);

// ...

//saves element 5
$element_5 = $dom->query('td[@id="column5"]', $rows[4]);
$d["element 5"] = isset($element_5[0]) ? trim($element_5[0]->nodeValue) : '';

which is equivalent to the css selector

tbody[style="page-break-inside: avoid"] > tr,
tbody[style="page-break-inside: avoid"] ~ tr

user_9448090 · Answer

Without getting into the details of the rest of the code, to access - for example - the text node of the 5th child node of the 5th node, the following

$element_5 = $dom->query('(//tr)[5]/td[@id="column5"]/text()');
echo $element_5[0]->nodeValue;

should output

ELEMENT 5

XPath Traverse: Moving outside of tbody to the next row

2 Answers