mySQL fatal error - 无法弄清楚

Question

此 sql 查询出现以下错误:

Fatal error: Call to a member function bind_param() on a non-object in /home/runestak/public_html/php/deposit/depositTicket.php on line 84

$stmt = $conn->prepare("INSERT INTO ticketsDB (userID, depositWallet, depositAmount, depositCurrency, ingame-name) VALUES (?, ?, ?, ?, ?)");
$stmt->bind_param("sssss", $accountID, $depositWallet, $depositGP, $gameServer, $ingameName);

// set parameters and execute
$stmt->execute();

$stmt->close();
$conn->close();

我似乎无法弄清楚这个问题。

Answer 1

小心..namimg 列似乎您在列名称中使用减号..这可能会导致错误尝试在周围使用反引号

"INSERT INTO ticketsDB (userID, depositWallet, depositAmount, depositCurrency, `ingame-name`) VALUES (?, ?, ?, ?, ?)"

或者可能是你使用了错误的名称，例如你需要ingame_name