php 创建数据字典

<?php


//自动生成数据表字典
//设置
$database="name";
$charset="utf8";


/*******************************/
mysql_connect("localhost","root","111111") or die("链接数据库失败");
mysql_select_db($database) or die("选择数据库失败");
mysql_query("set names ".$charset);


//获取表描述
$q_table_des=mysql_query("SHOW TABLE STATUS");
$i=0;
$result="";
$num_table=1;
while ($rows=mysql_fetch_array($q_table_des)){
//记录表名
$table_name=$rows['Name'];
//表注释
$table_des=$rows['Comment'];
$i++;
$result.="<br/><br/>";
$table_des=empty($table_des)?'':' '.$table_des;
$result.="<h2>".$i."、".$table_name.$table_des."</h2>";
$result.="<table width='100%' border='1' cellspacing='0' cellpadding='2'>";

//定义表头
$result.="<tr bgcolor='#99CCFF'><th>Field</th><th>Type</th><th>Null</th><th>Key</th><th>Default</th><th>Extra</th><th>Comment</th></tr>";
//表字段
$tableQuery=mysql_query("SHOW FULL COLUMNS FROM  " .$table_name) or die("失败");
while ($rows_t=mysql_fetch_assoc($tableQuery)){
$result.="<tr><td>".$rows_t['Field']."</td><td>".$rows_t['Type']."</td><td>".$rows_t['Null']."</td><td>".$rows_t['Key']."</td><td>".$rows_t['Default']."</td><td>".$rows_t['Extra']."</td><td>".$rows_t['Comment']."</td></tr>";

//print_r($rows_t);
}
$result.="</table>";

}




echo $i;
echo $result;