Subversion-Projekte lars-tiefland.content-management

Revision

Details | Letzte Änderung | Log anzeigen | RSS feed

Revision Autor Zeilennr. Zeile
1 lars 1 
<?
2 
	require_once "connect.php";
3 
 
4 
	function getDatabases()
5 
	{
6 
		$buffer=array();
7 
		$result=mysql_query("show databases");
8 
		while ($row = mysql_fetch_array($result))
9 
		{
10 
			$buffer[]=$row[0];
11 
		}
12 
		return $buffer;
13 
	}
14 
 
15 
	function getTables($db)
16 
	{
17 
		$buffer=array();
18 
		$result=mysql_query("show tables from $db");
19 
		while ($row = mysql_fetch_array($result))
20 
		{
21 
			$buffer[]=$row[0];
22 
		}
23 
		return $buffer;
24 
	}
25 
 
26 
	function checkTable($tab)
27 
	{
28 
		$buffer=array();
29 
		$result=mysql_query("CHECK TABLE $tab EXTENDED");
30 
		while ($row = mysql_fetch_assoc($result))
31 
		{
32 
			$buffer=$row[Msg_text];
33 
		}
34 
		return $buffer;
35 
	}
36 
 
37 
 
38 
	$buffer=array();
39 
 
40 
	foreach(getDatabases() as $db)
41 
	{
42 
		foreach(getTables($db) as $tab)
43 
		{
44 
			$buffer[$db][$tab]=checkTable($db.".".$tab);
45 
		}
46 
 
47 
	}
48 
	pre($buffer);
49 
?>