/**
 * 生成mysql数据字典
 */
// 配置数据库
$database = array();
$database['DB_HOST'] = '127.0.0.1';
$database['DB_NAME'] = 'test';
$database['DB_USER'] = 'testuser';
$database['DB_PWD'] = '123456';

$mysql_conn = @mysql_connect("{$database['DB_HOST']}", "{$database['DB_USER']}", "{$database['DB_PWD']}") or die("Mysql connect is error.");
mysql_select_db($database['DB_NAME'], $mysql_conn);
$result = mysql_query('show tables', $mysql_conn);
mysql_query('SET NAME GBK', $mysql_conn);
// 取得所有表名
while ($row = mysql_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_query($sql, $mysql_conn);
 while ($t = mysql_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_query($sql, $mysql_conn);
 while ($t = mysql_fetch_array($field_result))
 {
  $fields[] = $t;
 }
 $tables[$k]['COLUMN'] = $fields;
}
mysql_close($mysql_conn);

$html = '';
// 循环所有表
foreach($tables as $k => $v)
{
 $html .= '

 foreach($v['COLUMN'] AS $f)
 {
  $html .= '

数据字典

生成时间：' . date('Y-m-d H:i:s') . '

总共：' . count($tables) . '个数据表

?>