Re: Functions are driving me crazy....
| From: | Thijs Lensselink | Date: | Fri, 25 Jan 2008 20:35:13 +0000 |
| Subject: | Re: Functions are driving me crazy.... | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-268139@lists.php.net to get a copy of this message | ||
Jason Pruim wrote:
Hi everyone :)
So partly to get an answer, and partly to boost my post rankings for the week I have a question.
I am attempting to write an authentication function which would query a database, check the username/password and return true if it matches. If it doesn't match, then it shouldn't return anything and they are denied access.
Here is the code for the function:
<?PHP
function authentication(){
if($user && $pass) { // Keep in mind, PASSWORD has meaning in MySQL
// Do your string sanitizing here
// (e.g. - $user = mysql_real_escape_string($_POST['user']);)
$loginQuery = "SELECT * FROM login WHERE user='".$user."' AND Userpass='".$pass."' LIMIT 0,1;";
$loginResult = mysql_query($loginQuery) or die("Wrong data supplied or database error" .mysql_error());
while($row1 = mysql_fetch_array($loginResult)) {
$_SESSION['user'] = $row1['User'];
$_SESSION['loggedin'] = "YES";
$authenticated = "true";
}
}
}return $authenticated;
?>
Change:
}return $authenticated;
to
return $authenticated;
}
else it will never return the value from the function. But it will always give you undefined variable notice