Advertisement
Guest User

Untitled

a guest
Aug 24th, 2018
103
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.83 KB | None | 0 0
  1. $username = filter_input(INPUT_POST, 'username');
  2. $password = filter_input(INPUT_POST, 'password');
  3. if (!empty($username)){
  4. if (!empty($password)){
  5. $host = "localhost";
  6. $dbusername = "root";
  7. $dbpassword = "removed";
  8. $dbname = "test1";
  9.  
  10. // Create connection
  11. $conn = new mysqli ($host, $dbusername, $dbpassword, $dbname);
  12.  
  13. if (mysqli_connect_error()){
  14. die('Connect Error ('. mysqli_connect_errno() .') '
  15. . mysqli_connect_error());
  16. }
  17. else{
  18. $sql = "INSERT INTO project (username, password)
  19. values ('$username','$password')";
  20. if ($conn->query($sql)){
  21. echo "New record is inserted sucessfully";
  22. }
  23. else{
  24. echo "Error: ". $sql ."
  25. ". $conn->error;
  26. }
  27. $conn->close();
  28. }
  29. }
  30. else{
  31. echo "Password should not be empty";
  32. die();
  33. }
  34. }
  35. else{
  36. echo "Username should not be empty";
  37. die();
  38. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement