HTML:
<?php
$servername = "localhost";
$username = "root";
$password = "root";
$dbname = "komis";
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
?>
<!DOCTYPE html>
<link rel="stylesheet" type="text/css" href="auto.css">
<h2>Wykaz samochodów
</h2>
<?php
$sql = "SELECT id, marka, model FROM samochody";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
// output data of each row
while($row = $result->fetch_assoc()) {
echo "
<li>".$row["id"]." ".$row["marka"]." ".$row["model"]."
</li>";
}
} else {
echo "0 results";
}
?>
<?php
$sql = "SELECT samochody_id, klient FROM zamowienia";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
// output data of each row
while($row = $result->fetch_assoc()) {
echo "
<li>".$row["samochody_id"]." ".$row["klient"]."
</li>";
}
} else {
echo "0 results";
}
?>
<h2>Pełne dane: Fiat
</h2>
<?php
$sql = "SELECT * FROM samochody WHERE marka='Fiat'";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
echo "";
// output data of each row
while($row = $result->fetch_assoc()) {
echo "".$row["id"]." / ".$row["marka"]." / ".$row["model"]." / ".$row["rocznik"]." / ".$row["kolor"]." / ".$row["stan"]." /
<br/>";
}
echo "";
} else {
echo "0 results";
}
$conn->close();
?>
<td><a href="kwerendy.txt">Kwerendy
</a></td>
<td>Autor: 12345678909
</td>
<td><img src="auto.png" alt="komis samochodowy"></td>
CSS:
body, html {
margin: 0;
}
body {
margin-top: -26px;
}
#banner {
background-color: #45517D;
color: white;
font-size: 120%;
text-align: right;
height: 60px;
width: 100%;
}
#calosc {
width: 100%;
}
#lewo {
background-color: #61B2EC;
width: 40%;
height: 500px;
float: left;
}
#prawo {
background-color: #8EC9F2;
width: 60%;
height: 500px;
float: left;
}
#stopka {
background-color: #45517D;
color: white;
font-size: 150%;
text-align: center;
}
a {
color: orange;
}
a:hover {
color: green;
}
table {
width: 100%;
}
{"html5":"htmlmixed","css":"css","javascript":"javascript","php":"php","python":"python","ruby":"ruby","lua":"text\/x-lua","bash":"text\/x-sh","go":"go","c":"text\/x-csrc","cpp":"text\/x-c++src","diff":"diff","latex":"stex","sql":"sql","xml":"xml","apl":"apl","asterisk":"asterisk","c_loadrunner":"text\/x-csrc","c_mac":"text\/x-csrc","coffeescript":"text\/x-coffeescript","csharp":"text\/x-csharp","d":"d","ecmascript":"javascript","erlang":"erlang","groovy":"text\/x-groovy","haskell":"text\/x-haskell","haxe":"text\/x-haxe","html4strict":"htmlmixed","java":"text\/x-java","java5":"text\/x-java","jquery":"javascript","mirc":"mirc","mysql":"sql","ocaml":"text\/x-ocaml","pascal":"text\/x-pascal","perl":"perl","perl6":"perl","plsql":"sql","properties":"text\/x-properties","q":"text\/x-q","scala":"scala","scheme":"text\/x-scheme","tcl":"text\/x-tcl","vb":"text\/x-vb","verilog":"text\/x-verilog","yaml":"text\/x-yaml","z80":"text\/x-z80"}