Пример #1
0
 function Update($tableName, $arrFieldName, $arrValue, $KeyStr)
 {
     $res = false;
     if (chkArray($arrFieldName, $arrValue)) {
         $sqlval = "";
         $rc = false;
         for ($i = 0; $i < count($arrFieldName); $i++) {
             if ($rc) {
                 $sqlval .= ",";
             }
             $sqlval .= $arrFieldName[$i] . "='" . $arrValue[$i] . "'";
             $rc = true;
         }
         writetofile("x.txt", " UPDATE " . $tableName . " SET " . $sqlval . " WHERE " . $KeyStr . " ;");
         $res = $this->query(" UPDATE " . $tableName . " SET " . $sqlval . " WHERE " . $KeyStr . "");
         //			$res=true;
     }
     //		echo " UPDATE " . $tableName." SET ".$sqlval." WHERE ".$KeyStr."";
     return $res;
 }
Пример #2
0
 function Update($tabName, $arrFieldName, $arrValue, $KeyStr, $f = 0)
 {
     $res = false;
     if (chkArray($arrFieldName, $arrValue)) {
         $sqlval = "";
         $rc = false;
         for ($i = 0; $i < count($arrFieldName); $i++) {
             if ($rc) {
                 $sqlval .= ",";
             }
             if ($f == 0) {
                 $sqlval .= $arrFieldName[$i] . "='" . (MAC_MODULE == 'home' ? mysql_real_escape_string($arrValue[$i]) : $arrValue[$i]) . "'";
             } else {
                 $sqlval .= $arrFieldName[$i] . "='" . (MAC_MODULE == 'home' ? mysql_real_escape_string($arrValue[$arrFieldName[$i]]) : $arrValue[$arrFieldName[$i]]) . "'";
             }
             $rc = true;
         }
         $sql = " UPDATE " . $tabName . " SET " . $sqlval . " WHERE " . $KeyStr . "";
         //echo $sql."<br>";
         $res = $this->query($sql);
         if ($res) {
             //echo "ok";
         } else {
             //echo "err";
         }
     }
     return $res;
 }