php - bind_param() 函数出错

Question

此代码记录某个目录中的所有文件名。文件名将存储到特定的数据库表中。这是我的代码

<?php
$user_dir = "fetz/";
$table_name = "fetz";
$connect = mysqli_connect("localhost", "root", "", "mdrsusr");
if(!$connect) {die();}
foreach (glob("$user_dir*.txt") as $filename) {
    echo $filename."<br />";
    $query = $connect->prepare("INSERT INTO ? SET img_link='?'");
    $query->bind_param("ss", $table_name, $filename); //this part *
    if(!$query) {die();}
    $query->execute();
}
$query->close();
$connect->close();
?>

* - 这部分有一个错误，指出

Fatal error: Call to a member function bind_param() on a non-object

Answer 1

您的查询中存在语法错误，导致您没有有效的 mysqli 语句对象。

INSERT INTO ? SET img_link='?'

应该是(您不需要参数周围的引号)

INSERT INTO ? SET img_link=?