DOMDocument 无法从数据库中获取我的所有记录


DOMDocument can't get all of my records from database

<?php
ini_set('display_errors', 1);
error_reporting(E_ALL);
require_once ('../includes/connect.php');
try {
    $filter = $db->query("SELECT * FROM table");
    $check = $filter->rowCount();
    echo $check.'<br />';
    for($i = 1; $i < $check+1; $i++){
        $c = $filter->fetch();
        //echo $c['ID'];
        $source = file_get_contents($c['pURLMorele']);
        $dom = new DOMDocument();
        @$dom->loadHTML($source);
        $xpath = new DOMXPath($dom);
        $rows = $xpath->query("//span[@class='price']");
        print_r($rows->item(0)->textContent);
    }
}
catch (PDOException $e) {
    echo 'Something went wrong!<br>'.$e->getMessage();
    die();
}
?>

在我的数据库中有 4 条记录,但我不知道为什么它只显示其中的 3 条(2、3 、4(。1在哪里?!

这是我的输出:

4
Notice: Trying to get property of non-object in /var/www/vhosts/20/147910/webspace/httpdocs/serwer151299580.twojeaz.pl/functions/pricesUpdate.php on line 19
515,00 zł 269,00 zł 1589,00 zł

您可以尝试更改:

for($i = 1; $i < $check+1; $i++){
    $c = $filter->fetch();

while($c = $filter->fetch()){

这样,您就不会超出资源的边界。