Changeset 39498 for trunk/ippMonitor/def/autocode.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/def/autocode.php (modified) (6 diffs)

trunk/ippMonitor/def/autocode.php

@@ -26 +26 @@
 
 // define restrictions to the queries
+$WHERE = "";
 // ** TABLE RESTRICTIONS **
 
@@ -40 +41 @@
 
 // get the result table count
-if ($MODE == "basic") {
+if ("$MODE" == "basic") {
   $sql = "SELECT count(*) FROM $TABLE $WHERE";
 }
-if ($MODE == "summary") {
+if ("$MODE" == "summary") {
   $sql = "SELECT count(*) FROM (SELECT $FIELDS FROM $TABLE $WHERE) as TEMP";
 }
@@ -53 +54 @@
   menu_end();
 }
-if (!$qry->fetchInto($row)) {
+if (!dbFetchInto($qry, $row)) {
   echo "<b>error reading $TABLE table count</b><br>\n";
   echo "<br><small><b> count query : $sql </b></small><br>\n";
@@ -78 +79 @@
 
 // query the database
-if ($MODE == "basic") {
+if ("$MODE" == "basic") {
   $sql = "SELECT $FIELDS FROM $TABLE $WHERE LIMIT $dTABLE OFFSET $rowStart";
 }
-if ($MODE == "summary") {
+if ("$MODE" == "summary") {
   $sql = "SELECT $FIELDS FROM $TABLE $WHERE LIMIT $dTABLE OFFSET $rowStart";
 }
@@ -94 +95 @@
 // ** HEAD CODE **
 
+$buttonLink = "";
 // ** BUTTON RESTRICTIONS **
 navigate_buttons ($rowStart, $rowLast, $dTABLE, $rowTotal, $buttonLink, $ID, '$FILE');
@@ -113 +115 @@
 
 // list the results
-while ($qry->fetchInto($row)) {
+while (dbFetchInto($qry, $row)) {
   // $link = "$FILE" . "?expID=" . $row[0] . "&" . $ID['link'];