Advertisement
Guest User

Untitled

a guest
Jun 27th, 2016
72
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.35 KB | None | 0 0
  1. <!DOCTYPE HTML>
  2. <html>
  3. <head>
  4. <title>Sign-In</title>
  5. </head>
  6. <body>
  7. <form method="POST" action="home.php">
  8. User: <br><input type="text" name="username" size="40"/><br />
  9. Password: <br><input type="password" name="password" size="40"/><br />
  10. <input type="submit" name="submit" value="Log-In" />
  11. </form>
  12. </body>
  13. </html>
  14. <?php
  15. error_reporting(E_ALL);
  16.  
  17. if (isset($_POST['submit']))
  18. {
  19. mysql_connect('localhost', 'root', '') or die(mysql_error());
  20. mysql_select_db('cheapbooks');
  21. echo "connected to DB";
  22. $username = $_POST["username"];
  23. $password = $_POST["password"];
  24.  
  25. $query = mysql_query("SELECT * FROM customer WHERE username='".$username."' AND password='".$password."' ");
  26. $numrows = mysql_num_rows($query);
  27. if($numrows!=0)
  28. {
  29. while($row = mysql_fetch_assoc($query))
  30. {
  31. $dbuser = $row['username'];
  32. $dbpass = $row['password'];
  33. }
  34. if($username == $dbuser && $password == $dbpass)
  35. {
  36. session_start();
  37. $_SESSION['sess_user']=$username;
  38. echo "Logged in successfully";
  39. //header("Location: home.php"); //Redirecting to home page after login
  40. }
  41. else
  42. {
  43. echo "Invalid username or password!";
  44. }
  45. }
  46. else
  47. {
  48. echo "Failed........";
  49. }
  50. }
  51. else
  52. {
  53. echo "NO Action!!!";
  54. }
  55. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement