테이블 명세서 만들어주기.

<html>

<head>

<title></title>

<!-- JQUERY -->

<link href="//code.jquery.com/ui/1.11.4/themes/smoothness/jquery-ui.css" rel="stylesheet">

<script src="//code.jquery.com/jquery.min.js"></script>

<script src="//code.jquery.com/ui/1.11.4/jquery-ui.min.js"></script>

<!-- font-awesome ICON -->

<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/font-awesome/4.5.0/css/font-awesome.min.css">

<!-- bootstrap -->

<link href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css" rel="stylesheet" integrity="sha384-BVYiiSIFeK1dGmJRAkycuHAHRg32OmUcww7on3RYdg4Va+PmSTsz/K68vbdEjh4u" crossorigin="anonymous">

<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js" integrity="sha384-Tc5IQib027qvyjSMfHjOMaLkfuWVxZxUPnCJA7l2mCWNIpG9mGCD8wGNIcPD7Txa" crossorigin="anonymous"></script> 

<style>

table th { background-color:#F1F1F1; }

</style>

</head>

<body>

<div class="container">

<?php

$DB = array();

$DB['prefix'] = "";

$DB['host'] = "";

$DB['name'] = "";

$DB['id'] = "";

$DB['pwd'] = "";

$DB['connect'] = mysqli_connect(

$DB['host'],

$DB['id'],

$DB['pwd']

);

$DB['db_select'] = mysqli_select_db(

$DB['connect'],

$DB['name']

);

$table_desc = array(

);

$html = "";

$html .= "<h3>총 테이블 카운트 : <span id='table_count'></span></h3>";

$sql = "SHOW TABLE STATUS LIKE '%%'";

$rec = mysqli_query($DB['connect'], $sql);

$count = 0;

while($tb = mysqli_fetch_assoc($rec))

{

$html .= "

<div class='alert alert-info' style='margin-bottom:0px;'>

<p>테이블명 : {$tb['Name']}</p>

<p>테이블 설명 : {$tb['Comment']}</p>

</div>

";

if($table_desc[$tb['Name']]){

$html .= "<h3><span style='color:blue;'>추가설명</span> : ".$table_desc[$tb['Name']]."</h3>";

}

$html .= "

<table class='table' style='margin-bottom:50px;'>

<thead>

<tr>

<th>Field</th>

<th>Type</th>

<th>Null</th>

<th>Key</th>

<th>Default</th>

<th>Extra</th>

<th>Comment</th>

</tr>

</thead>

<tbody>

";

$sql = "SHOW FULL COLUMNS FROM {$tb['Name']}";

$recSub = mysqli_query($DB['connect'], $sql);

while($field = mysqli_fetch_assoc($recSub))

{

$html .= "

<tr>

<td>{$field['Field']}</td>

<td>{$field['Type']}</td>

<td>{$field['Null']}</td>

<td>{$field['Key']}</td>

<td>{$field['Default']}</td>

<td>{$field['Extra']}</td>

<td>{$field['Comment']}</td>

</tr>" . PHP_EOL;

}

$html .= "

</tbody>

</table>

" . PHP_EOL;

$count++;

}

echo $html;

?>

<script>

$(document).ready(function(){

$("#table_count").html("<?=$count?>");

});

</script>

</div>

</body>

</html>