Mysql time function uses PHP code for mysql database difference comparison

Of course, you can browse it in PHPMYADMIN. But there must be some omissions after all. So I wrote a script (PHP) to compare database differences to facilitate myself. Of course, the code is very simple, so I won’t explain it. Paste the code:

Copy the code The code is as follows:

mysql_connect('localhost','root','root');
mysql_select_db(' tablea'); //Standard 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][] =$s1[0];
}
}
mysql_close();
mysql_connect('localhost ','root','root');
mysql_select_db('tableb');//The database that needs to be compared
$q2 = mysql_query("show tables");
while($s2 = mysql_fetch_array($q2)){
$name2= $s2[0];
$q3 = mysql_query("desc $name2");
while ($s3 = mysql_fetch_array($q3)) {
$aa[$name2][] =$s3[0 ];
}
}
mysql_close();
$f = $e = array();
$str = $fuhao ='';
foreach($a as $k=>$v){
if( !is_array($aa[$k])){
$e[] = $k;
}
else{
if(count($aa[$k]) <> count($v)){
foreach($v as $k1=>$v1){
if(!in_array($v1,$aa[$k])){
$f[$k][] = $v1;
}
}
}
}
}
echo "

"; 
print_r($e);//Missing table 
print_r($f);//Missing table fields 
?> 

                
                
                

                    The above introduces the PHP code for comparing the differences between mysql time function and mysql database, including the use of mysql time function. I hope it will be helpful to friends who are interested in PHP tutorials.