NarKampenTake2/ServerFiles/OLDnarKampen/checkNewQuestion.php

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

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

	preg_match_all("/[A-Za-zÅÄÖåäö]{5,}/",$question,$matches);

	$w = " WHERE";
	foreach ($matches[0] as $match) {
		$w .= " question like '%".$match."%' OR";
	}

	$w = substr($w,0,-3);

	$checkQuestionSql = "SELECT * FROM questions $w";

	$result = $conn->query($checkQuestionSql);

	while ($row = $result->fetch_assoc()) {
		echo "<strong>Fråga:</strong> " . $row['question'] . " <strong>Svar: </strong>" . $row['answer'] . "</br>";
	}

	echo "<p>Finns den nya frågan med bland ovan? </p>";
	echo "<form action='/narKampen/addNewQuestion.php' method='post'>";
	echo "<input type='text' id='newQuestionText' name='newQuestionText' value='" . $question . "'/>";
	echo "<input type='number' id='newQuestionAnswer' name='newQuestionAnswer' value='" . $answer . "'/>";
	echo "<input type='hidden' id='newQuestionCategory' name='newQuestionCategory' value='" . $category . "'/>";
	echo "<input type='submit' />";
	echo "</form>";

?>