connect_error) {
die("Polanczenie nie udane: " . $conn->connect_error);
}
Echo "Zadanie 1
";
$sql = "SELECT Rocznik FROM auta WHERE Kolor='Czerwony'";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
while($row = $result->fetch_assoc()) {
echo "Rocznik " .$row["Rocznik"]. "
";
}
} else {
echo "0 wynikow";
}
Echo "Zadanie 2
";
$sql = "SELECT Marka, Model FROM auta WHERE Rocznik >='2012' AND Rocznik <='2020'";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
while($row = $result->fetch_assoc()) {
echo "Marka: " . $row["Marka"]. " - Model: " . $row["Model"]. "
";
}
} else {
echo "0 wynikow";
}
Echo "Zadanie 3
";
$sql = "SELECT Marka, Model, Kolor FROM auta ORDER BY Kolor";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
while($row = $result->fetch_assoc()) {
echo "Marka: " . $row["Marka"]. " - Model: " . $row["Model"]. " - Kolor: " . $row["Kolor"]. "
";
}
} else {
echo "0 wynikow";
}
Echo "Zadanie 4
";
$sql = "SELECT Model FROM auta WHERE Kolor='Czarny'";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
while($row = $result->fetch_assoc()) {
echo "Model: " . $row["Model"]. "
";
}
} else {
echo "0 wynikow";
}
Echo "Zadanie 5
";
$sql = "SELECT Kolor FROM auta WHERE Rocznik='2015' ORDER BY Rocznik DESC";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
while($row = $result->fetch_assoc()) {
echo "Kolor: " . $row["Kolor"]. "
";
}
} else {
echo "0 wynikow";
}
$conn->close();
?>