<?php
	// mysqli_connect
	$link = mysqli_connect("localhost", "root", "", "test");

	if (!$link)
	{
		echo "Error";
	}
	else
	{
		// mysqli_fetch_assoc
		$query = "SELECT * FROM tagok";

		$tagokSQL = array();
		if ($result = mysqli_query($link, $query))
		{
			echo "<table>";
			/* fetch associative array */
			while ($row = mysqli_fetch_assoc($result))
			{
				echo "<tr>";
				echo "<td>" . $row["ID"] . "</td>";
				echo "<td>" . $row["Nev"] . "</td>";
				echo "<td>" . $row["Lakhely"] . "</td>";
				echo "<td>" . $row["Tagdij"] . "</td>";
				echo "</tr>";
				array_push($tagokSQL, $row);
			}
			echo "</table>";
			/* free result set */
			mysqli_free_result($result);
		}
	}

	echo "<table>";

	$fn = fopen("tagok.xml","r");
	fgets($fn);
	$tagokXML = array();
	while(! feof($fn))  {
		$ID = fgets($fn);
		$Nev = fgets($fn);
		$Lakhely = fgets($fn);
		$Tagdij = fgets($fn);

		echo "<tr>";
		echo "<td>" . $ID . "</td>";
		echo "<td>" . $Nev . "</td>";
		echo "<td>" . $Lakhely . "</td>";
		echo "<td>" . $Tagdij . "</td>";
		echo "</tr>";

		$tag = array($ID, $Nev, $Lakhely, $Tagdij);
		array_push($tagokXML, $tag);
	}
	fclose($fn);
	echo "</table>";

	echo "<table>";
	for($i = 0; $i < count($tagokSQL); $i++)
	{
		if((str_pad($tagokSQL[$i]["ID"], 3, '0', STR_PAD_LEFT) != $tagokXML[$i][0])
			|| ($tagokSQL[$i]["Nev"] != $tagokXML[$i][1])
			|| ($tagokSQL[$i]["Lakhely"] != $tagokXML[$i][2])
			|| ($tagokSQL[$i]["Tagdij"] != $tagokXML[$i][3]))


			echo str_pad($tagokSQL[$i]["ID"], 3, '0', STR_PAD_LEFT);
			echo "\t";
			echo $tagokXML[$i][0];
			echo "<br>";

			echo $tagokSQL[$i]["Nev"];
			echo "\t";
			echo $tagokXML[$i][1];
			echo "<br>";

			echo $tagokSQL[$i]["Lakhely"];
			echo "\t";
			echo $tagokXML[$i][2];
			echo "<br>";

			echo $tagokSQL[$i]["Tagdij"];
			echo "\t";
			echo $tagokXML[$i][3];
			echo "<br>";

			$flattened = $tagokSQL[$i];
			array_walk($flattened, function(&$value, $key) {
				$value = "{$value}";
			});

			echo "<tr>";
			echo "<td>" . implode(' | ', $flattened) . "</td>";
			echo "<td>" . implode(" | ", $tagokXML[$i]). "</td>";
			echo "</tr>";
		}
	}
	echo "</table>";

	//


?>