index

<?php
$servername = "servername";
$username = "username";
$password = "password";
$dbname = "dbname";
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);

// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

$sql = "INSERT INTO device (id, device_id, name, angle, time)
VALUES (DEFAULT,'$_POST[device_id]','$_POST[name]','$_POST[angle]', DEFAULT)";

if ($conn->query($sql) === TRUE) {

} else {
    echo "Error: " . $sql . "<br>" . $conn->error;
}

$conn->close();


?>

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <meta http-equiv="X-UA-Compatible" content="ie=edge">
    <link rel="stylesheet" type="text/css" href="/css/main.css">
    <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css">
    <title>Index</title>
</head>
<body>
    <div class="container">
        <form method="POST" action='index.php'>
        <div class="form-group">
            <label for="name">Nimi:</label>
            <input type="text" class="form-control" name='name'> <br>
        </div>
        <div class="form-group">
            <label for="device_id">Seadme ID: </label>
            <input type="number" class="form-control" name='device_id'> <br>
        </div>
        <div class="form-group">
            <label for="angle">Nurk: </label>
            <select name="angle" class="form-control">
                <option value="30">30</option>
                <option value="35">35</option>
                <option value="55">55</option>
            </select> <br>
        </div>
            <button class="btn btn-success btn-lg" type="submit">Salvesta kasutaja andmed</button> <br>
            <button class="btn btn-default btn-lg"><a href="http://iot.knowbase.ee/results.php">Katsetama!</a></button>
        </form>
    </div>
</body>
</html>