Functions are driving me crazy....
| From: | Jason Pruim | Date: | Fri, 25 Jan 2008 19:59:28 +0000 |
| Subject: | Functions are driving me crazy.... | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-268133@lists.php.net to get a copy of this message | ||
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;
?>
and here is the code that I am using to call it:
$authenticated = authentication($user, $pass);
but when ever I try and run it I get the following errors in my log file, and the page doesn't load the info in the database.
Help me please!
My error log shows this:
[Fri Jan 25 14:55:14 2008] [error] PHP Notice: Undefined variable: authenticated in /Volumes/RAIDer/webserver/includes/oldbinc/function/authentication.func.php on line 16
[Fri Jan 25 14:55:14 2008] [error] PHP Notice: Undefined variable: user in /Volumes/RAIDer/webserver/includes/oldbinc/function/authentication.func.php on line 5
[Fri Jan 25 14:55:14 2008] [error] PHP Notice: Undefined variable: user in /Volumes/RAIDer/webserver/includes/oldbinc/function/authentication.func.php on line 5
--
Jason Pruim
Raoset Inc.
Technology Manager
MQC Specialist
3251 132nd ave
Holland, MI, 49424
www.raoset.com
japruim@raoset.com