BI_ediTable.php

---

Line #0:<?php include("QJ_start.php");
Line #1:
Line #2:
Line #3:if (isset($_GET[wjid])) $wjid=$_GET[wjid]; else $wjid=$_POST[wjid];
Line #4:if (isset($_GET[sqlfile])) $sqlfile=$_GET[sqlfile]; else $sqlfile=$_GET[sqlfile];
Line #5:
Line #6://include ("gvarlist.php");
Line #7:
Line #8:
Line #9:if ($wjid==-1)
Line #10:{
Line #11:
Line #12:$newcim = "INSERT INTO `$sqlfile`
Line #13:( `usr_kod`
Line #14:) VALUES
Line #15:( '$_SESSION[Qusr_kod]'
Line #16:)";
Line #17:mysql_query($newcim) or die("Hiba a $sqlfile insertben");
Line #18:
Line #19:$keres = "SELECT * FROM `$sqlfile` order by wid DESC";
Line #20:$csor=mysql_query($keres) or die("Hiba a $sqlfile select-ben");
Line #21:
Line #22:$cim_sor = mysql_fetch_array( $csor );
Line #23:$wjid=$cim_sor[wid];
Line #24:}
Line #25:
Line #26:
Line #27:$eredmeny = mysql_query('show fields from '.$sqlfile);
Line #28:
Line #29:$fid='';
Line #30:
Line #31:
Line #32:while ($row =mysql_fetch_row($eredmeny))
Line #33:{
Line #34:
Line #35: $fid.=$row[0] . ":";
Line #36:}
Line #37:
Line #38:
Line #39:$keres = "SELECT * FROM " . $sqlfile. ' WHERE wid='.$wjid;
Line #40:
Line #41://BI_alert($keres);
Line #42:
Line #43:
Line #44:
Line #45:
Line #46:$h=split(':',$fid);
Line #47:$nur=count($h)-1;
Line #48:
Line #49:
Line #50:
Line #51:if ($_POST[W])
Line #52:{
Line #53:
Line #54:$W=$_POST[W];
Line #55:
Line #56:$parancs = "UPDATE ".$sqlfile." SET ";
Line #57:
Line #58:$vesszo='';
Line #59:
Line #60:for($j=1;$j<$nur;$j++)
Line #61:
Line #62:{
Line #63:
Line #64: $parancs .=$vesszo.$h[$j]."='".$W[$j]."' ";
Line #65: $vesszo=', ';
Line #66:
Line #67:}
Line #68:$parancs .= " WHERE CONCAT( wid )='$wjid' LIMIT 1" ;
Line #69:
Line #70://BI_alert($parancs);
Line #71:
Line #72:
Line #73:
Line #74:// echo ($parancs.'<br>'.mysql_error().'<br>');
Line #75:
Line #76: $keres = "SELECT * FROM " . $sqlfile. ' WHERE wid='.$wjid;
Line #77:
Line #78:
Line #79:
Line #80:
Line #81:
Line #82:
Line #83: }
Line #84:
Line #85:
Line #86://echo("<a href=javascript:history.back()>Vissza...</a>");
Line #87:echo("<a href=javascript:window.close()>Vissza...</a>");
Line #88:
Line #89:
Line #90:$bup="<FORM name=orderby action='BI_ediTable.php?&sqlfile=$sqlfile&wjid=$wjid&bixupd=$Wjid' method='post'>";
Line #91:$bup.="<table border=1 align=center bgcolor='gold'>";
Line #92:$bup.="<td align=left>";
Line #93:$bup.="<tr><td align=right><input type='submit' value='Ment' name='submit'></td>";
Line #94:$bup.="<td align=center>$sqlfile / WID:$wjid";
Line #95:$bup.="<input type='hidden' value='$h[0]' name='Wjid'>";
Line #96:$bup.="</td></tr>";
Line #97:
Line #98://BI_alert($bup);
Line #99:
Line #100:$r=mysql_fetch_row($eredmeny);
Line #101:
Line #102://BI_alert($nur);
Line #103:
Line #104:for($j=1;$j<$nur;$j++)
Line #105:
Line #106:{
Line #107:
Line #108: $bum='W['.$j.']';
Line #109:
Line #110:// if (strpos($h[$j],"_kod")>0 or
Line #111:// strpos($h[$j],"time")>0 ) $ronly="readonly"; else $ronly="";
Line #112:
Line #113:// $bup.=$bum.'/';
Line #114:
Line #115:// $bup .= '<td with=50>&nbsp;'.$h[$j].'&nbsp;</td>';
Line #116:
Line #117: $bup.="<tr><td align=right>".$h[$j]."</td><td><input $ronly type='text' size=50 value='".$r[$j]."' name='".$bum."'></td></tr>";
Line #118:
Line #119:}
Line #120:
Line #121:
Line #122://BI_alert($bup);
Line #123:
Line #124:$bup.="</table></form>";
Line #125:
Line #126:echo($bup);
Line #127:
Line #128:echo("<a href=javascript:window.close()>Vissza...</a>");
Line #129:
Line #130:?>