Strange, it works for me. I just did this:
//require 'core/init.php';
$username = 'u';
$password = 'p';
if(empty($username) === true || empty($password) === true)
{
$errors[] = 'please enter a username and password';
}else if(user_exists($username) === false)
{
$errors[] = 'we can\'t find that user, please contact AZ Media Production';
}else
{
$login = login($username, $password);
if($login == false)
{
$errors[] = 'That username/password combination is incorrect';
}else
{
$_SESSION[`user_id`] = $login;
header('Location: anounceEdit.php');
exit();
}
}
print_r($errors);
//include '../database/conection.php';
//include 'general.php';}these lines are commented out because of a failed attempt to fix my issue
function user_exists($username)
{
$username = sanitize($username);
$query = mysql_query("SELECT COUNT(`user_id`) FROM `users` WHERE `userName` = '$username'");
return(mysql_result($query, 0) == 1) ? true : false;
}
function user_id_from_username($username)
{
$username = sanitize($username);
$query = mysql_query("SELECT `user_id` FROM `users` WHERE `userName` = '$username'");
return mysql_result($query, 0, 'user_id');
}
function login($username, $password)
{
$user_id = user_id_from_username($username);
$username = sanitize($username);
$password = sha1($password);
$query = mysql_query("SELECT COUNT(`user_id`) FROM `users` WHERE `userName` = '$username' AND `password` = '$password'");
return(mysql_result($query, 0) == 1) ? $user_id : false;
}
I took off the post bit and appended the init code. I got a fail on the sanitize function, which shows that the user_exists fired (error line was inside the user_exists function). I'm assuming your require reference is correct for the code and that you're not referencing an older file without that code in it or user_exsists in it.
diafol
Keep Smiling
10,842 posts since Oct 2006
Reputation Points: 1,675
Solved Threads: 1,536
Skill Endorsements: 61
Question Answered as of 5 Months Ago by
AleMonteiro
and
diafol