<?php
	include '../config.php'; 
	$link = mysqli_connect($servername, $username, $password, $dbname);

	if ($link === false) {
		die("ERROR: Could not connect. " . mysqli_connect_error());
	}

	$tittel = mysqli_real_escape_string($link, $_POST['tittel']);
	$undertittel = mysqli_real_escape_string($link, $_POST['undertittel']);
	$tekst = mysqli_real_escape_string($link, $_POST['tekst']);

	$sql = "INSERT INTO nyheter (tittel, undertittel, tekst) VALUES ('$tittel', '$undertittel', '$tekst')";

	if (mysqli_query($link, $sql)) {
		header("location: ../admin.php");
	} else {
		echo "ERROR: Was not able to execute $sql " . mysqli_error($link);
	}

?>

<?php
header('Content-type: text/html; charset=UTF-8');

		include 'connect.php';

		mysql_query ("set character_set_results='utf8'"); 
		$sql = "SELECT * FROM nyheter order by `id` desc limit 2";
		$result = $conn->query($sql);

		if ($result->num_rows > 0) {
			while ($row = $result->fetch_assoc()) {
				echo "<h2>" . $row['tittel'] 		. "</h2>";
				echo "<h3>" . $row['undertittel'] 	. "</h3>";
				echo "<hr>";
				echo "<p>"  . $row['tekst']			. "</p>";
				echo "<h4>Skrevet av: " . $row['forfatter']		. "</h4>";
				echo "<br>";

			}

		} else {
			echo "0 results";
		}
?>