Changeset 39498 for trunk/ippMonitor/raw/czartool_exposures.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_exposures.php (modified) (13 diffs)

trunk/ippMonitor/raw/czartool_exposures.php

@@ -74 +74 @@
 
     $qry = $db->query($sql);
-    $qry->fetchInto($count);
+  dbFetchInto($qry, $count);
 
     if ($surveyStr == "") $surveyText = "all surveys";
@@ -154 +154 @@
 
     // loop through results in order to make html table
-    while ($qry->fetchInto($row)) {
+    while (dbFetchInto($qry, $row)) {
 
         $exp_id = $row[0];
@@ -257 +257 @@
     if (dberror($qry)) {echo "<b>error with $sql </b><br>\n";}
 
-    while ($qry->fetchInto($row)) {
+    while (dbFetchInto($qry, $row)) {
 
         if ($row[2] > 0) $hash[$row[0]] = "Y";
@@ -287 +287 @@
     if (dberror($qry)) {echo "<b>error with $sql </b><br>\n";}
 
-    while ($qry->fetchInto($row)) {
+    while (dbFetchInto($qry, $row)) {
 
         if ($row[2] > 0) $hash[$row[0]] = "Y";
@@ -318 +318 @@
     if (dberror($qry)) {echo "<b>error with $sql </b><br>\n";}
 
-    while ($qry->fetchInto($row)) {
+    while (dbFetchInto($qry, $row)) {
 
         if ($row[2] > 0) $hash[$row[0]] = "Y";
@@ -350 +350 @@
     if (dberror($qry)) {echo "<b>error with $sql </b><br>\n";}
 
-    while ($qry->fetchInto($row)) {
+    while (dbFetchInto($qry, $row)) {
 
         if ($row[2] > 0) $hash[$row[0]] = $row[2];
@@ -380 +380 @@
     if (dberror($qry)) {echo "<b>error with $sql </b><br>\n";}
 
-    while ($qry->fetchInto($row)) {
+    while (dbFetchInto($qry, $row)) {
 
         if ($row[2] > 0) $hash[$row[0]] = $row[2];
@@ -408 +408 @@
     if (dberror($qry)) {echo "<b>error with $sql </b><br>\n";}
 
-    while ($qry->fetchInto($row)) {
+    while (dbFetchInto($qry, $row)) {
 
         if ($row[2] > 0) {
@@ -444 +444 @@
     if (dberror($qry)) {echo "<b>error with $sql </b><br>\n";}
 
-    while ($qry->fetchInto($row)) {
+    while (dbFetchInto($qry, $row)) {
 
         if ($row[2] > 0) $hash[$row[0]] = $row[2];
@@ -475 +475 @@
     if (dberror($qry)) {echo "<b>error with $sql </b><br>\n";}
 
-    while ($qry->fetchInto($row)) {
+    while (dbFetchInto($qry, $row)) {
 
         if ($row[2] > 0) $hash[$row[0]] = $row[2];
@@ -505 +505 @@
     if (dberror($qry)) {echo "<b>error with $sql </b><br>\n";}
 
-    while ($qry->fetchInto($row)) {
+    while (dbFetchInto($qry, $row)) {
 
         $hash[$row[0]] = $row[1];
@@ -536 +536 @@
     if (dberror($qry)) {echo "<b>error with $sql </b><br>\n";}
 
-    while ($qry->fetchInto($row)) {
+    while (dbFetchInto($qry, $row)) {
 
         if ($row[2] > 0) $hash[$row[0]] = $row[2];
@@ -566 +566 @@
     if (dberror($qry)) {echo "<b>error with $sql </b><br>\n";}
     $hash = array();
-    while ($qry->fetchInto($row)) {
+    while (dbFetchInto($qry, $row)) {
 
         if ($row[2] == 2) $hash1[$row[0]] = $row[1];