On Fri, January 25, 2008 1:59 pm, 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(){
//initialize the variable so it has SOMETHING in it before you try to
return it at the end:
$authenticated = false;
> if($user && $pass) { // Keep in mind, PASSWORD has meaning in MySQL
You need to pass in $user and $pass as arguments at the function
authentication ($user, $pass)
> // 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@xxxxxxxxxx
>
>
>
--
Some people have a "gift" link here.
Know what I want?
I want you to buy a CD from some indie artist.
http://cdbaby.com/from/lynch
Yeah, I get a buck. So?
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
