dpxf81245 2014-09-08 06:52
浏览 49
已采纳

致命错误:在非对象上调用成员函数bind_param()

I try some codes to build a RESTful API Web Service using PHP and slim framework. (I'm using Advanced Rest Client for testing this code)

This is my codes.

private function isUserExists($email) { $stmt = $this->conn->prepare("SELECT id from users WHERE email = ?"); $stmt->bind_param("s", $email); $stmt->execute(); $stmt->store_result(); $num_rows = $stmt->num_rows; $stmt->close(); return $num_rows > 0; }

and then I got this error.

Fatal Error : Call to a member function bind_param() on a non-object on Line 113

Line 113 is : $stmt->bind_param("s", $email);

I've been looking for a solution of this problem since 2 weeks ago.

Thanks before guys :))

  • 写回答

1条回答 默认 最新

  • dousao1175 2014-09-08 07:00
    关注

    The problem lies in $this->conn->prepare, which does not return an object, as you would expect.

    For mysqli, prepare() returns FALSE on error. You can check the error message using $this->conn->error.

    This code should print your error in case of failure:

    private function isUserExists($email) {
        $stmt = $this->conn->prepare("SELECT id from users WHERE email = ?");
        if ($stmt === FALSE){
            die($this->conn->error);
        } else  {
            $stmt->bind_param("s", $email);
            $stmt->execute();
            $stmt->store_result();
            $num_rows = $stmt->num_rows;
            $stmt->close();
            return $num_rows > 0;
        }
    }
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 我想在一个软件里添加一个优惠弹窗,应该怎么写代码
  • ¥15 fluent的在模拟压强时使用希望得到一些建议
  • ¥15 STM32驱动继电器
  • ¥15 Windows server update services
  • ¥15 关于#c语言#的问题:我现在在做一个墨水屏设计,2.9英寸的小屏怎么换4.2英寸大屏
  • ¥15 模糊pid与pid仿真结果几乎一样
  • ¥15 java的GUI的运用
  • ¥15 Web.config连不上数据库
  • ¥15 我想付费需要AKM公司DSP开发资料及相关开发。
  • ¥15 怎么配置广告联盟瀑布流