bisqlupd.php

---

Line #0:<?php require("QJ_start.php");
Line #1:
Line #2:$wjid=$_GET[wjid];
Line #3:$sqlfile=$_GET[sqlfile];
Line #4://include ("gvarlist.php");
Line #5:
Line #6:$sqlfile=$_SESSION[sqlfile];
Line #7:
Line #8:if ($wjid==-1)
Line #9:{
Line #10:
Line #11:$newcim = "INSERT INTO `$_SESSION[sqlfile]`
Line #12:( `usr_kod`
Line #13:) VALUES
Line #14:( '$_SESSION[Qusr_kod]'
Line #15:)";
Line #16:
Line #17:mysql_query($newcim) or die("Hiba a $sqlfile insertben");
Line #18:
Line #19:$keres = "SELECT * FROM $_SESSION[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:$eredmeny = mysql_query('show fields from '.$sqlfile);
Line #27:
Line #28:$fid='';
Line #29:
Line #30:while ($row =mysql_fetch_row($eredmeny))
Line #31:{
Line #32: $fid.=$row[0] . ":";
Line #33:}
Line #34:
Line #35:$keres = "SELECT * FROM " . $sqlfile. ' WHERE wid='.$wjid;
Line #36:
Line #37:
Line #38:$h=split(':',$fid);
Line #39:$nur=count($h)-1;
Line #40:
Line #41:if ($_POST[W])
Line #42:{
Line #43:
Line #44:$W=$_POST[W];
Line #45:
Line #46:$parancs = "UPDATE ".$sqlfile." SET ";
Line #47:
Line #48:$vesszo='';
Line #49:
Line #50:for($j=1;$j<$nur;$j++)
Line #51:
Line #52:{
Line #53:
Line #54: $parancs .=$vesszo.$h[$j]."='".$W[$j]."' ";
Line #55: $vesszo=', ';
Line #56:
Line #57:}
Line #58:$parancs .= " WHERE CONCAT( wid )='$wjid' LIMIT 1" ;
Line #59:
Line #60:
Line #61:$keres = "SELECT * FROM " . $sqlfile. ' WHERE wid='.$wjid;
Line #62:
Line #63:}
Line #64:
Line #65:echo("<a href=javascript:window.close()>Vissza...</a>");
Line #66:
Line #67:
Line #68:$bup="<FORM name=orderby action='bisqlupd.php?&sqlfile=$sqlfile&wjid=$wjid&bixupd=$Wjid' method='post'>";
Line #69:$bup.="<table border=1 align=center bgcolor='gold'>";
Line #70:$bup.="<td align=left>";
Line #71:
Line #72:$bup.="<td align=center>$sqlfile / WID:$wjid";
Line #73:$bup.="<input type='hidden' value='$h[0]' name='Wjid'>";
Line #74:$bup.="</td></tr>";
Line #75:
Line #76:$r=mysql_fetch_row($eredmeny);
Line #77:
Line #78:for($j=1;$j<$nur;$j++)
Line #79:
Line #80:{
Line #81:$ronly="";
Line #82: $bum='W['.$j.']';
Line #83:/*
Line #84: if (strpos($h[$j],"_kod")>0 or
Line #85: strpos($h[$j],"time")>0 ) $ronly="readonly"; else $ronly="";
Line #86:*/
Line #87:// $bup.=$bum.'/';
Line #88:
Line #89:// $bup .= '<td with=50>&nbsp;'.$h[$j].'&nbsp;</td>';
Line #90:
Line #91: $bup.="<tr><td align=right>".$h[$j]."</td><td><input $ronly type='text' size=50 value='".$r[$j]."' name='".$bum."'></td></tr>";
Line #92:
Line #93:}
Line #94:
Line #95:$bup.="</table></form>";
Line #96:
Line #97:echo($bup);
Line #98:
Line #99:echo("<a href=javascript:window.close()>Vissza...</a>");
Line #100:
Line #101:
Line #102:?>