Συνδεδεμένοι SHA256 Γεννήτρια Hash

I have a list of around 40,000 email addresses. I need to hash them using SHA-256 & generate an individual hash for each email address. I've been told that I can do this via SQL but after a lot of Googling & trying to guess my way through it as a layperson I haven't had any success.

I have observed that when I hash data from a *.txt file and a *.docx file the both hash generated are different even though the data is same in both the file.Why does this happen?

I'm making a php login, and I'm trying to decide whether to use SHA1 or Md5, or SHA256 which I read about in another stackoverflow article. Are any of them more secure than others? For SHA1/256, do I still use a salt?

Also, is this a secure way to store the password as a hash in mysql?

function createSalt(){    $string = md5(uniqid(rand(), true));    return substr($string, 0, 3);}$salt = createSalt();$hash = sha1($salt . $hash);

Following the AWS example on Signature Version 4, I am trying to reproduce the example using a Google Sheets with Google apps scripting. I face an issue with the kregion signature in the example. While I can confirm that the AWS example is valid using an online signature tool, I am never able to reproduce the example output using any Google app script. As HMAC SHA256 signature works fine for an earlier part of the example (kdate), the issue seems to come from the way data is stored or used.

What works for kDate is the following with parts from another stackoverflow entry to convert byte array to hex string and with the help of Google apps script documentation for computeHmacSha256Signature:

var input="20120215";var key="AWS4"+"wJalrXUtnFEMI/K7MDENG+bPxRfiCYEXAMPLEKEY";//Do not worry, this is an example key, not my actual keyvar signature=Utilities.computeHmacSha256Signature(input,key);signature=signature.map(function(chr){return (chr+256).toString(16).slice(-2)}).join('');//convert byte array to hex stringLogger.log(signature);//valid 969fbb94feb542b71ede6f87fe4d5fa29c789342b0f407474670f0c2489e0a0d

Here is the same thing for the kRegion:

var input="us-east-1";var key="969fbb94feb542b71ede6f87fe4d5fa29c789342b0f407474670f0c2489e0a0d";var signature=Utilities.computeHmacSha256Signature(input,key);signature=signature.map(function(chr){return (chr+256).toString(16).slice(-2)}).join('');Logger.log(signature);//non-valid a59e30f9d899c47b3dd68ea1c0ab3bb529e03a8f4ed2f54cb64af547330a22a0

I am not surprised that it doesn't produce the valid example kRegion output 69daa0209cd9c5ff5c8ced464a696fd4252e981430b10e3d3fd8e2f197d7a70c because the key is stored as a hex string which doesn't make much sense. Here is the same thing with an attempt at decoding the hex string to a byte array inspired from this github entry:

var input="us-east-1";var key="969fbb94feb542b71ede6f87fe4d5fa29c789342b0f407474670f0c2489e0a0d";var a=[];for(var i=0, len=key.length; i<len; i+=2) {  a.push(parseInt(key.substr(i,2),16));}key=a;Logger.log(key);//[150.0, 159.0, 187.0, 148.0, 254.0, 181.0, 66.0, 183.0, 30.0, 222.0, 111.0, 135.0, 254.0, 77.0, 95.0, 162.0, 156.0, 120.0, 147.0, 66.0, 176.0, 244.0, 7.0, 71.0, 70.0, 112.0, 240.0, 194.0, 72.0, 158.0, 10.0, 13.0]var signature=Utilities.computeHmacSha256Signature(input,key);signature=signature.map(function(chr){return (chr+256).toString(16).slice(-2)}).join('');Logger.log(signature);//non-valid ac7a5b21190d18b323886d48cd3c4c7486a0f1dd4edb80d245a221a95f5e689b

Using an online converter, i can confirm that the key is well converted. Yet, the output signature is still wrong.I was wondering whether it could be because the key bytes are stored as doubles. So, I tried the following with no difference on the output signature:

var input="us-east-1";var key=[0x96, 0x9f, 0xbb, 0x94, 0xfe, 0xb5, 0x42, 0xb7, 0x1e, 0xde, 0x6f, 0x87, 0xfe, 0x4d, 0x5f, 0xa2, 0x9c, 0x78, 0x93, 0x42, 0xb0, 0xf4, 0x07, 0x47, 0x46, 0x70, 0xf0, 0xc2, 0x48, 0x9e, 0x0a, 0x0d];var signature=Utilities.computeHmacSha256Signature(input,key);signature=signature.map(function(chr){return (chr+256).toString(16).slice(-2)}).join('');Logger.log(signature);//non-valid ac7a5b21190d18b323886d48cd3c4c7486a0f1dd4edb80d245a221a95f5e689b

Then I thought maybe both parameters of the computeHmacSha256Signature function need to be byte arrays:

var input=[0x75, 0x73, 0x2d, 0x65, 0x61, 0x73, 0x74, 0x2d, 0x31];var key=[0x96, 0x9f, 0xbb, 0x94, 0xfe, 0xb5, 0x42, 0xb7, 0x1e, 0xde, 0x6f, 0x87, 0xfe, 0x4d, 0x5f, 0xa2, 0x9c, 0x78, 0x93, 0x42, 0xb0, 0xf4, 0x07, 0x47, 0x46, 0x70, 0xf0, 0xc2, 0x48, 0x9e, 0x0a, 0x0d];var signature=Utilities.computeHmacSha256Signature(input,key);//leads to error "Cannot convert Array to (class)[]."signature=signature.map(function(chr){return (chr+256).toString(16).slice(-2)}).join('');Logger.log(signature);

The above leads to error "Cannot convert Array to (class)[].". Which seems to indicate that the computeHmacSha256Signature function is more comfortable with the string input.

I got yet another invalid kRegion output signature by using the output signature of kDate without converting it to a string:

var input="20120215";var key="AWS4"+"wJalrXUtnFEMI/K7MDENG+bPxRfiCYEXAMPLEKEY";var signature=Utilities.computeHmacSha256Signature(input,key);input="us-east-1";key=signature;signature = Utilities.computeHmacSha256Signature(input,key);signature=signature.map(function(chr){return (chr+256).toString(16).slice(-2)}).join('');Logger.log(signature);//non-valid c3b37a4dc2e085fcd35411493526592a33ef1d7d38454a25e574a34fe190d7be

I tried many other conversions with no success.

I've made encrypting of the password in my register script and they are stored in the database, and I have to use them to login, so I would want to use the unencrypted ones to login. I've read some of the threads in here but nothing is helping me. How can I add it in my login.php? The salt is also stored in the database.

This is my register.php script for encrypting

$hash = hash('sha256', $password1);function createSalt(){    $text = md5(uniqid(rand(), TRUE));    return substr($text, 0, 3);}$salt = createSalt();$password = hash('sha256', $salt . $hash);

and this is my login.php with season

//Create query$qry="SELECT * FROM member WHERE username='$username' AND password='$password'";$result=mysql_query($qry);//Check whether the query was successful or notif($result) {    if(mysql_num_rows($result) > 0) {        //Login Successful        session_regenerate_id();        $member = mysql_fetch_assoc($result);        $_SESSION['SESS_MEMBER_ID'] = $member['id'];        $_SESSION['SESS_FIRST_NAME'] = $member['username'];        $_SESSION['SESS_LAST_NAME'] = $member['password'];        session_write_close();        header("location: profile.php");        exit();    }    else {        //Login failed        //error message     }else {    die("Query failed");}