PHP Example

<?php

function encrypt( $plain )
{
  $array_mul = array ( 0 => 213119, 1 => 213247, 2 => 213203, 3 => 213821 );
  $array_add = array ( 0 => 2529077, 1 => 2529089, 2 => 2529589, 3 => 2529997 );
  $dst = $key = array ( 0 => 0, 1 => 0, 2 => 0, 3 => 0, 4 => 0, 5 => 0, 6 => 0, 7 => 0, 8 => 0, 9 => 0, 10 => 0, 11 => 0, 12 => 0, 13 => 0, 14 => 0, 15 => 0 );

  for ( $i = 0; $i < strlen ( $plain ); $i++ ) {
    $dst [ $i ] = $key [ $i ] = ord ( substr ( $plain, $i, 1 ) );
  }

  for ( $i = 0; $i <= 3; $i++ ) {
    $val [ $i ] = fmod ( ( $key [ $i * 4 + 0 ] + $key [ $i * 4 + 1 ] * 0x100 + $key [ $i * 4 + 2 ] * 0x10000 + $key [ $i * 4 + 3 ] * 0x1000000 ) * $array_mul [ $i ] + $array_add [ $i ], 4294967296 );
  }

  for ( $i = 0; $i <= 3; $i++ ) {
    $key [ $i * 4 + 0 ] = $val [ $i ] & 0xff;
    $key [ $i * 4 + 1 ] = $val [ $i ] / 0x100 & 0xff;
    $key [ $i * 4 + 2 ] = $val [ $i ] / 0x10000 & 0xff;
    $key [ $i * 4 + 3 ] = $val [ $i ] / 0x1000000 & 0xff;
  }

  $dst [ 0 ] = $dst [ 0 ] ^ $key [ 0 ];
  for ( $i = 1; $i <= 15; $i++ ) {
    $dst [ $i ] = $dst [ $i ] ^ $dst [ $i - 1 ] ^ $key [ $i ];
  }

  for ( $i = 0; $i <= 15; $i++ ) {
    if ( $dst [ $i ] == 0 ) {
      $dst [ $i ] = 0x66;
    }
  }

  $encrypted = "0x";
  for ( $i = 0; $i <= 15; $i++ ) {
    if ( $dst [ $i ] < 16 ) {
      $encrypted .= "0";
    }
    $encrypted .= /*strtoupper (*/ dechex ( $dst [ $i ] ) /*)*/;
  }
  return ( $encrypted );
}

$dbName = 'lin2db';
$dbAddress = '(local)\SQLEXPRESS';
$dbUser = 'sa';
$dbPassword = '123456';

$loginName = 'root3';
$loginPassword = 'root';
$encLoginPassword = encrypt($loginPassword);
$serverName = "serverName\sqlexpress"; //serverName\instanceName
$connectionInfo = array( "Database"=>"$dbName", "UID"=>"$dbUser", "PWD"=>"$dbPassword");
$conn = sqlsrv_connect( $dbAddress, $connectionInfo);

if( $conn )
{
    echo "Connection established.<br />";
    $sql = "SELECT account, password FROM user_auth WHERE account='$loginName'";
    $stmt = sqlsrv_query( $conn, $sql );
    if( $stmt === false) {
            die( print_r( sqlsrv_errors(), true) );
    }

    if( $row = sqlsrv_fetch_array( $stmt, SQLSRV_FETCH_ASSOC) )
    {
        $pwd = '0x' . bin2hex($row['password']);
        echo "Data from db: ".$row['account'].", ".$pwd."<br />";
        echo "Encrypted pwd: $encLoginPassword  ($loginPassword)<br />";
        if($pwd == $encLoginPassword)
        {
            echo "Passwords match! OK!<br />";
        }else
        {
            echo "Passwords doesn't match!<br />";
        }
    }
    sqlsrv_free_stmt( $stmt);
    sqlsrv_close( $conn );
}else
{
    echo "Connection could not be established.<br />";
    die( print_r( sqlsrv_errors(), true));
}

?>