Guest User

Untitled

a guest
Dec 7th, 2018
119
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.93 KB | None | 0 0
  1. <!DOCTYPE html>
  2. <html>
  3. <head></head>
  4. <body>
  5. <?php
  6. // Database connection parameters.
  7. $servername = "localhost";
  8. $username = "root";
  9. $password = "";
  10. $dbname = "SampleDB";
  11. $user=$_POST['uname'];
  12. $pass=$_POST['psw'];
  13. #echo $user.$pass;
  14.  
  15. $con=mysql_connect('localhost','root','') or die(mysql_error());
  16. mysql_select_db('SampleDB') or die("cannot select DB");
  17. #echo $con;
  18. $query=mysql_query("SELECT * FROM sampletable WHERE username='".$user."' AND password='".$pass."'");
  19. $numrows=mysql_num_rows($query);
  20. #echo $numrows;
  21. if($numrows!=0)
  22. {
  23. while($row=mysql_fetch_assoc($query))
  24. {
  25. $dbusername=$row['username'];
  26. $dbpassword=$row['password'];
  27. }
  28. #echo $dbusername.$dbpassword;
  29. if($user == $dbusername && $pass == $dbpassword)
  30. {
  31. echo "Valid User .. Successfully Logged In !!";
  32. } else {
  33. echo "Invalid Username or password!";
  34. }
  35. }
  36. ?>
  37. </body>
  38. </html>
Add Comment
Please, Sign In to add comment