connect_error) {
die("Połączenie nieudane: " . $conn->connect_error);
}
$sql = "SELECT Marka, Model FROM auta2 WHERE Kolor='czarna perła' and Rocznik >='2012' order by id desc";
$result = $conn->query($sql);
echo " Zadanie 1
";
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 Kolor FROM auta2 WHERE Rocznik >='2009'";
$result = $conn->query($sql);
echo "
Zadanie 2
";
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;
$sql = "SELECT Marka, Model, Ilosc_drzwi, Rocznik, Kolor FROM auta2 order by id 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"] . " Ilość drzwi: " . $row["Ilosc_drzwi"] . " Kolor: " . $row["Kolor"] . "
";
}
} else {
}
echo "liczba wyświetlonych rekordów: " ;
echo $result->num_rows;
$sql = "SELECT Marka, Model, Ilosc_drzwi FROM auta2 WHERE Kolor='czarny' order by id desc";
$result = $conn->query($sql);
echo "
Zadanie 4
";
if ($result->num_rows > 0) {
while($row = $result->fetch_assoc()) {
echo "Marka: " . $row["Marka"] . " Model: " . $row["Model"] . " Ilość drzwi: " . $row["Ilosc_drzwi"] . "
";
}
} else {
}
echo "liczba wyświetlonych rekordów: " ;
echo $result->num_rows;
$sql = "SELECT Marka, Model, Ilosc_drzwi FROM auta2 WHERE Rocznik <='2012' order by Marka desc";
$result = $conn->query($sql);
echo "
Zadanie 5
";
if ($result->num_rows > 0) {
while($row = $result->fetch_assoc()) {
echo "Marka: " . $row["Marka"] . " Model: " . $row["Model"] . " Ilość drzwi: " . $row["Ilosc_drzwi"] . "
";
}
} else {
}
echo "liczba wyświetlonych rekordów: " ;
echo $result->num_rows;
$sql = "SELECT Marka FROM auta2 WHERE Marka LIKE '%t%'";
$result = $conn->query($sql);
echo "
Zadanie 6
";
if ($result->num_rows > 0) {
while($row = $result->fetch_assoc()) {
echo "Marka: " . $row["Marka"] . "
";
}
} else {
}
echo "liczba wyświetlonych rekordów: " ;
echo $result->num_rows;
$sql = "SELECT * FROM auta2 order by Model asc";
$result = $conn->query($sql);
echo "
Zadanie 7
";
if ($result->num_rows > 0) {
while($row = $result->fetch_assoc()) {
echo "ID: " . $row["id"] . " Marka: " . $row["Marka"] . " Model: " . $row["Model"] . " Ilość drzwi: " . $row["Ilosc_drzwi"] . " Rocznik: " . $row["Rocznik"] . " Kolor: " . $row["Kolor"] . "
" ;
}
} else {
}
echo "liczba wyświetlonych rekordów: " ;
echo $result->num_rows;
$sql = "SELECT Marka, Model, Rocznik FROM auta2 WHERE Ilosc_drzwi='5' order by Marka asc";
$result = $conn->query($sql);
echo "
Zadanie 8
";
if ($result->num_rows > 0) {
while($row = $result->fetch_assoc()) {
echo "Marka: " . $row["Marka"] . " Model: " . $row["Model"] . " Rocznik: " . $row["Rocznik"] . "
";
}
} else {
}
echo "liczba wyświetlonych rekordów: " ;
echo $result->num_rows;
$sql = "SELECT Marka, Model, Ilosc_drzwi, Kolor FROM auta2 WHERE Marka or Model LIKE '%r%' order by id desc";
$result = $conn->query($sql);
echo "
Zadanie 9
";
if ($result->num_rows > 0) {
while($row = $result->fetch_assoc()) {
echo "Marka: " . $row["Marka"] . " Model: " . $row["Model"] . " Ilość drzwi: " . $row["Ilosc_drzwi"] . " Kolor: " . $row["Kolor"] . "
";
}
} else {
}
echo "liczba wyświetlonych rekordów: " ;
echo $result->num_rows;
$conn->close();