Subversion-Projekte lars-tiefland.content-management

<?
        require_once "connect.php";
        
        function getDatabases()
        {
                $buffer=array();
                $result=mysql_query("show databases");
                while ($row = mysql_fetch_array($result))
                {
                        $buffer[]=$row[0];
                }
                return $buffer;
        }

        function getTables($db)
        {
                $buffer=array();
                $result=mysql_query("show tables from $db");
                while ($row = mysql_fetch_array($result))
                {
                        $buffer[]=$row[0];
                }
                return $buffer;
        }

        function checkTable($tab)
        {
                $buffer=array();
                $result=mysql_query("CHECK TABLE $tab EXTENDED");
                while ($row = mysql_fetch_assoc($result))
                {
                        $buffer=$row[Msg_text];
                }
                return $buffer;
        }
        

        $buffer=array();
        
        foreach(getDatabases() as $db)
        {
                foreach(getTables($db) as $tab)
                {
                        $buffer[$db][$tab]=checkTable($db.".".$tab);
                }
                
        }
        pre($buffer);
?>