Advertisement
gitlez

YA: Simple Login WOC

Apr 11th, 2012
73
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.03 KB | None | 0 0
  1. <?php
  2. // Response to Yahoo Answer's Question
  3. session_start();
  4.  
  5. $username = $_POST['username'];
  6. $password = $_POST['password'];
  7.  
  8. if ($username && $password){
  9.     $connect = mysql_connect("127.0.0.1","root","") or die ("Couldnt Connect to Database");
  10.     mysql_select_db("login", $connect) or die ("Couldnt find database");
  11.     $username = mysql_real_escape_string( $username );
  12.     $password = mysql_real_escape_string( $password );
  13.    
  14.     $query = mysql_query("SELECT username FROM users WHERE username='$username' AND password='$password' LIMIT 1");
  15.     if($query && mysql_num_rows($query) === 1){
  16.         $_SESSION['username'] = mysql_fetch_object($query)->username;
  17.         echo "Login successful. <a href='membersarea.php'>Click here to enter the member area</a>";
  18.     } else {
  19.         echo 'Incorrect Username/Password Combination. <a href="' . $_SERVER['HTTP_REFERER'] . '">Click Here To Return</a>.';
  20.     }
  21.     mysql_close( $connect );
  22. }else{
  23.     die('Please enter a username and password. <a href="' . $_SERVER['HTTP_REFERER'] . '">Click Here To Return</a>.');
  24. }
  25. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement