superedit-TABLE_INSERTDB.php 2.6 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758
  1. <?php
  2. function TABLE_INSERTDB() {
  3. global $error,$thiss,$MENU_INIT;
  4. if(strstr($_SESSION[$thiss->DETECT_TABLE_COLUMN][FUNCPERMEDIT][TABLE_INSERTDB],"W")) { //EOF if($_SESSION[CURRENT_MENU]==A_PROBLEM)
  5. echo "<hr>f. TABLE_INSERTDB<hr>";
  6. if($_POST) {
  7. $ZAP_SQL_INSERT_F = "insert into ".$thiss->DETECT_TABLE_NAME." (ID,A_RECORD_UPDATE_DATE,A_RECORD_UPDATE_AUTHOR,A_RECORD_CREATE_DATE,A_RECORD_CREATE_AUTHOR";
  8. $ZAP_SQL_INSERT_V = ") values ('','".date(Y)."-".date(m)."-".date(d)."-".date(H).":".date(i)."','".$_SESSION[ADM_ACCOUNT]."','".date(Y)."-".date(m)."-".date(d)."-".date(H).":".date(i)."','".$_SESSION[ADM_ACCOUNT]."'";
  9. foreach ($_SESSION[$thiss->DETECT_TABLE_COLUMN][DESC] as $value) {
  10. if(($_SESSION[$thiss->DETECT_TABLE_COLUMN][WIEVID]==$_SESSION[$thiss->DETECT_TABLE_COLUMN][EDITRECORD][ID]) && (isset($_POST["$value"])) && (!($_POST["$value"]==$_SESSION[$thiss->DETECT_TABLE_COLUMN][EDITRECORD][$value]))) {
  11. if(($_SESSION[$thiss->DETECT_TABLE_COLUMN][TYPESPECIAL][$value])) {
  12. if(!function_exists($_SESSION[$thiss->DETECT_TABLE_COLUMN]['TYPESPECIAL'][$value])) SEF($_SESSION[$thiss->DETECT_TABLE_COLUMN]['TYPESPECIAL'][$value]);
  13. $_SESSION[$thiss->DETECT_TABLE_COLUMN]['TYPESPECIAL'][$value]('POST_VERIFY', $_POST[$value]);
  14. }
  15. }
  16. }
  17. foreach ($_SESSION[$thiss->DETECT_TABLE_COLUMN][DESC] as $value) {
  18. if((isset($_POST["$value"])) && (strstr($_SESSION[$thiss->DETECT_TABLE_COLUMN][PERMEDIT]["$value"],'C'))) {
  19. $_SESSION[$thiss->DETECT_TABLE_COLUMN][EDIT_TEMPLATE][$value]=$_POST[$value];
  20. $_SESSION[$thiss->DETECT_TABLE_COLUMN][NEW_RECORD][$value]=$_POST[$value];
  21. if($_SESSION[DEBUG]) "<br>\n F.TABLE_INSERTDB value= $value";
  22. $ZAP_SQL_INSERT_F = $ZAP_SQL_INSERT_F . ",$value";
  23. $ZAP_SQL_INSERT_V = $ZAP_SQL_INSERT_V . ",'". $_POST["$value"]. "'";
  24. }
  25. } //EOF foreach1
  26. } //EOF post
  27. if(!($error)) {
  28. $ZAP_SQL_INSERT = $ZAP_SQL_INSERT_F . $ZAP_SQL_INSERT_V . ");" ;
  29. if($_SESSION[DEBUG]) echo "<hr>$ZAP_SQL_INSERT<hr>";
  30. ZAP_SQL_UPDATE($ZAP_SQL_INSERT); $RESULT=$_SESSION[MYSQL_UPDATE_NUM_ROWS] ;
  31. echo "PASSED($RESULT)<hr>";
  32. }
  33. }
  34. echo "<h2>AKTUALIZACJA DANYCH: ";
  35. if($RESULT==2) echo "OK($RESULT)"; else { echo "ERROR($RESULT,$error)";
  36. }
  37. echo "</h2>";
  38. CREATE_MENUFUNC_NOTD_INIT($_SESSION[LAST_MENU],'POWROT DO ' . $_SESSION[LAST_MENU]);
  39. echo " | ";
  40. CREATE_MENUFUNC_NOTD_INIT($_SESSION[CURRENT_MENU],'POWROT DO ' . $_SESSION[CURRENT_MENU]);
  41. if(!($RESULT==2)) {
  42. echo " | ";
  43. CREATE_MENUFUNC_INIT_2($_SESSION[CURRENT_MENU],'',RESTORE,'POWROT_I_POPRAWA_DANYCH') ;
  44. }
  45. echo "<hr>";
  46. $MENU_INIT=MENU ;
  47. }
  48. ?>