connect_error){
die("Błąd: " .$conn->connet_error);
}
echo "SELECT * FROM auta2 WHERE Kolor = 'Czerwony'
";
$sql = "SELECT * FROM auta2 WHERE Kolor = 'Czerwony'";
$result = $conn->query($sql);
if ($result->num_rows > 0){
while($row = $result->fetch_assoc()){
echo "id: " . $row["id"]. " Rocznik: " . $row["Rocznik"]."
";
}
} else{
echo "0 results";
}
echo "SELECT * FROM auta2 WHERE Rocznik = '2009-2020'
";
$sql = "SELECT * FROM auta2 WHERE Rocznik = '2009-2020'";
$result = $conn->query($sql);
if ($result->num_rows > 0){
while($row = $result->fetch_assoc()){
echo "id: " . $row["id"]. " Marka: " . $row["Marka"]. " Model: " . $row["Model"] . " Rocznik: " . $row["Rocznik"]. "
";
}
} else{
echo "0 results";
}
echo "SELECT * FROM auta2 WHERE Kolor = 'Czarny'
";
$sql = "SELECT * FROM auta2 WHERE Kolor = 'Czarny'";
$result = $conn->query($sql);
if ($result->num_rows > 0){
while($row = $result->fetch_assoc()){
echo "id: " . $row["id"]. " Model: " . $row["Model"];
}
} else{
echo "0 results";
}
echo "SELECT * FROM auta2 WHERE Model LIKE '%up%'
";
$sql = "SELECT * FROM auta2 WHERE Model LIKE '%up%'";
$result = $conn->query($sql);
if ($result->num_rows > 0){
while($row = $result->fetch_assoc()){
echo "id: " . $row["id"]. " Model: " . $row["Model"];
}
} else{
echo "0 results";
}
$conn-> close();
?>