PHP 7+ & encoding

[MimisK13]

https://imgur.com/a/ngRgNxv

Same code, different version of PHP.

[yitam]

Please provide more details and steps how to reproduce this issue.

[MimisK13]

db Model:

`protected static function getDB()
{
    static $db = null;
    if ($db === null)
    {
        $dsn = Config::DB_TYPE . ':Server=' . Config::DB_HOST . ';Database=' . Config::DB_NAME;

        $db = new PDO( $dsn, Config::DB_USER, Config::DB_PASSWORD );

        // Throw an Exception when an error occurs
        $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    }
    return $db;
}`

Query:

` public static function findByUsername($account)
{

    $sql = 'SELECT * FROM dbo.user_auth WHERE account = :account';

    $db = static::getDB();
    $stmt = $db->prepare($sql);
    $stmt->bindValue(':account', $account, PDO::PARAM_STR );

    $stmt->setFetchMode(PDO::FETCH_CLASS, get_called_class());

    $stmt->execute();

    return $stmt->fetch();
}`

`$user = static::findByUsername($account);
 var_dump($user->password);`

Password datatype from database is BINARY(16)

[yitam]

Your password is of binary type, and please see the related issue #553 for the explanation and details of why this change is required.

[MimisK13]

Thank you very much !