Advertisement
Guest User

insert_user_cars.php

a guest
Apr 27th, 2017
75
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.85 KB | None | 0 0
  1. <?php
  2.     $conn=mysqli_connect("localhost","root","", "Autovermietung");
  3.    
  4.    
  5.     if (isset($_POST['submit_kunde'])) {
  6.         $vname = mysqli_real_escape_string($conn, ($_POST['vname']));
  7.         $nname = mysqli_real_escape_string($conn, ($_POST['nname']));
  8.    
  9.         $sql_kunde = "INSERT INTO Kunde (vorname, nachname)
  10.         VALUES ('$vname', '$nname')";
  11.  
  12.     mysqli_query($conn, $sql_kunde);
  13.     echo "Kunde wurde erstellt" ;
  14.     }
  15.  
  16.    
  17.        
  18.     if (isset($_POST['submit_auto'])) {
  19.         $km_stand = mysqli_real_escape_string($conn, ($_POST['km_stand']));
  20.         $marke = mysqli_real_escape_string($conn, ($_POST['marke']));
  21.         $modell = mysqli_real_escape_string($conn, ($_POST['modell']));
  22.    
  23.         $sql_auto = "INSERT INTO Auto (km_stand, marke, modell)
  24.         VALUES ('$km_stand', '$marke', '$modell')";
  25.  
  26.     mysqli_query($conn, $sql_auto);
  27.     echo "Auto wurde erstellt" ;
  28.     }
  29.    
  30.     mysqli_close($conn);
  31. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement