PHP analogue of MSSQL

Question

I need write php function calculating hash from password string. In MSSQL hash is calculated like:

lower(substring(convert(varchar(200), hashbytes('md5', 'my_password_string' + '|' + cast(cast(getdate() as date) as varchar(max))), 1), 3, 32))

What is php analogue of this crazy algorithm?

I tried this:

$password = hash('md5' , 'my_password_string'.'|'.date('YYYY-mm-dd'), false);

but result is not same

Zhorov · Accepted Answer · 2021-04-05 13:49:05Z

1

You need to use hash(), but the important parts are 1) the result of the date conversion, 2) the character encoding of the password and 3) the varchar collation of the data in the database. But the following basic example is an option:

T-SQL:

SELECT 
   LOWER(SUBSTRING(
      CONVERT(
         varchar(200),
         HASHBYTES(
            'md5', 
            'my_password_string' + '|' + CONVERT(varchar(10), CONVERT(date, GETDATE(), 23))
         ),
         1
      ),
      3,
      32
   ))

PHP:

<?
$password = strtolower(substr(hash('md5' , 'my_password_string'.'|'.date('Y-m-d'), false), 0, 200));
echo $password;
?>

Result:

b2b2c0a81c42f802d98200daa504f197

edited Apr 5, 2021 at 13:49

answered Apr 5, 2021 at 13:41

Zhorov

30.3k6 gold badges32 silver badges56 bronze badges

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

1 Comment

harp1814 Over a year ago

Thanks, Zhorow ! I used other format for datetime. Your format is ok!

Collectives™ on Stack Overflow

PHP analogue of MSSQL

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related