douxiong3234 2015-12-13 18:16
浏览 24

PHP与MS sql server

I'm trying to get the user's hashed password from my database but this function doesn't seem to return if it's valid or not, I feel like there's something wrong with assigning $hashedPass to the sqlsrv_prepare function. What's the proper way to do it if I'm doing it wrong?

function validate($conn, $username, $password)

{ 
    $isValid = false;

    $sql = "SELECT UserPassword 
            FROM dbo.Users(FullName,Username,UserPassword,Email,PhoneNumber) 
            WHERE Username = ?";
    $hashedPass = sqlsrv_prepare($conn, $sql, array(&$username));

    sqlsrv_execute($hashedPass);
    sqlsrv_fetch($hashedPass);
    sqlsrv_free_stmt($hashedPass);


    if(crypt($password, $hashedPass) == $hashedPass)
        $isValid = true;

    return $isValid;
}
  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥20 docker里部署springboot项目,访问不到扬声器
    • ¥15 netty整合springboot之后自动重连失效
    • ¥15 悬赏!微信开发者工具报错,求帮改
    • ¥20 wireshark抓不到vlan
    • ¥20 关于#stm32#的问题:需要指导自动酸碱滴定仪的原理图程序代码及仿真
    • ¥20 设计一款异域新娘的视频相亲软件需要哪些技术支持
    • ¥15 stata安慰剂检验作图但是真实值不出现在图上
    • ¥15 c程序不知道为什么得不到结果
    • ¥15 键盘指令混乱情况下的启动盘系统重装
    • ¥40 复杂的限制性的商函数处理