php生成mysql数据库数据字典的程序代码,比较实用,具体代码如下:header('Content-type:text/html;charset=utf-8');
/**
* 生成mysql数据字典
*
* @author www.cxyblog.com<403656085@qq.com>
*/
//配置数据库
$dbserver="localhost";
$dbusername="root";
$dbpassword="root";
$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.cxyblog.com
';echo '