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);

?>