Advertisement
Guest User

Untitled

a guest
Nov 7th, 2016
89
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.81 KB | None | 0 0
  1. Access denied for user 'www-data'@'localhost' (using password: NO)
  2.  
  3. <?php
  4. $servername = "localhost";
  5. $username = "root";
  6. $db_password = "";
  7. $dbname = "accounts";
  8.  
  9. $conn = new mysqli($servername, $username, $db_password, $dbname);
  10.  
  11. if ($conn->connect_error) {
  12. die("Connection failed: " . $conn->connect_error);
  13. }
  14.  
  15. $email = $_POST['email'];
  16. $password = $_POST['password'];
  17.  
  18. $password = md5($password);
  19.  
  20. $sql = "SELECT * from users WHERE email = '$email' AND password = '$password'";
  21. $result = $conn->query($sql);
  22. if ($result->num_rows == 0) {
  23. echo "<p>Email or password was entered incorrectly.</p>";
  24. } else {
  25. echo "<p>Logged in successfully.</p>";
  26.  
  27. $result = mysql_query("SELECT id,display_name,email FROM users WHERE email = '$email'");
  28. $row = mysql_fetch_row($result);
  29.  
  30. echo $row[0];
  31. echo $row[1];
  32. }
  33. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement