Changeset 39498 for trunk/ippMonitor/raw/czartool_labels.php

Timestamp:

Mar 31, 2016, 6:26:07 AM (10 years ago)

Author:

eugene

Message:

fix MDB2 DBI methods; avoid php warnings by putting quotes around hash arguments; check for hash element existence before using; simplify code with get_htmlkey_value function

File:

• trunk/ippMonitor/raw/czartool_labels.php (modified) (10 diffs)

trunk/ippMonitor/raw/czartool_labels.php

@@ -313 +313 @@
 
     // list the results
-    while ($qry->fetchInto($row)) {
+    while (dbFetchInto($qry, $row)) {
 
         echo "<tr>";
@@ -358 +358 @@
 
     // list the results
-    while ($qry->fetchInto($expType)) {
+    while (dbFetchInto($qry, $expType)) {
 
         $sql = "SELECT COUNT(*) FROM summitExp WHERE dateobs > '$date' AND exp_type = '$expType[0]'";
         $qry2 = $projectdb->query($sql);
-        $qry2->fetchInto($summit);
+      dbFetchInto($qry2, $summit);
         $sql = "SELECT COUNT(*) FROM summitExp JOIN rawExp ON summitExp.exp_name = rawExp.exp_name WHERE summitExp.dateobs > '$date' AND summitExp.exp_type = '$expType[0]'";
         $qry2 = $projectdb->query($sql);
-        $qry2->fetchInto($mhpcc);
+      dbFetchInto($qry2, $mhpcc);
 
         echo "<tr>";
@@ -397 +397 @@
     $qry = $db->query($sql);
     if (dberror($qry)) {echo "<b>error with $sql </b><br>\n";}
-    while ($qry->fetchInto($row)) {
+    while (dbFetchInto($qry, $row)) {
 
         $labels[] = $row[0];
@@ -621 +621 @@
     $qry = $db->query($sql);
     if (dberror($qry)) {echo "<b>error with $sql </b><br>\n";}
-    $qry->fetchInto($row);
+    dbFetchInto($qry, $row);
 
     return $row[0];
@@ -655 +655 @@
     $qry = $db->query($sql);
     if (dberror($qry)) {echo "<b>error with $sql </b><br>\n";}
-    $qry->fetchInto($row);
+    dbFetchInto($qry, $row);
 
     return $row[0];
@@ -673 +673 @@
     $qry = $db->query($sql);
     if (dberror($qry)) {echo "<b>error with $sql </b><br>\n";}
-    $qry->fetchInto($row);
+    dbFetchInto($qry, $row);
 
     $pending = $row[0];
@@ -730 +730 @@
     $dates = ""; 
     $firstIn = true;
-    while ($qry->fetchInto($row)) {
+    while (dbFetchInto($qry, $row)) {
 
         if ($firstIn) {
@@ -887 +887 @@
     $qry = $db->query($sql);
     if (dberror($qry)) {echo "<b>error with $sql </b><br>\n";}
-    $qry->fetchInto($row);
+    dbFetchInto($qry, $row);
 
     $alive = $row[0];
@@ -906 +906 @@
     $qry = $db->query($sql);
     if (dberror($qry)) {echo "<b>error with $sql </b><br>\n";}
-    $qry->fetchInto($row);
+    dbFetchInto($qry, $row);
 
     return $row[0];
@@ -947 +947 @@
     }
     $res = $dbRepl->query('SHOW SLAVE STATUS');
-    while ($res->fetchInto($row)) {
+    while (dbFetchInto($res, $row)) {
         # Have a look for Last_Errno in http://dev.mysql.com/doc/refman/5.0/en/show-slave-status.html
         $errorStatusInMySql = $row[18];