Advertisement
Guest User

Untitled

a guest
Nov 22nd, 2017
65
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.66 KB | None | 0 0
  1. <?php
  2.  
  3. $servername = "localhost";
  4. $username = "root";
  5. $password = "";
  6. $db="banking";
  7. // Create connection
  8. $conn = mysqli_connect($servername, $username, $password,$db);
  9.  
  10. if (!$conn) {
  11. die("Connection failed: " . mysqli_connect_error());
  12. }
  13. $name=$_POST['name'];
  14. $email=$_POST['email'];
  15. $cnumber=$_POST['cnumber'];
  16. $date=$_POST['date'];
  17.  
  18.  
  19. $sql = "INSERT INTO `customer` (name, email, cnumber, date)VALUES('$name','$cnumber','$email','$date' )";
  20. if (mysqli_query($conn, $sql)) {
  21. echo "New record created successfully";
  22. } else {
  23. echo "Error: " . $sql . "<br>" . mysqli_error($conn);
  24. }
  25.  
  26.  
  27.  
  28.  
  29. // Check connection
  30.  
  31. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement