<?php
/*$servername = "localhost";
$username = "root";
$password = "";
$dbname = "baza1";
$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
	}
$cena = $_GET["cena"]."$";
$data = $_GET["data"];
$marka = $_GET["marka"];
$model = $_GET["model"];

$id_marki =$conn->query("select id_marki from marki where nazwa_marki = '$marka';");
$id_modelu=$conn->query("select id_modelu from modele where nazwa_modelu = '$model';");

for($a=0;$a<$id_marki->num_rows;$a++){
foreach($id_marki->fetch_assoc() as $value){ $marka[$a] = $value[0];}
}

for($a=0;$a<$id_modelu->num_rows;$a++){
foreach($id_modelu->fetch_assoc() as $value){ $model[$a] = $value[0];}
}

$sql =$conn->query("INSERT INTO samochody (data_produkcji, cena, marka, model) values ('$data', $cena, '$marka[0]', '$model[0]');");
if($sql) echo "Rekord został dodany poprawnie";
else echo "Błąd nie udało się wprowadzić rekordu".$conn->error;
$conn->close();
?>