Untitled

<!DOCTYPE html>
<html>
<head>
    <title>INPUT</title>
</head>
<body>


<?php
// STUPID PASSWORD
if($_GET['pw'] != '12345') die('ERROR');
?>


<!-- CREATE TABLE FOR VALUES -->
<table border="1px" cellpadding="5px" cellspacing="0">
        <tr>
            <th>ID</th>
            <th>Aika</th>
            <th>Arvo</th>
            <th>Sijainti</th>
        </tr>

<?php


// READ GET URL AND SAVE VALUES.
if(isset($_GET['arvo']) && isset($_GET['sijainti'])) {

    $dbname = 'sensors';
    $dbuser = 'root';
    $dbpass = 'mysliq';


// GOT VALUES TRY CONNECTING TO DATABASE
try {
    $db = new PDO("mysql:host=localhost;dbname=$dbname", $dbuser, $dbpass);
    $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch(PDOException $e) {
    echo $e->getMEssage();
    die();
}

    // VARIABLES
    $arvo = $_GET['arvo'];
    $sijainti = $_GET['sijainti'];


    // PRINT AS DEBUG
    echo 'Kohteessa:  ' . $sijainti . ' saatiin arvoksi: ' . $arvo .'<br>';


    // INSERT VALUES TO DB
    $dbQuery = "INSERT INTO `values`(`arvo`, `sijainti`) VALUES (:arvo,:sijainti)";
    $dbPrep = $db->prepare($dbQuery);
    $dbExec = $dbPrep->execute(array(":arvo"=>$arvo,":sijainti"=>$sijainti));


    // SUCCESS ON DB INSERT?
    if($dbExec)
    {
        echo 'Data inserted';
    }else{
        echo 'DATA INSERT FAILED';
    }


// READ DATABASE
    $stmt = $db->prepare("SELECT * FROM `values`");
    $stmt->execute();
    $result = $stmt->fetchAll();
    foreach ($result as $row) {
?>
        <!-- PRINT VALUES TO TABLE -->
        <tr>
            <td><?=$row['id'];?></td>
            <td><?=$row['aika'];?></td>
            <td><?=$row['arvo'];?></td>
            <td><?=$row['sijainti'];?></td>
        </tr>
        <?php
}
}
?>
</table>
</body>
</html>