Call to a member function bind_param() on boolean in

Question

It is working

$result = $conn->prepare("SELECT * FROM questions");
$result->execute();

But this not

$result = $conn->prepare("SELECT * FROM (?)");

$result -> bind_param("s", $name_tb);

$name_tb = "questions";
$result->execute();

The error is:

Call to a member function bind_param() on boolean

score 0 · Accepted Answer · answered Nov 30 '17 at 15:25

This won't work.

It is actually not possible to bind table names. You can only bind query parameters. What you can do is something like:

$table = "TABLENAME";
query($table);

function query($table) {
    $sql = "SELECT * FROM $table";
}

For sure you have to edit the content of the function that it'll work. Its just to show you an example. But keep in mind: No tablenames. Only parameters with bind.

Call to a member function bind_param() on boolean in

1 Answers1