Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <html>
- <body>
- <?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';");
- echo $id_marki->num_rows;
- 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 ($cena, '$data', '$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();
- ?>
- <br><br><br>
- <a href="tabelka.php"> Tabela z markami</a><br>
- <a href="formularz.php"> Formularz wprowadzający samochody</a><br>
- <a href="tabelka2.php"> Tabela z samochodami</a>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement