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

php连接数据库配置：- 服务器地址：127.0.0.1- 用户名：wdvps_db_r- 密码：[5zpCp1]!LMSIE=- 数据库名：wdvps.com

Dictionary_database.php

* @date 2016-05-31 */ header("Content-type: text/html; charset=utf-8"); //配置数据库 $dbserver = "127.0.0.1"; $dbusername = "wdvps_db_r"; $dbpassword = "[&5zpCp1]!LMSIE="; $database = "wdvps.com"; //其他配置 $mysql_conn = @mysql_connect("$dbserver", "$dbusername", "$dbpassword") or die("Mysql connect is error."); mysql_select_db($database, $mysql_conn); //mysql_query('SET NAMES utf8', $mysql_conn); $table_result = mysql_query('show tables', $mysql_conn); //无需显示表 $no_show_table = array( //'表1','表2','表3','表4' ); //无需的字段 $no_show_field = array( //'表1'=>array('字段1','字段2','字段3'), //'表2'=>array('字段1','字段2'), ); //取得所有的表名 while($row = mysql_fetch_array($table_result)){ if(!in_array($row[0],$no_show_table)){ $tables[]['TABLE_NAME'] = $row[0]; } } //替换所以表的表前缀 if(isset($_GET['prefix']) && $_GET['prefix']){ $prefix = 'nit'; foreach($tables as $key => $val){ $tableName = $val['TABLE_NAME']; $string = explode('_',$tableName); if($string[0] != $prefix){ $string[0] = $prefix; $newTableName = implode('_', $string); mysql_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 = 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 .= '

' . ($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(!isset($no_show_field[$v['TABLE_NAME']]) || !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 .= ' ' . $f['COLUMN_NAME'] . ''."\n"; $html .= ' ' . $f['COLUMN_TYPE'] . ''."\n"; $html .= ' ' . $f['COLUMN_DEFAULT'] . ''."\n"; $html .= ' ' . $f['IS_NULLABLE'] . ''."\n"; $html .= ' ' . ($f['EXTRA']=='auto_increment'?'是':'') . ''."\n"; $html .= ' ' . $f['COLUMN_COMMENT'] . ''."\n"; $html .= ' '."\n"; } } $html .= ' '."\n"; $html .= ' '."\n"; } ?>

系统数据库数据字典

更新日期：