"set names utf8"); //其他配置 $title = '数据字典'; try{ $dbh = new PDO("mysql:host=". $dbhost .";dbname=". $dbname, $dbuser, $dbpass, $dboption); //echo "Connection success!"; }catch(Exception $e){ echo "Failed: " . $e->getMessage(); //echo "

Can not connect to database!

"; die(); } $sql = "show tables"; $sth = $dbh->prepare($sql); $sth->execute(); $rs = $sth->fetchAll(PDO::FETCH_NUM); $tables = array(); foreach($rs as $key => $value){ $tables[]['TABLE_NAME'] = $value[0]; } //循环取得所有表的备注及表中列信息 foreach ($tables as $k=>$v) { $sql = 'SELECT * FROM '; $sql .= 'INFORMATION_SCHEMA.TABLES '; $sql .= 'WHERE '; $sql .= "table_name = '". $v['TABLE_NAME'] ."' AND table_schema = '". $dbname ."'"; $sth = $dbh->prepare($sql); $sth->execute(); $table_result = $sth->fetchAll(PDO::FETCH_ASSOC); foreach($table_result as $t){ $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 = '". $dbname ."'"; $sth = $dbh->prepare($sql); $sth->execute(); $field_result = $sth->fetchAll(PDO::FETCH_ASSOC); $fields = array(); foreach($field_result as $t){ $fields[] = $t; } $tables[$k]['COLUMN'] = $fields; } //print_r($tables); $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']. '
字段名	数据类型	默认值	允许空值(NULL)	自动递增	备注
' . $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 ''; ?>