修复mysql所有的表-PHP源码

修复mysql所有的表-PHP源码

true));
 			$conn->exec("SET NANMES".$charset);
 		}catch(PDOException $e){
 		
 			echo "Error!:".$e->getMessage()."
";
 			die('db connect failed ...');
 		}
 		$arr=$conn->query("show tables");
 		$arr1=$arr->fetchAll(PDO::FETCH_ASSOC);
 		foreach ($arr1 as $a){
 			foreach ($a as $a1){
 				$conn->query("repair table  ".$a1);
 				echo "table ：".$a1." is repair..
";
 			}
 		}
 		echo "task complete !";
 	}	
 }
 //调用方法
   $too=new tools();
   $too->repair_mysql_tables("root", "", "fangjia");
 ?>