Retrieve data from html page using xpath and php

Question

I know there are similar question, but, trying to study PHP I met this error and I want understand why this occurs.

<?php
    $url = 'http://aice.anie.it/quotazione-lme-rame/';
    echo "hello!\r\n";
    $html = new DOMDocument();
    @$html->loadHTML($url);
    $xpath = new DOMXPath($html);
    $nodelist = $xpath->query(".//*[@id='table33']/tbody/tr[2]/td[3]/b");

    foreach ($nodelist as $n) {
        echo $n->nodeValue . "\n";
    }
?>

this prints just "hello!". I want to print the value extracted with the xpath, but the last echo doesn't do anything.

On the provided URL no id with table33 can be found..

Mark Veenstra
– Mark Veenstra

2014-07-07 09:12:06 +00:00
Commented Jul 7, 2014 at 9:12 — Mark Veenstra
– Mark Veenstra, Commented Jul 7, 2014 at 9:12

Erxyon · Accepted Answer · 2014-07-07 09:34:38Z

You have some errors in your code :

You try to get the table from the url http://aice.anie.it/quotazione-lme-rame/, but it's actually in an iframe located at http://www.aiceweb.it/it/frame_rame.asp, so get the iframe url directly.
You use the function loadHTML(), which load an HTML string. What you need is the loadHTMLFile function, which takes the link of an HTML document as a parameter (See http://www.php.net/manual/fr/domdocument.loadhtmlfile.php)
You assume there is a tbody element on the page but there is no one. So remove that from your query filter.

Working code :

$url = 'http://www.aiceweb.it/it/frame_rame.asp';
echo "hello!\r\n";
$html = new DOMDocument();
@$html->loadHTMLFile($url);
$xpath = new DOMXPath($html);
$nodelist = $xpath->query(".//*[@id='table33']/tr[2]/td[3]/b");

foreach ($nodelist as $n) {
    echo $n->nodeValue . "\n";
}

Collectives™ on Stack Overflow

Retrieve data from html page using xpath and php

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related