标题：PHP 生成数据字典出处：沧海一粟时间：Wed, 14 Mar 2018 10:20:02 +0000 作者：jed 地址：http://www.dzhope.com/post/1110/ 内容： exec('SET NAMES utf8'); } catch (PDOException $e) { echo 'Connection failed: ' . $e->getMessage(); } $table_result = $pdo->query('show tables')->fetchAll(); $no_show_table = array(); //不需要显示的表 $no_show_field = array(); //不需要显示的字段 //取得所有的表名 foreach ($table_result as $row) { if(!in_array($row[0],$no_show_table)){ $tables[]['TABLE_NAME'] = $row[0]; } } //替换所以表的表前缀 if(@$_GET['prefix']){ $prefix = 'oa'; foreach($tables as $key => $val){ $tableName = $val['TABLE_NAME']; $string = explode('_',$tableName); if($string[0] != $prefix){ $string[0] = $prefix; $newTableName = implode('_', $string); mysqli_query('rename table '.$tableName.' TO '.$newTableName); } } echo "替换成功！";exit(); } //循环取得所有表的备注及表中列消息 foreach ($tables as $k=>$v) { $sql = 'SELECT * FROM '; $sql .= 'INFORMATION_SCHEMA.TABLES '; $sql .= 'WHERE '; $sql .= "table_name = '{$v['TABLE_NAME']}' AND table_schema = '{$database}'"; $table_result = $pdo->query($sql)->fetchAll(); 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 = '{$database}'"; $fields = array(); $field_result = $pdo->query($sql)->fetchAll(); foreach ($field_result as $t) { $fields[] = $t; } $tables[$k]['COLUMN'] = $fields; } $html = ''; //循环所有表 foreach ($tables as $k=>$v) { $html .= '

' . ($k + 1) . '、' . $v['TABLE_COMMENT'] .' （'. $v['TABLE_NAME']. '）

'."\n"; $html .= ' '."\n"; $html .= ' '."\n"; $html .= ' '."\n"; $html .= ' '."\n"; $html .= ' '."\n"; $html .= ' '."\n"; $html .= ' '."\n"; $html .= ' '."\n"; $html .= ' '."\n"; $html .= ' '."\n"; foreach ($v['COLUMN'] as $f) { if(@!is_array($no_show_field[$v['TABLE_NAME']])){ $no_show_field[$v['TABLE_NAME']] = array(); } if(!in_array($f['COLUMN_NAME'],$no_show_field[$v['TABLE_NAME']])){ $html .= ' '."\n"; $html .= ' '."\n"; $html .= ' '."\n"; $html .= ' '."\n"; $html .= ' '."\n"; $html .= ' '."\n"; $html .= ' '."\n"; $html .= ' '."\n"; } } $html .= ' '."\n"; $html .= '

字段名	数据类型	默认值	允许非空	自动递增	备注
' . $f['COLUMN_NAME'] . '	' . $f['COLUMN_TYPE'] . '	' . $f['COLUMN_DEFAULT'] . '	' . $f['IS_NULLABLE'] . '	' . ($f['EXTRA']=='auto_increment'?'是':' ') . '	' . $f['COLUMN_COMMENT'] . '

'."\n"; } ?> 数据库数据字典生成代码

数据库数据字典

Generated by Bo-blog 2.1.1 Release