<?php

    $servername = "localhost";
    $username = "admin";
    $password = "admin";
    $dbname = "klaabr";

// Create connection
    $conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
    if ($conn->connect_error) {
        die("Connection failed: " . $conn->connect_error);
    }

    $sql = "SELECT * FROM marsrutas1";
    $result = $conn->query($sql);
    echo "<div class='col-sm-12 car'>";
    if ($result->num_rows > 0) {
        // output data of each row
        $i=0;
        while($row = $result->fetch_assoc()) {
            if ($row["Signalas1"] > 0) {
                $i++;
                echo "<div class=\"col-sm-2\">";
                echo "<div id=\"$i\" class=\"red\">" . $row["Signalas1"] . "</div>";
                echo "</div>";
            }
            else{
                $i++;
                echo "<div class=\"col-sm-2\">";
                echo "<div id=\"$i\" class=\"green\">" . $row["Signalas1"] . "</div>";
                echo "</div>";
            }
        }
        echo "</div>";
    } else {
        echo "0 results";
    }



    $value1 = rand(0, 1);
    $value2 = rand(0, 1);
    $value3 = rand(0, 1);
    $value4 = rand(0, 1);
    $value5 = rand(0, 1);
    $value6 = rand(0, 1);

    $sql = "UPDATE marsrutas1
            SET Signalas1 = CASE id
            WHEN 1 THEN $value1
            WHEN 2 THEN $value2
            WHEN 3 THEN $value3
            WHEN 4 THEN $value4
            WHEN 5 THEN $value5
            WHEN 6 THEN $value6
            END
            WHERE id IN (1,2,3,4,5,6)";

    $result = $conn->query($sql);



    $conn->close();
?>