Untitled



<html>
<head>
<style>
body	{
	font-family:verdana;
	color: #090909;
	background-color: #ffffff;
	font-size: small;
	}

table {
	border-collapse: collapse;
    	border: 1px solid #ddd;
   	width: 50%;
	font-size: small;
	}

hr	{
    	border: 0;
    	border-bottom: 1px dashed #ccc;
	}


th, td {padding: 5px;}
tr:hover{background-color:#f5f5f5}


</style>
</head>
<body>

<?

error_reporting(0);
$username="db-user20403";
$password="podispass";
$servername="sql.5v.pl";
$dbname="db-user20403";


$conn = mysqli_connect($servername, $username, $password, $dbname);

if (!$conn) {
    die("Brak połaczenia z serwerem mySQL " . mysqli_connect_error());
}

$sql = "SELECT * FROM pracownicy";
$result = mysqli_query($conn, $sql);

echo $sql;
echo "<p><hr><p>";

echo "<b>Lista pracowników:</b>"."</td>";
echo "<table>";
echo "<tr bgcolor=\"#cccccc\">";
echo "<td>";
echo "PESEL:";
echo "</td>";
echo "<td>";
echo "Nazwisko:";
echo "</td>";
echo "<td>";
echo "Imie:";
echo "</td>";

if (mysqli_num_rows($result) > 0) {
      while($pracownik = mysqli_fetch_assoc($result))
	{
  	echo "<tr>";
	echo "<td>";
	echo $pracownik["pesel"];
	echo "</td>";
	echo "<td>";
	echo $pracownik["nazwisko"];
	echo "</td>";
	echo "<td>";
	echo $pracownik["imie"];
	echo "</td>";
    	}
} else {
    echo "0 results";
}


echo "</tr>";
echo "</table>";
?>