生成数据字典的一个小功能，界面相对简介，phpmyadmin生成的界面比较难看 无 ?php/** * 生成mysql数据字典 */header(content-type: text/html; charset=utf-8);//配置数据库$dbserver = 127.0.0.1;$dbusername = root;$dbpassword = ;$database = ;
生成数据字典的一个小功能，界面相对简介，phpmyadmin生成的界面比较难看 array('cateid3'), 'czzj_tag' => array('count_bang','count_photo'), 'czzj_event' => array('count_userwish'),); //无需的字段//取得所有的表名while($row = mysql_fetch_array($table_result)){ if(!in_array($row[0],$no_show_table)){ $tables[]['table_name'] = $row[0]; }}//替换所以表的表前缀if($_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(!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;}?>南昌工程学院志愿服务系统数据库数据字典 南昌工程学院志愿服务系统数据库数据字典