Don't like ads? PRO users don't see any ads ;-)
Guest

Untitled

By: a guest on Apr 28th, 2012  |  syntax: None  |  size: 1.73 KB  |  hits: 16  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. Username and Password validate doesn't work in PHP?
  2. function queryByUserAndPass($tableName, $username, $password){
  3.     $queryStatement = "SELECT * FROM ".$tableName." WHERE username='".$username."'
  4.                       AND password='".$password."' LIMIT 1";
  5.     return $queryStatement;
  6. }
  7.  
  8. function checkLogIn() {
  9.  
  10.     if(isset($_POST['submit'])){
  11.         $username = $_POST['username'];
  12.         $password = $_POST['password'];
  13.         $queryState = queryByUserAndPass("nepal_users", $username, $password);
  14.         if( $resultQuery = mysql_query($queryState) ){
  15.             $found_user= mysql_fetch_array($resultQuery);
  16.             $_SESSION['id']=$found_user['id'];
  17.             $_SESSION['username']=$found_user['username'];
  18.             $message="succesful log in ".$_SESSION['username'];
  19.             header("location:home.php");
  20.             exit;
  21.         }else {
  22.             $message="error in log in";
  23.         }    
  24.  
  25.     }
  26.  
  27. }
  28.        
  29. if( $resultQuery = mysql_query($queryState) ){
  30.         $found_user = mysql_fetch_array($resultQuery);
  31.         if ($username === $found_user['username'] &&
  32.           $password === $found_user['password']) {
  33.             $_SESSION['id']=$found_user['id'];
  34.             $_SESSION['username']=$found_user['username'];
  35.             $message="succesful log in ".$_SESSION['username'];
  36.             header("Location: home.php");
  37.             exit;
  38.         } else {
  39.             echo "wrong username or password";
  40.         }
  41.     }else {
  42.         $message="error from database: " . mysql_errno($resultQuery);
  43.     }
  44.        
  45. $resultQuery = mysql_query($queryState);
  46. if( $found_user = mysql_fetch_assoc($resultQuery)) {
  47.     // do login stuff
  48.     // note I used "fetch_assoc" above, because you don't use numeric indices here.
  49. }
  50. else $message = "Error";