<?php

$question = $_POST['newQuestionText'];
$answer = $_POST['newQuestionAnswer'];
$catId = $_POST['newQuestionCategory'];

        $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');

	$newQuestionSql = "INSERT INTO questions (question, answer) VALUE ('$question', $answer)";
	$result = $conn->query($newQuestionSql);

	if (!$result) {
		echo $conn->error;
	}

	$questionId = $conn->insert_id;
	$questionToCategorySql = "INSERT INTO questionToCategory (questionId, categoryId) VALUES ($questionId, $catId)";

	$result = $conn->query($questionToCategorySql);
	if (!$result) {
		echo $conn->error;
	}

	header("Location: http://nordh.xyz/narKampen/addQuestions.php");
?>