connect_error) {
die("Połączenie nieudane: " . $conn->connect_error);
}
$sql = "SELECT * FROM auta WHERE kolor='CZERWONY'";
$result = $conn->query($sql);
echo " Zadanie 1
";
if ($result->num_rows > 0) {
while($row = $result->fetch_assoc()) {
echo " rocznik: " . $row["rocznik"] . "
";
}
} else {
}
echo "liczba wyświetlonych rekordów: " ;
echo $result->num_rows;
$sql = "SELECT marka, model FROM auta WHERE rocznik >='2012' and rocznik <='2020'";
$result = $conn->query($sql);
echo "
Zadanie 2
";
if ($result->num_rows > 0) {
while($row = $result->fetch_assoc()) {
echo " marka: " . $row["marka"] . " model: " . $row["model"] . "
";
}
} else {
}
echo "liczba wyświetlonych rekordów: " ;
echo $result->num_rows;
$sql = "SELECT marka, model, kolor FROM auta order by kolor asc";
$result = $conn->query($sql);
echo "
Zadanie 3
";
if ($result->num_rows > 0) {
while($row = $result->fetch_assoc()) {
echo "marka: " . $row["marka"] . " model: " . $row["model"] . " kolor: " . $row["kolor"] . "
";
}
} else {
}
echo "liczba wyświetlonych rekordów: " ;
echo $result->num_rows;
$sql = "SELECT model, kolor FROM auta WHERE kolor='CZARNY'";
$result = $conn->query($sql);
echo "
Zadanie 4
";
if ($result->num_rows > 0) {
while($row = $result->fetch_assoc()) {
echo "model: " . $row["model"] . "
";
}
} else {
}
echo "liczba wyświetlonych rekordów: " ;
echo $result->num_rows;
$sql = "SELECT rocznik, kolor FROM auta WHERE rocznik >='2015' order by rocznik desc";
$result = $conn->query($sql);
echo "
Zadanie 5
";
if ($result->num_rows > 0) {
while($row = $result->fetch_assoc()) {
echo "kolor: " . $row["kolor"] . "
";
}
} else {
}
echo "liczba wyświetlonych rekordów: " ;
echo $result->num_rows;
$conn->close();
?>