2019-11-18 20:43:33 +01:00
|
|
|
|
<!DOCTYPE html>
|
|
|
|
|
<html>
|
|
|
|
|
<head>
|
|
|
|
|
<meta charset="utf-8">
|
2020-01-10 19:12:16 +01:00
|
|
|
|
<link rel="stylesheet" type="text/css" href="css/style.css" />
|
2019-11-18 20:43:33 +01:00
|
|
|
|
|
|
|
|
|
</head>
|
|
|
|
|
<body>
|
2020-01-10 19:12:16 +01:00
|
|
|
|
<div id="wrapper">
|
|
|
|
|
<div id="logo">
|
|
|
|
|
<img src="images/logo.png" />
|
|
|
|
|
</div>
|
|
|
|
|
<div id="menu">
|
|
|
|
|
<ul>
|
|
|
|
|
<li><a href="#" class="active">Strona glowna</a></li>
|
|
|
|
|
<li><a href="#">O mnie</a></li>
|
|
|
|
|
<li><a href="#">Oferta</a></li>
|
|
|
|
|
<li><a href="#">Kontakt</a></li>
|
|
|
|
|
</ul>
|
|
|
|
|
</div>
|
|
|
|
|
<div id="header">
|
|
|
|
|
<img src="images/bg_head.jpg" style="float: right" />
|
|
|
|
|
<div id="title_head">
|
|
|
|
|
<h2>Skaner kodow QR</h2>
|
|
|
|
|
<span><?php
|
2019-11-18 20:43:33 +01:00
|
|
|
|
|
|
|
|
|
$conn = new mysqli("localhost", "root", "", "komputery") or die("B<EFBFBD><EFBFBD>d");
|
|
|
|
|
|
2020-01-10 19:12:16 +01:00
|
|
|
|
$wynik = $conn->query("SELECT * FROM parametry WHERE Id = 3 ");
|
2019-11-18 20:43:33 +01:00
|
|
|
|
|
|
|
|
|
echo "<h1>Dane twojego komputera: </h1>";
|
2019-12-22 21:51:47 +01:00
|
|
|
|
echo "<br>";
|
2019-11-18 20:43:33 +01:00
|
|
|
|
|
|
|
|
|
if($wynik->num_rows > 0){
|
|
|
|
|
|
2020-01-10 19:12:16 +01:00
|
|
|
|
echo "<table style='border-spacing: 10px; border-collapse: collapse;' border='3'>";
|
2019-11-18 20:43:33 +01:00
|
|
|
|
echo "<tr>";
|
2020-01-10 19:12:16 +01:00
|
|
|
|
|
2019-11-18 20:43:33 +01:00
|
|
|
|
echo "<th>Procesor</th>";
|
|
|
|
|
echo "<th>Plyta_Glowna</th>";
|
|
|
|
|
echo "<th>Pamiec_Ram</th>";
|
|
|
|
|
echo "<th>Dysk</th>";
|
|
|
|
|
echo "<th>Karta_Graficzna</th>";
|
|
|
|
|
echo "</tr>";
|
|
|
|
|
|
2019-12-22 21:51:47 +01:00
|
|
|
|
|
|
|
|
|
|
2019-11-18 20:43:33 +01:00
|
|
|
|
while( $wiersz = $wynik->fetch_assoc() ){
|
|
|
|
|
echo "<tr>";
|
|
|
|
|
|
2020-01-10 19:12:16 +01:00
|
|
|
|
|
2019-11-18 20:43:33 +01:00
|
|
|
|
echo "<td>" . $wiersz["Procesor"] . "</td>";
|
|
|
|
|
echo "<td>" . $wiersz["Plyta_Glowna"] . "</td>";
|
|
|
|
|
echo "<td>" . $wiersz["Pamiec_Ram"] . "</td>";
|
|
|
|
|
echo "<td>" . $wiersz["Dysk"] . "</td>";
|
|
|
|
|
echo "<td>" . $wiersz["Karta_Graficzna"] . "</td>";
|
|
|
|
|
|
|
|
|
|
echo "</tr>";
|
2019-12-22 21:51:47 +01:00
|
|
|
|
|
|
|
|
|
|
2019-11-18 20:43:33 +01:00
|
|
|
|
}
|
2019-12-22 21:51:47 +01:00
|
|
|
|
echo "</table>";
|
|
|
|
|
echo "<br>";
|
|
|
|
|
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
else {
|
|
|
|
|
echo "Nie ma nic w bazie danych";
|
|
|
|
|
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
2020-01-10 19:12:16 +01:00
|
|
|
|
$wynik = $conn->query("SELECT * FROM uzytkownicy WHERE Id = 3 ");
|
2019-12-22 21:51:47 +01:00
|
|
|
|
|
|
|
|
|
echo "<h1>Informacje o uzytkowniku: </h1>";
|
|
|
|
|
|
|
|
|
|
if($wynik->num_rows > 0){
|
|
|
|
|
|
2020-01-10 19:12:16 +01:00
|
|
|
|
echo "<table style='border-spacing: 10px; border-collapse: collapse;' border='3'>";
|
2019-12-22 21:51:47 +01:00
|
|
|
|
echo "<tr>";
|
|
|
|
|
echo "<th>Imie</th>";
|
|
|
|
|
echo "<th>Nazwisko</th>";
|
|
|
|
|
echo "<th>Data wydania</th>";
|
|
|
|
|
echo "<th>Data zakonczenia leasingu</th>";
|
|
|
|
|
echo "<th>Dzial</th>";
|
|
|
|
|
echo "</tr>";
|
|
|
|
|
|
|
|
|
|
|
2019-11-18 20:43:33 +01:00
|
|
|
|
|
2019-12-22 21:51:47 +01:00
|
|
|
|
while( $wiersz = $wynik->fetch_assoc() ){
|
|
|
|
|
echo "<tr>";
|
|
|
|
|
|
|
|
|
|
echo "<td>" . $wiersz["Imie"] . "</td>";
|
|
|
|
|
echo "<td>" . $wiersz["Nazwisko"] . "</td>";
|
|
|
|
|
echo "<td>" . $wiersz["Data_wydania"] . "</td>";
|
|
|
|
|
echo "<td>" . $wiersz["Data_zak_lea"] . "</td>";
|
|
|
|
|
echo "<td>" . $wiersz["Dzial"] . "</td>";
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
echo "</tr>";
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
}
|
2019-11-18 20:43:33 +01:00
|
|
|
|
echo "</table>";
|
|
|
|
|
|
2019-12-22 21:51:47 +01:00
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
else {
|
2019-11-18 20:43:33 +01:00
|
|
|
|
echo "Nie ma nic w bazie danych";
|
|
|
|
|
}
|
|
|
|
|
|
2019-12-22 21:51:47 +01:00
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
2019-11-18 20:43:33 +01:00
|
|
|
|
$conn->close();
|
|
|
|
|
|
2020-01-10 19:12:16 +01:00
|
|
|
|
?></span>
|
|
|
|
|
<p>
|
|
|
|
|
<br />
|
|
|
|
|
<a href="#">Klik</a>
|
|
|
|
|
<a href="#" class="margin1">OK</a>
|
|
|
|
|
</p>
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
</div>
|
|
|
|
|
<div id="footer">
|
|
|
|
|
<p>© Wszelkie prawa zastrzezone. <br /> Projekt: Mikolaj Wojdylo s439508</a></p>
|
|
|
|
|
</div>
|
|
|
|
|
</body>
|
|
|
|
|
</html>
|
2019-11-18 20:43:33 +01:00
|
|
|
|
|
2020-01-10 19:12:16 +01:00
|
|
|
|
</body>
|