BiCopyTable.inc

---

Line #0:<?php include("QJ_start.php");
Line #1:
Line #2:$myFile = $_GET[submenu].".SQL";
Line #3:
Line #4:
Line #5:$eredmeny = mysql_query('show fields from '.$_GET[tabla]);
Line #6:
Line #7:$fid='';
Line #8:
Line #9:
Line #10:while ($row =mysql_fetch_row($eredmeny))
Line #11:{
Line #12:
Line #13: $fid.=$row[0] . ":";
Line #14:}
Line #15:
Line #16:
Line #17:if (isset($_GET[wer])) {
Line #18: $wer=str_replace("~","'",$_GET[wer]);
Line #19: $wer=str_replace("%"," ",$wer);
Line #20: $keres = "SELECT * FROM " . $_GET[tabla]. $wer;
Line #21: $myFile = $_GET[tabla].".SQL";
Line #22:} else
Line #23: $keres = "SELECT * FROM " . $_GET[tabla]. " WHERE szoveg='".$_GET[submenu]."'";
Line #24:
Line #25:
Line #26:
Line #27:///////////////////////////////////////////////////////
Line #28:$fh = fopen($myFile, 'w') or die("can't open file");
Line #29:///////////////////////////////////////////////////////
Line #30:
Line #31:$h=split(':',$fid);
Line #32:$nur=count($h)-1;
Line #33:
Line #34:while ($row =mysql_fetch_row($eredmeny))
Line #35:{
Line #36:
Line #37:$parancs = "REPLACE INTO ".$_GET[tabla]. " ";
Line #38:
Line #39:$vesszo='';
Line #40:$mezok="(";
Line #41:$adatok="(";
Line #42:
Line #43:for($j=1;$j<$nur;$j++)
Line #44:
Line #45:{
Line #46:
Line #47:// $parancs .=$vesszo.$h[$j]."='".$row[$j]."' ";
Line #48: $mezok .=$vesszo."`".$h[$j]."`" ;
Line #49: $adatok .=$vesszo." '".$row[$j]."'";
Line #50: $vesszo=', ';
Line #51:
Line #52:}
Line #53:
Line #54:$parancs .= $mezok." ) VALUES ".CHR(10). $adatok." );" ;
Line #55:
Line #56: $stringData=htmlspecialchars($parancs).CHR(10);
Line #57: echo (htmlspecialchars($parancs).'<br>');
Line #58:
Line #59: fwrite($fh, $stringData);
Line #60:
Line #61:
Line #62:}
Line #63:
Line #64:
Line #65:fclose($fh);
Line #66:
Line #67:
Line #68:
Line #69:
Line #70://include("QJ_varlist.php");
Line #71:
Line #72:
Line #73:?>
Line #74: