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; }
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; }