echajoa/manage/makeBaseData_201812081738.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>
<?
//	$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)) { 

?>
	<tr>
		<td>&nbsp;&nbsp;<?=$colS[COLUMN_NAME]?></td>
	</tr>
<?
		$j++;
	}
?>
</table>
<?
	$i++;
}

mysql_close($connect);
?>