NarKampenTake2/ServerFiles/OLDnarKampen/addQuestions.php

	<h1>Lägg till frågor</h1>

<div>
<?php
        $hostname = 'localhost';
        $username = 'narKampen';
        $pass = 'IfRLzj2HJBXA9eei';
        $database = 'narKampen';

        $conn = new mysqli($hostname, $username, $pass, $database);
        if (!$conn) {
                die("Connection Failed. ". mysqli_connect_error());
        }
        mysqli_set_charset($conn,'utf8');

	$selectCategoriesSql = "SELECT * FROM category";
	$result = $conn->query($selectCategoriesSql);

	if (!$result) {
		var_dump($conn->error);
	}
	$categoryIds = array();
	echo "<table style='border:1px solid black'><th style='border: 1px solid black'>Id<th style='border: 1px solid black'>Name<th style='border: 1px solid black'>Color</th>";
	while ($row = $result->fetch_assoc()) {
		echo "<tr style='border: 1px solid black'>";
		$sHexValue = sprintf("#%02x%02x%02x", $row['r'], $row['g'], $row['b']);
		echo "<td style='border: 1px solid black'>" . $row['id']. "</td><td style='border: 1px solid black'>" . $row['name'] . "</td><td style='border: 1px solid black'><div style='background-color:$sHexValue;width:100%;height:30px'></div></td>";
		echo "</tr>";
		$categoryIds[] = array('id' => $row['id'], 'name' => $row['name']);
	}
?>
	</table>

	<p>Add new category:</p>
	<form action="/narKampen/addNewCategory.php" method="post">
		<input type='text' id='newCategoryName' name='newCategoryName' pattern='[A-Za-zÅÄÖåäö]+' title='Category Name'/>
		<input type='color' id="newCategoryColor" name='newCategoryColor' title="Category Color"/>
		<input type='submit' value="Skicka"/>
	</form>

	<p>Add new question</p>
	<form action="/narKampen/checkNewQuestion.php" method="post">
		Fråga: <input type='text' id='newQuestionText' name='newQuestionText' title='Question' />
		Svar: <input type='number' id='newQuestionAnswer' name='newQuestionAnswer' title='Answer' />
		Categori Id: <select id='newQuestionCategory' name='newQuestionCategory' title='Category Id' />
	<?php
		foreach ($categoryIds as $catId) {
			echo "<option value=" . $catId['id'] . ">" . $catId['name'] . "</option>";
		}
	?>
	</select>
		<input type='submit' value='Skicka'/>
	</form>
	
	<form action="upload.php" method="post" enctype="multipart/form-data">
		Välj fil att ladda upp: <input type="file" name="fileToUpload" id="fileToUpload">
		<input type="submit" name="submit" value="Skicka">
	</form>
</div>