Guest User

Untitled

a guest
Nov 10th, 2018
216
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.73 KB | None | 0 0
  1. <?php
  2.  
  3. $username = filter_input(INPUT_POST, 'username');
  4. $password = filter_input(INPUT_POST, 'password');
  5. if(!empty($username)){
  6. $host = "localhost";
  7. $dbusername = "root";
  8. $dbpassword = "";
  9. $dbname = "login";
  10.  
  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 testdb (username, password) values ('$username',
  19. '$password')";
  20. if($conn->query($slq)){
  21. echo "New record is inserted successfully!";
  22. }
  23. else{
  24. echo "Error: ". $sql ."<br>". $conn->error;
  25. }
  26. $conn->close();
  27.  
  28. }
  29. else {
  30. echo "Password should not be empty";
  31. }
  32. else{
  33. echo "Username should not be empty";
  34. }
  35.  
  36. ?>
Add Comment
Please, Sign In to add comment