looping through xpath results

Question

I have gone to the db and created an array of url's.
Then I go through the array and use xpath to tell me how many links there are per url.
This is where my head hurts.

I have a count for each url of the no of objects in each url. So I'm now trying to collect each of the nodevalues from part 2.

I'm obviously doing something wrong but need some guidence please

 $items = array(); $query = "SELECT * FROM `urls`"; if( $result = mysqli_query($sql,$query)); { // Return the number of rows in result set $rowcount=mysqli_num_rows($result); while ($row = $result->fetch_assoc()) { $items[] = $row; } } echo '<pre>'; print_r($items); // $product = array(); echo $rowcount; for ($x=0; $x<$rowcount; $x++){ $scrapeurl[$x] = $items[$x][url]; echo $scrapeurl[$x]; $xpath[$x] = new XPATH($scrapeurl[$x]); $urls[$x] = $xpath[$x]->query("//div[@class='infodata']/strong/a[contains(@id,'test_title')]/@href"); $count[$x] = $urls[$x]->length; $data = array(); for ($i=0; $i<$count[$x]; $i++){ $data[$i]['url'] = $urls[$x]->item($i)->nodeValue; $data[] = $data[$i]['url']; } echo '<pre>'; print_r($data);

Can you post the output of this script, please, so that we can see the content of $items? — t.h3ads
– t.h3ads, Commented Jul 28, 2015 at 13:07

Community · Accepted Answer · 2017-05-23 12:30:12Z

A bit late apologies but resolved the issue. Maybe too tired but came down to a couple of issues.

Don't always believe what the browser renders in the HTML. Look at the source! I found that tbody as an example is filled into HTML by Firefox at least in reality the source was different so I was never going to hit the right node.

looping within loops - to remember when in a loop sometimes you have to loop again to drill down to the right result......

$data = array(); foreach($urls as $node){ foreach($node->childNodes as $child) { $data[] = array($child->nodeName => $child->nodeValue); } } $data = new RecursiveIteratorIterator(new RecursiveArrayIterator($data)); $data = iterator_to_array($data,false);

Collectives™ on Stack Overflow

looping through xpath results

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related