平常要看 mysql 数据结构，可能需要登录服务器命令行查看，当然也可以用navicat 等软件，但是很麻烦，所以有了这个网页版。
生成mysql数据字典
-
<?php -
/** -
* 生成mysql数据字典https://github.com/shangheguang/data_dictionary/blob/master/mysql.php -
*/ -
// 配置数据库 -
$database = array(); -
$database['DB_HOST'] = '127.0.0.1'; -
$database['DB_NAME'] = 'test'; -
$database['DB_USER'] = 'root'; -
$database['DB_PWD'] = ''; -
date_default_timezone_set('Asia/Shanghai'); -
$mysql_conn = @mysqli_connect("{$database['DB_HOST']}", "{$database['DB_USER']}", "{$database['DB_PWD']}") or die("Mysql connect is error."); -
mysqli_select_db($mysql_conn, $database['DB_NAME']); -
$result = $mysql_conn->query('show tables'); -
$mysql_conn->query('SET NAME UTF8'); -
// 取得所有表名 -
while ($row = mysqli_fetch_array($result)) -
{ -
$tables[]['TABLE_NAME'] = $row[0]; -
} -
// 循环取得所有表的备注及表中列消息 -
foreach($tables as $k => $v) -
{ -
$sql = 'SELECT * FROM '; -
$sql .= 'INFORMATION_SCHEMA.TABLES '; -
$sql .= 'WHERE '; -
$sql .= "table_name = '{$v['TABLE_NAME']}' AND table_schema = '{$database['DB_NAME']}'"; -
$table_result = $mysql_conn->query($sql); -
while ($t = mysqli_fetch_array($table_result)) -
{ -
$tables[$k]['TABLE_COMMENT'] = $t['TABLE_COMMENT']; -
} -
$sql = 'SELECT * FROM '; -
$sql .= 'INFORMATION_SCHEMA.COLUMNS '; -
$sql .= 'WHERE '; -
$sql .= "table_name = '{$v['TABLE_NAME']}' AND table_schema = '{$database['DB_NAME']}'"; -
$fields = array(); -
$field_result = $mysql_conn->query($sql); -
while ($t = mysqli_fetch_array($field_result)) -
{ -
$fields[] = $t; -
} -
$tables[$k]['COLUMN'] = $fields; -
} -
mysqli_close($mysql_conn); -
$html = ''; -
// 循环所有表 -
foreach($tables as $k => $v) -
{ -
if($v['TABLE_NAME']){ -
$html .= '<table border="1" cellspacing="0" cellpadding="0" align="center">'; -
$html .= '<caption>表名：' . $v['TABLE_NAME'] . ' ------- ' . $v['TABLE_COMMENT'] . '</caption>'; -
$html .= '<tbody><tr><th>字段名</th><th>数据类型</th><th>默认值</th><th>允许非空</th><th>自动递增</th><th>备注</th></tr>'; -
$html .= ''; -
foreach($v['COLUMN'] AS $f) -
{ -
$html .= '<td class="c1">' . $f['COLUMN_NAME'] . '</td>'; -
$html .= '<td class="c2">' . $f['COLUMN_TYPE'] . '</td>'; -
$html .= '<td class="c3">' . $f['COLUMN_DEFAULT'] . '</td>'; -
$html .= '<td class="c4">' . $f['IS_NULLABLE'] . '</td>'; -
$html .= '<td class="c5">' . ($f['EXTRA'] == 'auto_increment'?'是':' ') . '</td>'; -
$html .= '<td class="c6">' . $f['COLUMN_COMMENT'] . '</td>'; -
$html .= '</tr>'; -
} -
} -
$html .= '</tbody></table></p>'; -
} -
// 输出 -
echo '<html> -
<meta charset="utf-8"> -
<title>自动生成数据字典</title> -
<style> -
body,td,th {font-family:"宋体"; font-size:12px;} -
table,h1,p{width:960px;margin:0px auto;} -
table{border-collapse:collapse;border:1px solid #CCC;background:#efefef;} -
table caption{text-align:left; background-color:#fff; line-height:2em; font-size:14px; font-weight:bold; } -
table th{text-align:left; font-weight:bold;height:26px; line-height:26px; font-size:12px; border:1px solid #CCC;padding-left:5px;} -
table td{height:20px; font-size:12px; border:1px solid #CCC;background-color:#fff;padding-left:5px;} -
.c1{ width: 150px;} -
.c2{ width: 150px;} -
.c3{ width: 80px;} -
.c4{ width: 100px;} -
.c5{ width: 100px;} -
.c6{ width: 300px;} -
</style> -
<body>'; -
echo '<h1 style="text-align:center;">数据字典</h1>'; -
echo '<p style="text-align:center;margin:20px auto;">生成时间：' . date('Y-m-d H:i:s') . '</p>'; -
echo $html; -
echo '<p style="text-align:left;margin:20px auto;">总共：' . count($tables) . '个数据表</p>'; -
echo '</body></html>';
效果
如果使用 laravel 可以看看 https://github.com/jormin/laravel-ddoc 支持导出 Html 和 PDF 文件。
本文分享自微信公众号 - 苏生不惑（susheng_buhuo）。
如有侵权，请联系 support@oschina.cn 删除。
本文参与“OSC源创计划”，欢迎正在阅读的你也加入，一起分享。