标签 dictionary 下的文章

突然想到这个方法，果然已经有人实现了。

有这个脚本也能看出来，数据表的很多信息都保存在INFORMATION_SCHEMA.TABLES表里，还有数据表注释的重要性！


 */

//配置数据库
$dbserver   = "localhost";
$dbusername = "root";
$dbpassword = "root";
$database   = 'mydb';
//其他配置
$title = '系统数据字典';

$mysql_conn = @mysql_connect("$dbserver", "$dbusername", "$dbpassword") or die("Mysql connect is error.");
mysql_select_db($database, $mysql_conn);
mysql_query('SET NAMES utf8', $mysql_conn);
$table_result = mysql_query('show tables', $mysql_conn);
//取得所有的表名
while ($row = mysql_fetch_array($table_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}'";
    $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}'";

    $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 .= '
'. $v['TABLE_COMMENT'] . ' 
';
    $html .= '';
    $html .= '';
    $html .= '';
    $html .= '';

    foreach ($v['COLUMN'] AS $f) {
        $html .= '';
        $html .= '';
        $html .= '';
        $html .= '';
        $html .= '';
        $html .= '';
        $html .= '';
    }
    $html .= '
' . $v['TABLE_NAME'] . '
字段名数据类型默认值
    允许非空
    自动递增备注
' . $f['COLUMN_NAME'] . '' . $f['COLUMN_TYPE'] . ' ' . $f['COLUMN_DEFAULT'] . ' ' . $f['IS_NULLABLE'] . '' . ($f['EXTRA']=='auto_increment'?'是':' ') . ' ' . $f['COLUMN_COMMENT'] . '
';
}


//输出
echo '

' . $title . '


';
echo '
' . $title . '
';
echo $html;
echo '';

修改一下用户名密码即可，之后打印成PDF即可分发给团队成员使用了。

转自http://www.cnblogs.com/zemliu/archive/2012/06/04/2533555.html