douguaidian8021 2016-09-02 19:31 采纳率: 100%
浏览 40

PDO查询未按预期执行

I am trying to retrieve data from the database. I'm using PDO and the execute statement seems to be giving problems that I can't figure out.

public function doesAdminEmailExist($email){
     $this->m_dbHandler->queryDB("SELECT id FROM Admin WHERE email = ? ", array($email));
     $ret = $this->m_dbHandler->fetchOne();

     if(!empty($ret)) return $ret["id"];
     else return -1;
}

The queryDB function in another class is given below:

public function queryDB($query, $params=array()){
    try {
        $stmt = $this->m_dbConn->prepare($query);
        if($stmt === false){
            $arr = $this->m_dbConn->errorInfo();
            throw new Exception("Could not prepare query: ". $arr[2]." // query: ".$query);
        }
        else {
            $bool_status = $stmt->execute($params);
            if($bool_status){ // Query was successful
                $this->result = $stmt;
            }
            else { // Query was not successful
                $arr = $stmt->errorInfo();
                throw new Exception("Could not execute query: ". $arr[2]." // query: ".$query);
            }
        }
    }
    catch (Exception $e) {
        //throw $e;
        $arr = $this->m_dbConn->errorInfo();
        throw new Exception("An error occurred: ". $arr[2]." // query: ".$query);
    }

}

When I run in my browser, I get the following error

<server_response>
  <return_status>true</return_status>
  <return_message>error Occured. Rethrowing <br>An   error occurred: // query: SELECT id FROM Admin WHERE email = ? </return_message>
</server_response>
  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 R语言Rstudio突然无法启动
    • ¥15 关于#matlab#的问题:提取2个图像的变量作为另外一个图像像元的移动量,计算新的位置创建新的图像并提取第二个图像的变量到新的图像
    • ¥15 改算法,照着压缩包里边,参考其他代码封装的格式 写到main函数里
    • ¥15 用windows做服务的同志有吗
    • ¥60 求一个简单的网页(标签-安全|关键词-上传)
    • ¥35 lstm时间序列共享单车预测,loss值优化,参数优化算法
    • ¥15 Python中的request,如何使用ssr节点,通过代理requests网页。本人在泰国,需要用大陆ip才能玩网页游戏,合法合规。
    • ¥100 为什么这个恒流源电路不能恒流?
    • ¥15 有偿求跨组件数据流路径图
    • ¥15 写一个方法checkPerson,入参实体类Person,出参布尔值