[eluser]miwrath[/eluser]
can anyone help us to solve the problem on uppercase and lowercase
in user login authentication?
this is my user_model.php in my model folder.
im using this code:
Code:
<?php
class User_model extends Model {
function User_model()
{
parent::Model();
}
function check_login($username, $password)
{
//login_checker!!!!!!!!!!!!!
//
//$shal_password = sha1($password);
$query_str = "SELECT * FROM users WHERE username = '$username'
AND password = PASSWORD('$password')";
$result = $this->db->query($query_str, array($username, $password));
//echo 'username: '.$username.'<br/>';
//echo 'password: '.$password.'<br/>';
//echo 'password hash: '.$shal_password.'<br/>';
//$query_str = "SELECT * FROM users WHERE username = ? and password = ?";
//$result = $this->db->query($query_str, array($username, $shal_password));
//echo 'query: '.$this->db->last_query();
//exit();
if ($result->num_rows() == 1)
{
return $result->row(0)->teach_id;
}
else
{
return false;
}
}
}
?>