<?php

    $servername = "localhost";
    $username = "root";
    $password = "";
    $dbname = "hardware_relay";

if(isset($_GET["room"]) && isset($_GET["status"]))
{
    $db=new PDO("mysql:host=" .$servername. "; dbname=" . $dbname, $username, $password);

    $page=$db->prepare("UPDATE `room_pin_relay` SET `status`=" . $_GET["status"] . " WHERE `room_id`=" . $_GET["room"]);
    $page->execute();
    echo $page->rowCount();
}
else
{
    echo "no params";
}
?>