echajoa/manage/makeBaseData.php

<?php

//include $_SERVER['DOCUMENT_ROOT'].'/common/lib/comm.php';
//include $_SERVER['DOCUMENT_ROOT'].ADMIN_PATH.'common/auth_chk.php';

	$connect = mysql_connect('cpro.interscope.co.kr','cpro','cprocpro') or die(mysql_error()); 
	mysql_select_db('information_schema',$connect) or die(mysql_error()); 
	mysql_query("SET NAMES utf8");

//$r = mysql_query("SELECT * FROM code_master");
//$r = mysql_query("SELECT * FROM information_schema.columns WHERE table_schema = 'cpro' group by table_name order by table_name");
$r = mysql_query("SELECT TABLE_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = 'cpro' GROUP BY TABLE_NAME ORDER BY TABLE_NAME");
$i=1;
while($col = mysql_fetch_array($r)) { 
	$TABLE_NAME = $col[TABLE_NAME];
?>
<table>
	<tr>
		<td><?=$col[TABLE_NAME]?></td>
	</tr>
	<tr>
		<td>
			<textarea cols="150" rows="10">
<?
//	$sql = "SELECT * FROM columns WHERE table_schema = 'cpro' and table_name = '$table_name' order by column_name";
//	echo $sql;

//	$rS = mysql_query("SELECT column_name FROM information_schema.columns WHERE table_schema = 'cpro' and table_name = '$table_name' order by ordinal_position");
	$rS = mysql_query("SELECT *  FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = 'cpro' AND TABLE_NAME = '$TABLE_NAME' ORDER BY ORDINAL_POSITION");
	$j=1;
	while($colS = mysql_fetch_array($rS)) { 

?>
<td align="center" class="list03"><\?=$col[<?=$colS[COLUMN_NAME]?>]\?></td>
<?
		$j++;
	}
?>



----------------------------------------------------------------------------------------



<?
	mysql_data_seek($rS,0);
	$j=1;
	while($colS = mysql_fetch_array($rS)) { 

?>
$<?=$colS[COLUMN_NAME]?>  = trim(avoid_crack($_POST["<?=$colS[COLUMN_NAME]?>"]));
<?
		$j++;
	}
?>



----------------------------------------------------------------------------------------



<?
	mysql_data_seek($rS,0);
	$j=1;
	while($colS = mysql_fetch_array($rS)) { 

?>
$<?=$colS[COLUMN_NAME]?> = $_POST["<?=$colS[COLUMN_NAME]?>"];
<?
		$j++;
	}
?>



----------------------------------------------------------------------------------------



<?
	mysql_data_seek($rS,0);
	$j=1;
	while($colS = mysql_fetch_array($rS)) { 

?>
, "<?=$colS[COLUMN_NAME]?>" => $<?=$colS[COLUMN_NAME]?>&#10;<?
		$j++;
	}
?>



----------------------------------------------------------------------------------------



<?
	mysql_data_seek($rS,0);
	$j=1;
	while($colS = mysql_fetch_array($rS)) { 

?>
, "<?=$colS[COLUMN_NAME]?>" => $<?=$colS[COLUMN_NAME]?> 
<?
		$j++;
	}
?>



----------------------------------------------------------------------------------------



<?
	mysql_data_seek($rS,0);
	$j=1;
	while($colS = mysql_fetch_array($rS)) { 

?>
, <?=$colS[COLUMN_NAME]?> => '$<?=$colS[COLUMN_NAME]?>' 
<?
		$j++;
	}
?>



----------------------------------------------------------------------------------------



<?
	mysql_data_seek($rS,0);
	$j=1;
	while($colS = mysql_fetch_array($rS)) { 

?>
$<?=$colS[COLUMN_NAME]?> = $col[<?=$colS[COLUMN_NAME]?>];
<?
		$j++;
	}
?>



----------------------------------------------------------------------------------------



<?
	mysql_data_seek($rS,0);
	$j=1;
	while($colS = mysql_fetch_array($rS)) { 

?>
<input type="text" name="<?=$colS[COLUMN_NAME]?>" id="<?=$colS[COLUMN_NAME]?>" style="width:20%;"  class="input_txt" maxlength="50" value="<\?=$<?=$colS[COLUMN_NAME]?>\?>">
<?
		$j++;
	}
?>



----------------------------------------------------------------------------------------



<?
	mysql_data_seek($rS,0);
	$j=1;
	while($colS = mysql_fetch_array($rS)) { 

?>
<input type="text" name="<?=$colS[COLUMN_NAME]?>" id="<?=$colS[COLUMN_NAME]?>" value="<\?=$<?=$colS[COLUMN_NAME]?>\?>">
<?
		$j++;
	}
?>
			</textarea>
		</td>
	</tr>
</table>
<?
	$i++;
}

mysql_close($connect);
?>