Advertisement
Guest User

Untitled

a guest
Aug 1st, 2018
158
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.82 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 = "";
  8. $dbname = "youtube";
  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 account (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