Example #1
0
	$outputlevel = "notice";
}elseif($outputlevel == "notice" || $outputlevel == "warning"){
	//do nothing.
}else{
	die("Invalid outputlevel: \"" . $outputlevel . "\".\n");
}


require_once("knj/dbconn/class_dbconn.php");
$dbconn1 = new DBConn();
if (!$dbconn1->openConn($db1[0], $db1[1], $db1[2], $db1[3], $db1[4], $db1[5])){
	die("Could not make a connection to db1: \"" . $dbconn1->query_error() . "\".\n");
}

$dbconn2 = new DBConn();
if (!$dbconn2->openConn($db2[0], $db2[1], $db2[2], $db2[3], $db2[4], $db2[5])){
	die("Could not make a connection to db2: \"" . $dbconn2->query_error() . "\".\n");
}

$tables1 = $dbconn1->getTables();
$tables2 = $dbconn2->getTables();

foreach($tables1 AS $table1){
	if ($outputlevel == "notice"){
		echo("Notice: Checking table \"" . $table1["name"] . "\".\n");
	}
	
	//Check if the table exist in db2.
	$found = false;
	foreach($tables2 AS $testtable2){
		if ($testtable2["name"] == $table1["name"]){