All pastes #534332 Raw Edit

Mine

public text v1 · immutable
·published 2007-06-03 19:15 UTC
rendered paste body
function tabel ($tabel, $tingimused, $where, $valjad, $read, $selecti, $act1, $act2){

list($veerg1,$veerg2) = explode("\-/",$where[0]);
if ($veerg2=="2"){

if($_POST[$act2] == "salvesta") {
$rows=$_POST[rows2];
$count=count($valjad);

for ($n=1;$n<=$rows;$n++){
for ($k=1;$k<=$count-1;$k++){
sql("UPDATE ".PREFIX."".$tabel." SET	".$veerg1."='".$_POST["muuda_".$veerg1.""]."', ".$valjad[$k]."='".$_POST["".$valjad[$k]."_".$n.""]."' WHERE ".$valjad[0]."='".$_POST["".$valjad[0]."_".$n.""]."'");
}}
  sql("DELETE FROM ".PREFIX."".$tabel." WHERE kustuta=1");	
  red("?".ID.",2,".$_POST["muuda_".$veerg1.""]."");
  
  echo "salvestatud tabelisse ".$tabel."";
}
if($_POST[$act2] == "uus kirje") {
list($veerg1,$veerg2) = explode("\-/",$where[0]);

	sql("INSERT INTO ".PREFIX."".$tabel." (".$veerg1.") VALUES('".$_POST["muuda_".$veerg1.""]."')");
	red("?".ID.",2,".$_POST["muuda_".$veerg1.""]."");
echo "lisatud tabelisse ".$tabel."";
}
?>
       <form name=edit2 id=edit2 method=post action="?<?echo ID?>" onsubmit="javascript:submitEditor();"  enctype="multipart/form-data">
       <TABLE class=form width=630>
       <b><?echo$veerg1?></b>
       <INPUT TYPE="text" NAME="muuda_<?echo$veerg1?>" CLASS=field style="width:50%" VALUE="<?echo$where[1]?>">
       <TR>
<?
$count_valjad=count($valjad);
for ($i=0;$i<=$count_valjad-1;$i++){
?>
	     <TH><?echo$valjad[$i]?></TH>
<?}?>
       </TR>
<?
	$res = sql("SELECT ".$selecti." FROM ".PREFIX."".$tabel." WHERE ".$veerg1."='".$where[1]."' ".$tingimused."");
	while ($row=arr($res)){
	$n=$n+1;
?>       
       <TR>

<?
$count_read=count($read);
for ($k=0;$k<=$count_read-1;$k++){
list($veerg3,$veerg4) = explode("\-/",$read[$k]);

if ($veerg3=="checkbox"){?>
      <TD><INPUT TYPE="checkbox" NAME="<?echo$veerg4?>_<?echo$n?>" CLASS=field style="width:50%" VALUE=1 <?if($row[$veerg4]=="1") echo"CHECKED"?>></TD>
<?}else if($veerg3=="href"){?>
      <INPUT TYPE="hidden" NAME="<?echo$veerg4?>_<?echo$n?>" CLASS=field style="width:50%" VALUE="<?echo$row[$veerg4]?>">
      <TD><a href="?<?echo ID?>,2,<?echo$row[$veerg4]?>"><?echo$row[$veerg4]?></a></TD>
<?}else if($veerg3=="hidden"){?>
          <INPUT TYPE="hidden" NAME="<?echo$veerg4?>_<?echo$n?>" CLASS=field style="width:50%" VALUE="<?echo$row[$veerg4]?>">
<?}else if($veerg3=="hidden2"){?>
      <TD><INPUT TYPE="hidden" NAME="<?echo$veerg4?>_<?echo$n?>" CLASS=field style="width:50%" VALUE="<?echo$row[$veerg4]?>"><?echo$row[$veerg4]?></TD>
<?}else if($veerg3=="blank"){?>
      <TD><?echo$row[$veerg4]?></TD>
<?}else{?>
      <TD><INPUT TYPE="text" NAME="<?echo$veerg4?>_<?echo$n?>" CLASS=field style="width:50%" VALUE="<?echo$row[$veerg4]?>"></TD>
<?}}?>
      </TR>
<?}?>
      </TABLE>
      <INPUT TYPE="hidden" NAME="rows2" CLASS=field style="width:50%" VALUE="<?echo$n?>">
      <INPUT TYPE="button" class=field value="tagasi nimekirja" onclick="javascript:document.location.href='?<?echo ID?>'" style="width: 150px">
			<INPUT TYPE="submit" name="<?echo$act2?>" value="salvesta" class=field style="width: 150px">
      <INPUT TYPE="submit" name="<?echo$act2?>" value="uus kirje" class=field style="width: 150px">
      </form>
<?
}else{

if($_POST[$act1] == "salvesta") {
$rows=$_POST[rows1];
$count=count($valjad);

for ($n=1;$n<=$rows;$n++){
for ($k=1;$k<=$count-1;$k++){
sql("UPDATE ".PREFIX."".$tabel." SET	".$valjad[$k]."='".$_POST["".$valjad[$k]."_".$n.""]."' WHERE ".$valjad[0]."='".$_POST["".$valjad[0]."_".$n.""]."'");
}}
  sql("DELETE FROM ".PREFIX."".$tabel." WHERE kustuta=1");	
  red("?".ID."");
  
  echo "salvestatud tabelisse ".$tabel."";
}
if($_POST[$act1] == "uus kirje") {
list($veerg1,$veerg2) = explode("\-/",$where[0]);

	sql("INSERT INTO ".PREFIX."".$tabel." (".$veerg1.") VALUES('".$_POST[$veerg1]."')");
	red("?".ID.",2,".$_POST[$veerg1]."");
echo "lisatud tabelisse ".$tabel."";
}
?>
       <form name=edit1 id=edit1 method=post action="?<?echo ID?>" onsubmit="javascript:submitEditor();"  enctype="multipart/form-data">
       <TABLE class=form width=630>      
       <TR>
<?
$count_valjad=count($valjad);
for ($i=0;$i<=$count_valjad-1;$i++){
?>
	     <TH><?echo$valjad[$i]?></TH>
<?}?>
       </TR>
<?
	$res = sql("SELECT ".$selecti." FROM ".PREFIX."".$tabel." ".$tingimused."");
	while ($row=arr($res)){
	$n=$n+1;
?>       
       <TR>

<?
$count_read=count($read);
for ($k=0;$k<=$count_read-1;$k++){
list($veerg3,$veerg4) = explode("\-/",$read[$k]);

if ($veerg3=="checkbox"){?>
      <TD><INPUT TYPE="checkbox" NAME="<?echo$veerg4?>_<?echo$n?>" CLASS=field style="width:50%" VALUE=1 <?if($row[$veerg4]=="1") echo"CHECKED"?>></TD>
<?}else if($veerg3=="href"){?>
      <INPUT TYPE="hidden" NAME="<?echo$veerg4?>_<?echo$n?>" CLASS=field style="width:50%" VALUE="<?echo$row[$veerg4]?>">
      <TD><a href="?<?echo ID?>,2,<?echo$row[$veerg4]?>"><?echo$row[$veerg4]?></a></TD>
<?}else if($veerg3=="hidden"){?>
          <INPUT TYPE="hidden" NAME="<?echo$veerg4?>_<?echo$n?>" CLASS=field style="width:50%" VALUE="<?echo$row[$veerg4]?>">
<?}else if($veerg3=="hidden2"){?>
      <TD><INPUT TYPE="hidden" NAME="<?echo$veerg4?>_<?echo$n?>" CLASS=field style="width:50%" VALUE="<?echo$row[$veerg4]?>"><?echo$row[$veerg4]?></TD>
<?}else if($veerg3=="blank"){?>
      <TD><?echo$row[$veerg4]?></TD>
<?}else{?>
      <TD><INPUT TYPE="text" NAME="<?echo$veerg4?>_<?echo$n?>" CLASS=field style="width:50%" VALUE="<?echo$row[$veerg4]?>"></TD>
<?}}?>
      </TR>
<?}?>
      </TABLE>
      <INPUT TYPE="hidden" NAME="rows1" CLASS=field style="width:50%" VALUE="<?echo$n?>">
			<INPUT TYPE="submit" name="<?echo$act1?>" value="salvesta" class=field style="width: 150px">
      <BR>
      <INPUT TYPE="text" NAME="<?echo$veerg1?>" CLASS=field style="width:50%" VALUE="<?echo$row[$veerg1]?>">			
			<INPUT TYPE="submit" name="<?echo$act1?>" value="uus kirje" class=field style="width: 150px">
      </form>

<?
}}