数据字典在应用的开发和维护过程中都有着极其重要的单方,最重要的作用是作为分析阶段的工具。任何字典最重要的用途都是供人查询对不了解的条目的解释,在结构化分析中,数据字典的作用是给数据流图上每个成分加以定义和说明,Web应用开发中使用到数据库就难免会接触到数据字典,
下面是使用php生成mysql数据库数据字典的程序代码,比较实用,具体代码如下:
header('Content-type:text/html;charset=utf-8');
/**
* 生成mysql数据字典
*
* @author www.codetc.com
*/
//配置数据库
$dbserver="localhost";
$dbusername="root";
$dbpassword="123456";
$database='test';
//其他配置
$title=$database.' 数据库数据字典';
$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.='
$html.='
'.$v['TABLE_COMMENT'].'( '. $v['TABLE_NAME'].')';$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['COLUMN_COMMENT'].($f['EXTRA']=='auto_increment'?',自动递增':'').'';$html.='
';}
$html.='
';}
输出
echo '
'.$title.'body,td,th{font-family:"宋体"; font-size:12px;}
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;}
table td{height:20px; font-size:12px; border:1px solid #CCC;background-color:#fff;}
table caption,table td,table th{padding:0px 3px;}
#version{text-align:center;margin:0 auto;}
.cr{color:#ff0033;}
echo '
'.$title.'
';echo $html;
$version='
made by www.codetc.com
';echo '
效果如下图: