php生成mysql数据库数据字典的程序代码,比较实用,具体代码如下:header('Content-type:text/html;charset=utf-8');
/**
*生成mysql数据字典
*
*@<403656085@>
*/
//配置数据库
$dbserver="localhost";
$dbusername="root";
$dbpassword="root";
$database='test';
//其他配置
$title=$database.'数据库数据字典';
$mysql_conn=@mysql_connect("$dbserver","$dbusername","$dbpassword")ordie("Mysqlconnectiserror.");
mysql_select_db($database,$mysql_conn);
mysql_query('SETNAMESutf8',$mysql_conn);
$table_result=mysql_query('showtables',$mysql_conn);
//取得所有的表名
while($row=mysql_fetch_array($table_result)){
$tables[]['TABLE_NAME']=$row[0];
}
//循环取得所有表的备注
foreach($tablesAS$k=>$v){
$sql='SELECT*FROM';
$sql.='INFORMATION_SCHEMA.TABLES';
$sql.='WHERE';
$sql.="table_name='{$v['TABLE_NAME']}'ANDtable_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']}'ANDtable_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($tablesAS$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:1pxsolid#CCC;background:#efefef;}
tablecaption{text-align:left;background-color:#fff;line-height:2em;font-size:14px;font-weight:bold;}
tableth{text-align:left;font-weight:bold;height:26px;line-height:26px;font-size:12px;border:1pxsolid#CCC;}
tabletd{height:20px;font-size:12px;border:1pxsolid#CCC;background-color:#fff;}
tablecaption,tabletd,tableth{padding:0px3px;}
#version{text-align:center;margin:0auto;}
.cr{color:#ff0033;}
echo'
'.$title.'
';echo$html;
$version='
';
echo'