无法从数据库加载数据

由 发布于

我有一个API，并且正在逐步学习其功能。由于经验不足，我无法从数据库加载数据。当我尝试加载数据时，它给我一个错误。这是我到目前为止的代码。据我了解，问题是计数行，但无法解决。

$rows = $db->Query("SELECT * FROM sma_all"); 
$rows = $rows->GetRows();
echo "<Grid><Body><B Pos='" . $B["Pos"] . "'>";
$cnt = count($rows);
if($cnt>$start+21) $cnt = $start+21;
for($i=$start;$i<$cnt;$i++) { 
    $row = $rows[$i];
    foreach($rows as $row) {
        if($row["Parent"]==0) 
            echo " <I Level='0' Def='Node' id='" .$row["grid_id"]. "'"
             . " document_type='" .$row["document_type"]."'"
             . " document_type_abbrevation='" . $row["document_type_abbrevation"] . "'"
             . " posting_date='" . $row["posting_date"] . "'"
             . " date='" . $row["date"] . "'"
             . " warehouse='" . $row["warehouse"] . "'"
             . " wcode='" . $row["wcode"] . "'"
             . " nips='" . $row["nips"] . "'"
             . " company='" . $row["company"] . "'"
             . " />";
        else 
            echo" <I Level='1' Def='Data' id='" .$row["grid_id"]. "'"
                 . " nw='" .$row["nw"] . "'"
                 . " nwc='" . $row["nwc"] . "'"
                 . " worktime='" . $row["worktime"] . "'"
                 . " workday='" . $row["workday"] . "'"
                 . " pbr='" . $row["pbr"] . "'"
                 . " />";
    }
    echo "</B></Body></Grid>";
?>