Problems with file_get_contents and Domdocument

Question

I’m trying to download the content of a site, but is giving this Warning:

`Domdocument::loadHTML(): Unexpected end tag : tr in Entity

And it’s spelling out several lines. I’m also not getting the accent fixed.

Someone could help me understand and solve these problems?

$content = http_build_query([
    'Local' => 'Adamantina',
    'Inicio' => '01/01/2015',
    'Final' => '31/12/2015',
]);

$context = stream_context_create([
    'http' => [
        'method'  => 'POST',
        'header'  => 'Content-type: application/x-www-form-urlencoded',
        'content' => $content,
    ]
]);

$contents = utf8_decode(file_get_contents('http://www.ciiagro.sp.gov.br/ciiagroonline/Listagens/BH/LBalancoHidricoLocal.asp', false, $context));

$dom = new DOMDocument();
$dom->loadHTML($contents);
$dom->saveHTML($dom->documentElement);

$xpath = new DomXPath($dom);
$rows = $xpath->query('//table/tr[position()>0]');

foreach ($rows as $row) {
    $tds=$row->getElementsByTagName("td");   

    foreach ($tds as $td) {
        print($td->nodeValue);
        echo "<br>";
    }
}

Answer 1

Warning problem:

To fix the problem of Warning you must use the libxml_use_internal_errors(), in fact it will only hide the mistakes of libxml.

Use the following:

libxml_use_internal_errors(true);

Source: http://php.net/manual/en/function.libxml-use-internal-errors.php

Accent problem:

To fix the coding problem use the mb_convert_encoding(), this will convert to HTML, but remove the utf8_decode() previous!

Use the following:

mb_convert_encoding($td->nodeValue, 'HTML-ENTITIES', 'UTF-8');

Source: http://php.net/manual/en/function.mb-convert-encoding.php

Change to something similar to this:

$contents = file_get_contents('http://www.ciiagro.sp.gov.br/ciiagroonline/Listagens/BH/LBalancoHidricoLocal.asp', false, $context);

Removing the utf8_decode().

Note:

1. The easiest way to know when to use HTML-ENTITIES, for me, is to know which presents the ? instead of <?> (with black background) or some combinations of "random" characters. Of course, this is just for me, that I keep kicking until it works.

2. I think it’s best to use cURL instead of file_get_contents(),

I’m out of time, sorry, I’ll try to improve the answer soon.