前端之路

写文档什么是最麻烦的事情. 能交给程序做就让程序做吧. 于是有了这个生成程序

PHP代码

/*
Name: 生成mysql数据字典
URI: http://www.simcn.com/dict-tools
Version: 1.0
Author: Mark.Chen
Author URI: http://www.simcn.com
*/

//Set Server
$dbserver="localhost";
$dbusername="root";
$dbpassword="max197997";

//接收get参数
if($_GET['db']==''){
    $database = 'oms';
}else{
    $database = $_GET['db'];
}

$mysql_conn=@mysql_connect("$dbserver","$dbusername","$dbpassword") or die("Mysql connect is error.");

mysql_select_db($database,$mysql_conn);
$result = mysql_list_tables($database,$mysql_conn);
mysql_query('SET NAMES utf8',$mysql_conn);
while ($tableList = mysql_fetch_array($result)){
    $table = $tableList[0];
    $field_result= mysql_query("SELECT * FROM
                               INFORMATION_SCHEMA.COLUMNS
                               WHERE
                               table_name = '$table' AND table_schema = '$database'",$mysql_conn
                                );

    echo '
'.chr(13);
    echo '


'.chr(13);
    echo '


'.chr(13);
    while ($f = mysql_fetch_array($field_result)){
        echo '
'.chr(13);
        echo '


'.chr(13);
        echo '


'.chr(13);
        echo '


'.chr(13);
        echo '


'.chr(13);
        echo '


'.chr(13);
        echo '

'.chr(13);
    }
    echo '
'.$table.'

字段名
数据类型
默认值
字符编码
备注
'.$f['COLUMN_NAME'].'
'.$f['COLUMN_TYPE'].'
'.$f['COLUMN_DEFAULT'].'
'.$f['COLLATION_NAME'].'
'.$f['COLUMN_COMMENT'].'

';

}
mysql_close($mysql_conn);

html风格页面