phpME_report_566306087.TUA.inc.php 1001 B

123456789101112131415161718192021222324252627282930313233343536
  1. <? require_once 'auth.php';
  2. global $adodb;
  3. $rs2 = $adodb->Execute("SELECT * FROM ".$this->tb." ".
  4. " WHERE ".$this->key." = ?", $this->rec);
  5. //$adodb->debug = 1;
  6. $sql = "UPDATE fm_ahr_report
  7. SET
  8. Bemerkung = [Bemerkung],
  9. Bemerkung_2 = [Bemerkung_2],
  10. Bearbeitet = [Bearbeitet],
  11. Mahnen = [Mahnen],
  12. Wiedervorlage = [Wiedervorlage],
  13. User = [User],
  14. Aenderungsdatum =[Aenderungsdatum],
  15. Aenderungsdatum_u2 = [Aenderungsdatum_u2],
  16. User_2 = [User_2],
  17. Reklamation = [Reklamation]
  18. WHERE FAGNR = [FAGNR]
  19. AND O500_BELEGNR1 = [O500_BELEGNR1]
  20. AND OPDAT = [OPDAT]
  21. AND Reserve_1 = [Reserve_1];
  22. ";
  23. $p = explode(';', $sql);
  24. foreach ($p as $key => $sql) {
  25. $sql = trim($sql);
  26. if (!$sql) continue;
  27. if ($rs2->EOF) continue;
  28. foreach ($rs2->fields as $k => $v) {
  29. $v = addslashes($v);
  30. $sql = str_replace('['.$k.']', "'$v'", $sql);
  31. }
  32. $rs = $adodb->Execute($sql);
  33. if (!$rs) echo $adodb->ErrorMsg();
  34. }
  35. $adodb->debug = 0;
  36. ?>