数据字典生成器-PHP源码

数据字典生成器-PHP源码

只需要修改
//配置数据库
$dbserver = "localhost";
$dbusername = "root";
$dbpassword = "";
$database = "test";
然后访问这个php文件即可

1. [代码][PHP]代码

 $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 .= '				'."\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";
}
?>