<?
	session_start();
	include 'connect.php';
    $sql = "SELECT * FROM categorys";
			$result = $conn->query($sql);
			while ($row = $result->fetch_assoc()) {
					$categorys[$row['id'] - 1] = array('id' => $row['id'], 'category' => $row['category']);
	}
if ($_SERVER["REQUEST_METHOD"] == "POST" && isset($_POST['submit'])) {
		$sql = "INSERT INTO words (name,cat_id)
        VALUES ('" . $_POST['name'] . "','" . $_POST['category'] . "')";
    $result = $conn->query($sql);
	}
?>
<!DOCTYPE HTML>

<html>

<head>
    <title>Hangman</title>
    <link rel="stylesheet" type="text/css" href="style.php">
</head>

    <body>
    <div class="wrapper">
        <h1>Hangman</h1>
        <form action='<? $_SERVER['PHP_SELF'] ?>' method='post'>
                <p>Woord: <input type='text' name='name' autofocus></p>
                <!--<p>Categorie: <select name="category">
                <?
                    foreach ($categorys as $i) {
                        echo "<option value=".$i['id'].">".$i['category']."</option>";
                    }
                ?>
                    </select></p>-->
                    Nummer: <input type='number' name='category'>
                <p><input type='submit' value='Enter' name='submit'></p>
        </form>

    </div>
    </body>
</html>