duanliao5995 2019-03-28 10:43
浏览 66

无法弄清楚这个bindParam问题

I'm trying to fetch some data from a MySql db using PDO but no matter what I do, I can't get anything when using a prepared statement... please tell me what I'm doing wrong.

The following code runs but returns nothing.

try {
    $dbh = new PDO('mysql:host=localhost;dbname=banim', 'root', '');
    $uName = "banim";       //$_POST['uName'];
    $email = "Rabak@gmail.com";            //$_POST['email'];
    $query = $dbh->prepare("SELECT * from users WHERE email = :email OR WHERE uName = :name");
    $query->setFetchMode(PDO::FETCH_ASSOC);
    $query->bindParam(":name", $uName);
    $query->bindParam(":email", $email);
    $query->execute();
    foreach ($query as $row) {
        print_r($query);
    }
} catch (PDOException $e) {
    echo "PDOException: " . $e->getMssage() . PHP_EOL;
}
  • 写回答

1条回答 默认 最新

  • doucuo4413 2019-03-28 12:30
    关注

    What Alive To Die wrote was correct, and there was also an extra WHERE in the SQL string which also messed up the answer, this is the final code:

    try {
        $dbh = new PDO('mysql:host=localhost;dbname=banim', 'root', '');
        $uName = "banim";       //$_POST['uName'];
        $email = "Rabak@gmail.com";            //$_POST['email'];
        $query = $dbh->prepare("SELECT * from users WHERE email = :email OR uName = :name");
        $query->setFetchMode(PDO::FETCH_ASSOC);
        $query->bindParam(":name", $uName);
        $query->bindParam(":email", $email);
        $query->execute();
        while($row = $query->fetch()){
            print_r($row);
        }
    } catch (PDOException $e) {
        echo "PDOException: " . $e->getMssage() . PHP_EOL;
    }
    
    评论

报告相同问题?

悬赏问题

  • ¥15 基于卷积神经网络的声纹识别
  • ¥15 Python中的request,如何使用ssr节点,通过代理requests网页。本人在泰国,需要用大陆ip才能玩网页游戏,合法合规。
  • ¥100 为什么这个恒流源电路不能恒流?
  • ¥15 有偿求跨组件数据流路径图
  • ¥15 写一个方法checkPerson,入参实体类Person,出参布尔值
  • ¥15 我想咨询一下路面纹理三维点云数据处理的一些问题,上传的坐标文件里是怎么对无序点进行编号的,以及xy坐标在处理的时候是进行整体模型分片处理的吗
  • ¥15 CSAPPattacklab
  • ¥15 一直显示正在等待HID—ISP
  • ¥15 Python turtle 画图
  • ¥15 stm32开发clion时遇到的编译问题