PHP和DB2协同工作

Question

我正在试着做这个脚本：

//Agent D4 OFFLINE events last 24h

        $q_d4_offline_last24h = "select distinct NODE, LASTOCCURRENCE, INPS_CLOSE_TIMESTAMP
                                  from REPORTER.REPORTER_STATUS
                                  where ALERTKEY = 'M_SW_MID_MON_SER_STS_006C_ALL'
                                   and NODEALIAS like '%:D4'
                                   and LASTOCCURRENCE > DATE(CURRENT_DATE -1 DAYS)";


        $DB2_REPORTER_conn = new ldbproxy();
        if(!$DB2_REPORTER_conn->connect_db2("192.168.8.245:50001", "REPORTER", "itmuser", "tivoli")) die ('E:Connessione al DB2 fallita:' . $DB2_REPORTER_conn->errorMsg);
        $connettore = $DB2_REPORTER_conn->query($q_d4_offline_last24h) or die("E:Errore nella query: " . $DB2_REPORTER_conn->errorMsg);


      $rownum = count($DB2_REPORTER_conn->fetch($connettore));


      if($rownum > 0) {

        $prev_node=NULL;


      echo "\n - Eventi di offline relativi ad agent ITCAM for SOA rilevati nelle ultime 24 ore:\n\n";

        while($row = $DB2_REPORTER_conn->fetch($connettore)){



             if ( $row['NODE'] != $prev_node ) {

                echo "\n\t" . $row['NODE'];
                $prev_hostname = $row['NODE'];
             }

              echo "\n\t\tData inizio: " . substr($row['LASTOCCURRENCE'],0,-2);

              if($row['INPS_CLOSE_TIMESTAMP'] == '1970-01-01 01:00:00.0')
                echo "\n\t\tData fine: n/a";

                else
                  echo "\n\t\tData fine: " . substr($row['INPS_CLOSE_TIMESTAMP'],0,-2) . "\n";

        }
      }

我使用的查询通常会得到3行作为结果。我不明白为什么在输出中我只得到最后两行，它总是跳到第一行。

你能帮帮我吗?

Answer 1

这条语句提取第一个结果行，然后不使用它做任何事情。所以它被丢弃了：

$rownum = count($DB2_REPORTER_conn->fetch($connettore));

如果您只处理少量的行，使用fetchall可能会更方便。这将一次获取所有行，因此您可以检查有多少行，然后使用循环来处理它们。

。