<?php

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

$conn = mysqli_connect($servername, $username, $password, $dbname);
if (!$conn) {
    die("Connection failed: " . mysqli_connect_error());
}

$sql_state = "SELECT name, info FROM alarminfo WHERE name LIKE 'state'";
$row_state = mysqli_fetch_assoc(mysqli_query($conn, $sql_state));
echo "Alarm " . $row_state["name"]. " is " . "<b>{$row_state["info"]}</b>" . "<br>";

$sql_status = "SELECT name, info FROM alarminfo WHERE name LIKE 'status'";
$row_status = mysqli_fetch_assoc(mysqli_query($conn, $sql_status));
if($row_state["info"] == "active")
echo "Alarm " . $row_status["name"]. " is " . "<b>{$row_status["info"]}</b>" . "<br>";

$v1="";
if (isset($_GET["var1"]))

{
    $v1=$_GET["var1"];
    if($v1 == "triggered")
    {$sql = "update alarminfo set info = 'triggered' where name like 'status'";
        $conn->query($sql);
        header("Refresh:0; url=test.php");
    }
    elseif($v1 == "untriggered")
    {
        $sql = "update alarminfo set info = 'untriggered' where name like 'status'";
        $conn->query($sql);
        header("Refresh:0; url=test.php");
    }
}

//print_r($_GET);
mysqli_close($conn);
?>