将bind_param与MySQLi一起使用时出错[关闭]

Question

Why am I getting an error with this code?

$stmt = $mysqli->prepare(
    "INSERT INTO buku VALUES (
        NULL,
        (SELECT id_penerbit FROM penerbit WHERE nm_penerbit = ?),
        (SELECT id_pengarang FROM pengarang WHERE nm_pengarang = ?),
        (SELECT id_kategori FROM kategori WHERE nm_kategori = ?),
        (SELECT id_lemari FROM lemari WHERE nm_lemari = ?),
        ?, ?, ?, ?, ?, 0, ?");
$stmt->bind_param("ssssssisss", $penerbit, $pengarang, $kategori, $lemari, $judul, $isbn, $hal, $terbit, $bahasa, $sinopsis);
if($stmt->execute()) showAlert("Berhasil mengubah kategori", "success");
else showAlert($stmt->error);

The error I'm getting is:

Fatal error: Call to a member function bind_param() on a non-object in C:\xampp\htdocs\eperpus\admin\buku-tambah.php on line 34

Answer 1

You're calling ->bind_param() on a non-object - which means there was an error in creating the object ($stmt) and it returned false - as documented.

The only way to troubleshoot the problem would be to investigate why the ->prepare() call failed - an issue which is a tad bit hard to troubleshoot as an outsider with only access to one line of code:

$stmt = $mysqli->prepare("INSERT INTO buku VALUES (NULL, (SELECT id_penerbit FROM penerbit WHERE nm_penerbit = ?), (SELECT id_pengarang FROM pengarang WHERE nm_pengarang = ?), (SELECT id_kategori FROM kategori WHERE nm_kategori = ?), (SELECT id_lemari FROM lemari WHERE nm_lemari = ?), ?, ?, ?, ?, ?, 0, ?");

Edit: The query itself is bad, as it doesn't close the VALUES ( parenthesis. This was the issue.