View Single Post
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);
"<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";
// not successful
$page file_get_contents("err_login.html");
            //$_SESSION['valid'] = 1;
            //$_SESSION['user'] = $username; 
Reply With Quote