<?php
    $servername = "localhost";
    $username = "user";
    $password = "pass";

    // Create connection
    $conn = mysqli_connect($servername, $username, $password);

    // Check connection
    if (!$conn) {
        die("Connection failed: " . mysqli_connect_error());
    }
    echo "Connected successfully";

    mysqli_select_db($conn, "commands");

    $sql = "UPDATE module SET flag=0 WHERE node='0000' ";

    if ($conn->query($sql) === TRUE) {
            echo "</br> Record updated successfully";
        } else {
            echo "</br> Error updating record: " . $conn->error;
        }


    $sql = "UPDATE cmd SET flag=0 WHERE command='capture' ";

    if ($conn->query($sql) === TRUE) {
            echo "</br> Record updated successfully";
        } else {
            echo "</br> Error updating record: " . $conn->error;
        }


    $conn->close();

    header("location: webcam.php");
?>