php產生mysql資料字典

有時候我們拿到別人的資料庫，卻沒有資料字典，這個php小程式幫你輕鬆解決。

代碼是網上找到的，當然，這段代碼也僅僅是產生了資料字典，視圖，預存程序等等是木有的哦。

$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 .= "
". $v["TABLE_COMMENT"] . " ";    $html .= "
 
  ";    $html .= "
  ";    $html .= "
  "; $html .= ""; foreach ($v["COLUMN"] AS $f) { $html .= "
   "; $html .= "
    "; $html .= "
    "; $html .= "
    "; $html .= "
    "; $html .= "
    "; $html .= "
   "; } $html .= "
  

   " . $v["TABLE_NAME"] ." ". $v["TABLE_COMMENT"]. "
  

   

    
欄位名
    
資料類型
    
預設值
 
    
允許非空
 
    
自動遞增
    
備忘
   

    
" . $f["COLUMN_NAME"] . "
" . $f["COLUMN_TYPE"] . "
 " . $f["COLUMN_DEFAULT"] . "
 " . $f["IS_NULLABLE"] . "
" . ($f["EXTRA"]=="auto_increment"?"是":" ") . "
 " . $f["COLUMN_COMMENT"] . "
 
";}//輸出echo "".$title."";echo "
".$title."
";echo $html;echo "";?>

運行後的結果：