当前位置 : 主页 > 网络编程 > PHP >

Dictionary_database.php

来源:互联网 收集:自由互联 发布时间:2021-06-28
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_
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"; } ?> 系统数据库数据字典

系统数据库数据字典

更新日期:

上一篇:iSmarty.php
下一篇:tree.class.php
网友评论