$config = [    'hotfix' => [        'host'=>'',        'port'=>'',        'account'=>'',        'password'=>'',        'database'=>'',    ],    'release' => [        'host'=>'',        'port'=>'',        'account'=>'',        'password'=>'',        'database'=>'',    ],    'master' => [        'host'=>'',        'port'=>'',        'account'=>'',        'password'=>'',        'database'=>'',    ],];function display($compare1,$compare2){    $html = '';    $html .= '
     
                  原数据库：            
                      开发站                测试站                正式站                        现数据库：            
                      开发站                测试站                正式站                        
      
      
      
';        $html .= '相比原数据库，现数据库：
      
';    return $html;}function databaseData($config,$compare){    $aaaaa = mysql_connect(        $config[$compare]['host'].':'.$config[$compare]['port'],        $config[$compare]['account'],        $config[$compare]['password']    );    mysql_select_db($config[$compare]['database']); //标准的数据库    $q = mysql_query("show tables");    while($s = mysql_fetch_array($q)){        $name = $s[0];        $q1 = mysql_query("desc $name");        while ($s1 = mysql_fetch_array($q1)) {            $a[$name]['field'][] =$s1[0];            $a[$name]['format'][] =$s1[1];        }    }    mysql_close();    return $a;}function dataCompare($a,$aa){    $f = $e = array();    $str = $fuhao ='';    foreach($a as $k=>$v){        if(!is_array($aa[$k])){            $e[] = $k;            echo "
      
       缺少表：
       $k
      
";        }        else{            foreach($v['field'] as $k1=>$v1){                if(!in_array($v1,$aa[$k]['field'])){                    $f[$k]['field'][] = $v1;                    echo "
      
       表
       ".$k."缺少字段： 
       ".$v1.""."
      
";                }else{                    if(!in_array($v['format'][$k1],$aa[$k]['format'])){                        $f[$k]['format'][] = $v['format'][$k1];                        echo "
      
       表
       ".$k."字段 
       ".$v1."修改为
       ".$v['format'][$k1].""."
      
";                    }                }            }        }    }}$compareOne = isset($_GET['db1'])?$_GET['db1']:'';$compareTwo = isset($_GET['db2'])?$_GET['db2']:'';echo display($compareOne,$compareTwo);$a = databaseData($config,$compareOne);$aa = databaseData($config,$compareTwo);dataCompare($a,$aa);