View Single Post
  #14  
Old 18th November 2011, 12:14
beaney beaney is offline
Junior Member
 
Join Date: Nov 2011
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default I need help correcting my query string

Im having trouble getting my login to work on my site.
it keeps telling me query failed, but when i echo out the username and password it matches the one on the server so i dont understand why its not working.
Im a new programmer by the way very noob.

PHP Code:
$db mysqli_connect($server$user$password$database);
        
       
            
$salt "45Gxkj9583lPMdxoekfg"
        
$user $_POST['username'];
        
$pass crypt($_POST['password'], $salt);
            
        echo 
"<h2>welcome you are now logged in ".$user." ".$pass."</h2><br />\n";
        
$sql "SELECT username, password FROM faculty WHERE username = $user AND password = $pass";
        
        
$result mysqli_query($sql,$db) or die('Query failed: ' mysql_error($db));
        
        if (
mysql_num_rows($result) == 1)
        {
            
//successful login
            
echo "<h2>Welcome  You are now logged in.</h2>\n";
        }
        else
        {
            
// not successful
            
$page file_get_contents("err_login.html");
                    echo 
$page;
                    exit;
        }
        
            
            
            
//session_start();
            //$_SESSION['valid'] = 1;
            //$_SESSION['user'] = $username; 
Reply With Quote