php cannot login

Question

I have this set of codes

$user = htmlentities($_POST['user']);
$pass = htmlentities($_POST['pass']);

function sha512($str) { return hash("sha512", $str); }
$pass = sha512($pass);

$tzlogin = sprintf("SELECT * FROM users WHERE user='%s' AND pass='%s'",
mysql_real_escape_string($user), mysql_real_escape_string($pass));

$tzlogged = mysql_query($tzlogin, $config) or die(mysql_error());

if (mysql_num_rows($tzlogged) == 0){
    header (sprintf("Location: ./login.php?status=error"));
} else {
    if (isset($_POST['tz-remember'])){
        $query = mysql_query("SELECT uid FROM users WHERE user='".$user."'", $config);
        $id = mysql_fetch_row($query);
        foreach($id as $uid){
            setcookie('uid', $uid, time() + 60*60*24*30*11, '/', '.localhost');
        }
        header (sprintf("Location: ./index.php"));
    } else {
        $query = mysql_query("SELECT uid FROM users WHERE user='".$user."'", $config);
        $id = mysql_fetch_row($query);
        foreach($id as $uid){
            $_SESSION['uid'] = $uid;
        }
        header (sprintf("Location: ./index.php"));
    }
}

its all correct i think because earlier i was able to login properly but suddenly i am not i encrypted the password into a hash format while registration and while logging in i again first encrypted it then selected and when i looked carefully the inserted data in the database is missing some lines while the data entered is a bit longer like i enter a password test now the inserted data is

"ee26b0dd4af7e749aa1a8ee3c10ae9923f618980772e473f8819a5d4940e0db27ac185f8a0e1d5f84f88bc887fd67b143732"

while the posted data is

"ee26b0dd4af7e749aa1a8ee3c10ae9923f618980772e473f8819a5d4940e0db27ac185f8a0e1d5f84f88bc887fd67b143732c304cc5fa9ad8e6f57f50028a8ff" why is that so?

Community · Accepted Answer · 2017-05-23 12:11:31Z

2

SHA-512 generates a 512-bit hash value, which can be represented in CHAR(128).

you can see other types of sha in here: What data type to use for hashed password field and what length?

edited May 23, 2017 at 12:11

CommunityBot

11 silver badge

answered Oct 29, 2011 at 17:29

onatm♦

8461 gold badge12 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Matthew · Accepted Answer · 2011-10-29 17:27:46Z

1

Your database field is set to 100 characters. Increase the length to 128.

answered Oct 29, 2011 at 17:27

Matthew

48.5k11 gold badges90 silver badges101 bronze badges

Comments

Leonid Shevtsov · Accepted Answer · 2011-10-29 17:28:10Z

0

Looks like the password field in the database is too short.

Please post the result of SHOW CREATE TABLE users.

answered Oct 29, 2011 at 17:28

Leonid Shevtsov

14.3k9 gold badges56 silver badges86 bronze badges

Collectives™ on Stack Overflow

php cannot login

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related