有時候我們拿到別人的數據庫，卻沒有數據字典，這個php小程序幫你輕松解決。

代碼是網上找到的，當然，這段代碼也僅僅是生成了數據字典，視圖，存儲過程等等是木有的哦。

$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 .= '' . $v['TABLE_NAME'] .'  '. $v['TABLE_COMMENT']. '';
    $html .= '字段名數據類型默認值
    允許非空
    自動遞增備注';
    $html .= '';

    foreach ($v['COLUMN'] AS $f) {
        $html .= '' . $f['COLUMN_NAME'] . '';
        $html .= '' . $f['COLUMN_TYPE'] . '';
        $html .= ' ' . $f['COLUMN_DEFAULT'] . '';
        $html .= ' ' . $f['IS_NULLABLE'] . '';
        $html .= '' . ($f['EXTRA']=='auto_increment'?'是':' ') . '';
        $html .= ' ' . $f['COLUMN_COMMENT'] . '';
        $html .= '';
    }
    $html .= '
';
}

//輸出
echo '





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

?>