Password verify using isset?

[Mike-2003]

I had the below working until I added the else at the end. I wanted it to call another function when the user and password are correct. I can't seem to see where I made my mistake. Any help would be appreciated.
Thanks!

if(!isset($PHP_AUTH_USER)){ authenticate(); }
else {
$c=mysql_pconnect("localhost","root","root");
mysql_select_db("authenticate",$c);
$q=sprintf("SELECT username,password FROM authenticateTable
WHERE username='%s' AND password=PASSWORD('%s')",
$PHP_AUTH_USER,$PHP_AUTH_PW);
$q=mysql_query($q);
if(mysql_num_rows($q)==0){ authenticate();
 }else {
echo "Your IN" //or call another function;
}
}

[rw22]

}else {
echo "Your IN";
//or call another function;
}
}

that should do it, just a misplaced ;

<?php
if (!isset($PHP_AUTH_USER)) {
	authenticate();
} else {
	$c = mysql_pconnect("localhost", "root", "root");
	mysql_select_db("authenticate", $c);
	$q = sprintf("SELECT username,password FROM authenticateTable WHERE username='%s' AND password=PASSWORD('%s')",
		$PHP_AUTH_USER, $PHP_AUTH_PW);
	$q = mysql_query($q);
	if (mysql_num_rows($q) == 0) {
		authenticate();
	} else {
		echo "Your IN"; 
		// or call another function
	} 
} 

?>

[Mike-2003]

Thanks!

I made the modification, but it doesn't come up with anything when I type in the user and password. It seems to keep asking for it , for about 2 times and then comes up with the 'password' or 'user' not correct. Which I have checked.
😕

[rw22]

post your authenticate function

[Mike-2003]

Please excuse this newbie, but what do you mean by post the authenticate function ? 😕

[rw22]

authenticate();

Nothing cryptic i just want you to show it to me. 🙂

function authenticate() {

}

I won't be able to reply till the morning though

[Mike-2003]

Thanks, here it is.

function authenticate() {
header("WWW-Authenticate: Basic realm=\":-)\"");
header("HTTP/1.0 401 Unauthorized");
print("You must enter a valid login username and password
to access this resource.\n");
exit;
}