Advertisement
Guest User

Untitled

a guest
Apr 19th, 2014
38
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.92 KB | None | 0 0
  1. <?php
  2. $con=mysqli_connect("localhost","root","","vb");
  3. // Check connection
  4. if (mysqli_connect_errno())
  5. {
  6. echo "Failed to connect to MySQL: " . mysqli_connect_error();
  7. }
  8.  
  9. // escape variables for security
  10. $firstname = mysqli_real_escape_string($_POST['Forename']);
  11. $lastname = mysqli_real_escape_string($_POST['Surname']);
  12. $email = mysqli_real_escape_string($_POST['Email']);
  13.  
  14. $sql="INSERT INTO 'customer1' ('Forename', 'Surname', 'Email')
  15. VALUES ($Forename, $Surname, $Email)";
  16.  
  17. if (!mysqli_query($con,$sql))
  18. {
  19. die('Error: ' . mysqli_error($con));
  20. }
  21. echo "1 record added";
  22.  
  23. mysqli_close($con);
  24. ?>
  25.  
  26. $sql="INSERT INTO customer1 (Forename, Surname, Email)
  27. VALUES ('$Forename', '$Surname', '$Email')";
  28.  
  29. $sql="INSERT INTO `customer1` (`Forename`, `Surname', `Email`)
  30. VALUES ($Forename, $Surname, $Email)";
  31.  
  32. $sql='INSERT INTO customer1 (`Forename`, `Surname`, `Email`)
  33. VALUES ("'.$Forename.'","'.$Surname.'", "'.$Email.'")';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement