Untitled

<!DOCTYPE html>
<html lang="pl">

<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <meta http-equiv="X-UA-Compatible" content="ie=edge">
    <title>Licznerski</title>

</head>

<body>
<a href="index.php">Strona głowna </a><br>
<br><br>

  <form style="float:left;" method="POST" action="dodaj.php">
            Wartosc X1: <input type="text" name="x1" /><br />
            Wartosc X2: <input type="text" name="x2" /><br />
            Wartosc X3: <input type="text" name="x3" /><br />
            Wartosc X4: <input type="text" name="x4" /><br />
            Wartosc X5: <input type="text" name="x5" /><br />
    <br><br>
    Wentylator:<br>
            <input type="radio" name="wentylator" value="0">wyłączony<br>
            <input type="radio" name="wentylator" value="1">50%<br>
            <input type="radio" name="wentylator" value="2">100%<br><br>

            <input type="checkbox" name="pozar">Alarm pożarowy<br><br>
            <input type="checkbox" name="dym">Alarm dymu<br><br>
            <input type="checkbox" name="woda">Alarm poziomu wody<br><br>

            <input type="submit" value="Wyslij">
</form>

 <?php
    $dbhost = "serwer1976179.home.pl";
    $dbuser = "31577296_uslugi";
    $dbpassword = "Okulary123/";
    $dbname = "31577296_uslugi";

    $polaczenie = mysqli_connect($dbhost, $dbuser, $dbpassword, $dbname);
    if (!$polaczenie) {
        echo "Błąd połączenia z MySQL." . PHP_EOL;
        echo "Errno: " . mysqli_connect_errno() . PHP_EOL;
        echo "Error: " . mysqli_connect_error() . PHP_EOL;
        exit;
    }

$pomiary = mysqli_query($polaczenie, "SELECT * FROM pomiary") or die("Błąd zapytania do bazy: $dbname");

$x1 = $_POST['x1'];
$x2 = $_POST['x2'];
$x3 = $_POST['x3'];
$x4 = $_POST['x4'];
$x5 = $_POST['x5'];

if ($x1 && $x2 && $x3 && $x4 && $x5) {
            $zapytanie = "INSERT INTO pomiary (x1, x2, x3, x4, x5) VALUES ('".$x1."', '" . $x2 . "', '" . $x3 . "', '" . $x4. "', '" . $x5 . "')";
$polaczenie->query($zapytanie);
}

   print  "Pomiary: ";
   print '<table style="margin-left: 280px;"  border=1>';
   print "<TR><TD>x1</TD><TD>x2</TD><TD>x3</TD><TD>x4</TD><TD>x5</TD><TD>data</TD></TR>\n";

 while ($wiersz = mysqli_fetch_array($pomiary)) {
$x1 = $wiersz[1];
$x2 = $wiersz[2];
$x3 = $wiersz[3];
$x4 = $wiersz[4];
$x5 = $wiersz[5];
$data = $wiersz[6];

 print "<TR><TD>$x1</TD><TD>$x2</TD><TD>$x3</TD><TD>$x4</TD><TD>$x5</TD><TD>$data</TD></TR>\n";

}
print "</table>";


while ($wiersz = mysqli_fetch_array($awarie)) {
$wentylator = $wiersz[1];
$pozar = $wiersz[2];
$dym = $wiersz[3];
$woda = $wiersz[4];
}
?>

<br><br>
<img src='wykres.php' style="position: absolute; left: 620px; top: 30px;">

<br><br>
 <img src='plan.png'  style="position: absolute; left: 620px; top: 650px;">

<label style='position:absolute; top:700px; left:720px; font-size:25px;'> <?php print $x1; ?></label>
<label style='position:absolute; top:700px; left:1050px; font-size:25px;'> <?php print $x2; ?></label>
<label style='position:absolute; top:850px; left:720px; font-size:25px;' ><?php print $x3; ?></label>
<label style='position:absolute; top:650px; left:1300px; font-size:25px; '><?php print $x4; ?></label>
<label style='position:absolute; top:920px; left:1300px; font-size:25px;'><?php print $x5; ?></label>

<br><br><br><br><br>
<div class="view" style="position: absolute;">
<?php
if ($wentylator == 1){
    print 'Wentylator pracuje <br>';
    print '<img src="wentylator2.gif" width="150" height="150"> <br>';
}
else if ($wentylator == 0) {
    print'Wentylator nie pracuje <br>';
    print '<img src ="wentylator.png" width="150" height="150"> <br>';
}

if ($pozar == 1){
    print 'Pozar <br>';
    print '<img src="pozar.png" width="150" height="150"> <br>';
} else if ($dym == 0) {
     print 'Brak pozaru <br>';
    print '<img src="pozar2.png" width="150" height="150"> <br>';
}


if ($dym == 1){
    print 'Bardzo duzo dymu <br>';
    print '<img src="dym.gif" width="150" height="150"> <br>';
} else if ($dym == 0) {
     print 'Brak dymu <br>';
    print '<img src="dym2.png" width="150" height="150"> <br>';
}

if ($woda == 1){
    print 'Bardzo duzo wody <br>';
    print '<img src="woda.gif" width="150" height="150"> <br>';
} else if ($woda == 0) {
     print 'Brak wody <br>';
    print '<img src="woda2.png" width="150" height="150"> <br>';
}

?>
</div>

</body>

</html>