本文共计559个文字，预计阅读时间需要3分钟。

php

data_dictionary.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 .= ' ' . $v['TABLE_NAME'] .' '. $v['TABLE_COMMENT']. ' '; $html .= ' 字段名 数据类型 默认值 允许非空 自动递增 备注 '; $html .= ''; $i=1; foreach ($v['COLUMN'] AS $f) { $td = $i%2?'td2':'td1'; $i++; $html .= " " . $f['COLUMN_NAME'] . ''; $html .= " " . $f['COLUMN_TYPE'] . ''; $html .= " " . $f['COLUMN_DEFAULT'] . ''; $html .= " " . $f['IS_NULLABLE'] . ''; $html .= " ". ($f['EXTRA']=='auto_increment'?'是':'') . ''; $html .= " " . $f['COLUMN_COMMENT'] . ''; $html .= " "; } $html .= '

'; } //输出 echo ' '; echo '

'.$title.'

'; echo $html; echo ''; ?>