为什么这个SQL语句失败了？ 在非对象上调用成员函数bind_param（）

Question

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

Answer 1

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.