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.

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

报告相同问题?

悬赏问题

  • ¥20 Yolov5训练报错
  • ¥15 Unity发布gzip压缩的webgl之后让浏览器可以正常显示画面
  • ¥15 有没有人知道这种提示怎么关?现在不做ts项目了不知道咋关了,求解,现在我以前的js项目都是这种提示了
  • ¥15 为什么mysql做了碎片化处理data_free还是很高
  • ¥15 single positional indexer is out-of-bounds
  • ¥15 LSTM 模型数据量需要多少?
  • ¥15 mysql数据抓包开发报表
  • ¥15 linux系统下安装office打不开
  • ¥20 rsync脚本分发错误,文件不齐全
  • ¥15 labview顺序结构与时间延时