$str_conn="firebird:host=localhost;dbname=$dbname;charset=UTF8";
$dbh = new PDO($str_conn, $dbuser, $dbpassword);

$sth = $dbh->prepare('INSERT INTO MainRoom VALUES(?,20,20)');


$humidity = $_GET['humidity'];
$temperature = $_GET['temperature'];


$sth->bindValue(1, time());
//$sth->bindParam(2, $humidity);
//$sth->bindParam(3, $temperature);

echo "$humidity $temperature";

$sth->execute();
$dbh->commit();

echo "done";

$sql = 'select count(*) from mainroom';
$count = $dbh->query($sql);
print_r ($count->fetch());

try
{
$dbh = new PDO($str_conn, $dbuser, $dbpassword);

$sth = $dbh->prepare('INSERT INTO MainRoom VALUES(?,20,20)');


$humidity = $_GET['humidity'];
$temperature = $_GET['temperature'];


$sth->bindValue(1, time());
//$sth->bindParam(2, $humidity);
//$sth->bindParam(3, $temperature);

echo "$humidity $temperature";

$sth->execute();
$dbh->commit();
}
catch(PDOException $e)
{
    echo $e->getMessage();
}

echo "done";

$sql = 'select count(*) from mainroom';
$count = $dbh->query($sql);
print_r ($count->fetch());