dt1888 2016-03-22 02:59
浏览 62
已采纳

为什么这个SQL语句失败了? 在非对象上调用成员函数bind_param()

I am running on Host Gator and using a mySQL backend, with phpMyAdmin as a GUI.

I am coding in PHP.

I have had no issues performing standard prepare statements, but all of a sudden, with my first delete statement, there seems to be an error. I cannot spot or debug it. The following code is where the error occurs.

    //Error occurs right here
    if(!($sql = $con->prepare("DELETE FROM quoteItems WHERE quoteID=?")))
    { echo "FAIL - Prepare failed: (" . $con->errno . ") " . $con->error;}

    if(!$sql->bind_param('i', $quoteID))
    {echo "FAIL - Binding parameters failed: (" . $sql->errno . ") " . $sql->error;}

    if(!$sql->execute())
    {echo "FAIL - Execute failed: (" . $sql->errno . ") " . $sql->error;}

The output of var_dump($quoteID); gives string "44" in my current situation.

The error message that is produced is FAIL - Prepare failed:(0) Fatal Error: Call to a member function bind_param() on a non-object

  • 写回答

1条回答 默认 最新

  • douwa1304 2017-02-08 20:59
    关注

    This question was correctly solved by @Sean in the comments under the OP.

    Is $con a valid mysqli object? Do you have DELETE rights for this db user?

    The user did not have DELETE rights - giving the user this right solved the issue. The $con object was a valid object.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 EEPROM,软件i2c
  • ¥500 求解读该段JS代码,需要知道是用干什么的
  • ¥20 qt4代码实现二进制文件读取显示,以及显示的内容进行搜索
  • ¥15 Labview获取LK-G3001数据
  • ¥15 我知道什么是混合树,但是怎么写代码啊
  • ¥50 开发板linux系统安装dpkg,apt函数库 有偿
  • ¥15 浏览器时间循环 交互事件和延时事件的 优先级与执行问题
  • ¥15 GD模块安装出错,libgd无法正常安装
  • ¥20 求有缘人帮我把笛卡尔坐标系转换为经纬度 有偿
  • ¥15 vue2中使用计算属性