<?php
	//Setja login info í breytur
	$hostName = "localhost";
	$userName = "root";
	$password = "";
	//tengjumst gagngrunnsþjóninum
	$dbConnect = mysql_connect($hostName, $userName, $password)
		or die ("Sorry, can´t connect!");
	//Veljum gagnagrunn
	mysql_select_db("symbol", $dbConnect)
		or die ("Can´t find database!");
	//Skrifum upplýsingar inn í grunninn
	mysql_query('INSERT into Land ("")', $dbConnect)
		or die ("Error, can´t write into database!");
	//Lesum upplýsingar úr gagnagrunni
	$myData = mysql_query("SELECT * from Land", $dbConnect);
	//Skrifum upplýsingar út
	print "<h3>Upplýsingar úr grunni</h3>";
	while ($row = mysql_fetch_row($myData)) {
		foreach($row as $field) {
			print $field;
		}
		print "<br/>";
	}

	$myData = mysql_query("SELECT * from members", $dbConnect);
	print "<h3>Fancy pants uppsetning</h3>";
	print "<table border=\"1\">\n";
	print "<tr><td>ID</td><td>First Name</td><td>Last Name</td><td>Email</td><td>Date joined</td></tr>";
	while ($row = mysql_fetch_row($myData)) {
		print "<tr>";
		foreach($row as $field) {
			print "<td>".$field."</td>";
		}
		print "</tr>";
	}
	print "</table>";
	print "<h3>Veljum ákveðin field út úr töflu</h3>";
	$myData = mysql_query("SELECT first_name, email from members", $dbConnect);

	print "<table border=\"1\">\n";
	print "<tr><td>First Name</td><td>Email</td></tr>";
	while ($row = mysql_fetch_row($myData)) {
		print "<tr>";
		foreach($row as $field) {
			print "<td>".$field."</td>";
		}
		print "</tr>";
	}
	print "</table>";
	//Lokum tengingu við gagnagrunnsþjón
	mysql_close($dbConnect);
?>