Untitled

<!DOCTYPE HTML>
<html>
<head>
<title>Marek Zych</title>
  <meta charset="utf-8">
  <meta name="viewport" content="width=device-width, initial-scale=1">
  <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css">
  <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script>
  <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></script>
<style>
.error {color: #FF0000;}

table {
    border-collapse: collapse;
    width: 100%;
}

th, td {
    text-align: left;
    padding: 8px;
}

tr:nth-child(even){background-color: #f2f2f2}

</style>
</head>
<body>
<nav class="navbar navbar-default">
  <div class="container-fluid">
    <div class="navbar-header">
      <a class="navbar-brand" href="#">Marek Zych nr indeksu 104 780</a>
    </div>
    <ul class="nav navbar-nav">
      <li><a href="http://www.nielubieprogramowac.hekko24.pl">Home</a></li>
      <li class="active"><a href="/Z1/ZAD1.php">Page 1</a></li>
      <li><a href="3">Page 2</a></li>
      <li><a href="4">Page 3</a></li>
    </ul>
  </div>
</nav>

<div class="container">

<?php
$servername = "localhost";
$username = "marekzyt";
$password = "pass";
$dbname = "marekzyt_zad1";

$czas = 0;
$x = 1;

// Create connection
$conn = mysqli_connect($servername, $username, $password, $dbname);
if (!$conn) {
    die("Connection failed: " . mysqli_connect_error());
}
//$sql = 'SELECT COUNT(*) FROM zad1';
//$x = mysqli_query($conn, $sql);
//while($x >= 0)
//{
	$sql = 'SELECT Nieudane FROM zad1 WHERE $x';
	$nieudane = mysqli_query($conn, $sql);
	$sql = 'SELECT Domena FROM zad1 WHERE $x';
	$result = mysqli_query($conn, $sql);
	$resultt = (String)$result;
	$czas = ping($resultt, 80, 10);
	function ping($host, $port, $timeout)
			{
				$tB = microtime(true);
				$fP = fSockOpen($host, $port, $errno, $errstr, $timeout);
				if (!$fP) { return "down"; }
				$tA = microtime(true);
				return round((($tA - $tB) * 1000), 0)." ms";
			}
	if ($czas == "DOWN")
	{
		$nieudane = $nieudane+1;
		$sql = "UPDATE zad1 SET Nieudane='$nieudane' WHERE NR=$x";
	}
	else
	{
		$sql = "UPDATE zad1 SET Status='$czas' WHERE NR=$x";
		if (mysqli_query($conn, $sql))
		{
		}
		else
		{
			echo "Error updating record: " . mysqli_error($conn);
		}
	}
//}

//to mi wyświetla tabele ale brzydko xD

	$sql = "SELECT NR, Domena, Status, Nieudane FROM zad1";
	$result = $conn->query($sql);

if ($result->num_rows > 0) {
     output data of each row
    while($row = $result->fetch_assoc()) {
        echo "NR: " . $row["NR"]. " Domena: " . $row["Domena"]. " Status " . $row["Status"] . "<br>";
    }
} else {
    echo "0 results";
}
	mysqli_close($conn);

?>

<h2>Sprawdź aktywności serwerów</h2>
<article class="ramka">
<table class="tabela">
<tbody><tr><td class="pusty">ID</td><td class="pusty">Domena</td><td class="pusty">Osiągalność</td><td class="pusty">Niepowodzenia</td></tr>
<!-- tu chciałbym mieć swoje dane z bazy danych --><tr><td class="pole"><?php echo ?></td><td class="pole">wp.pl</td><td class="pole">OK</td><td class="pole">0</td></tr>
				</tbody></table>
			</article>

</div>
</body>
</html>