Subversion-Projekte lars-tiefland.content-management

<?
        require_once "connect.php";
        
        function pre($elem, $r=false)
        {
                $output=
                "<pre>".
                        htmlentities
                        (
                                print_r($elem, true)
                        ).
                "</pre>";
                
                if ($r == true)
                {
                        return $output;
                }
                else
                {
                        echo $output;
                }
        }

        
        function getTables($db="mediaran_de")
        {
                $buffer=array();
                $result=mysql_query("show tables from $db");    
                while ($zeile=mysql_fetch_assoc($result))
                {
                        $buffer[] = $db.".".$zeile[Tables_in_mediaran_de];
                }
                return $buffer;
        }
        
        function getCreateCmd($table)
        {
                $result=mysql_query("SHOW CREATE TABLE $table");        
                if ($zeile=mysql_fetch_assoc($result))
                {
                        return $zeile["Create Table"];
                }
        }
        
        
        $buffer=array();
        foreach(getTables() as $table)
        {
                $buffer[]=getCreateCmd($table);
        }

        pre($buffer);
        
?>