php - mysql php HTTP 错误 500？

Question

我尝试插入一些数据，但我收到 HTTP ERROR 500 不知道为什么。我在准备查询时看到问题开始。我尝试从 txt 文件插入多行。

$conn = new mysqli("localhost", "***", "****", "***");
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}

    $contents = file_get_contents("cars.txt");
    $pollfields = explode(',', $contents);

    $query = "INSERT INTO table (`name`) VALUES (?)";

    $zz = $mysqli->prepare($query);

    $zz ->bind_param("s", $bb);

    $mysqli->query("START TRANSACTION");
    foreach ($pollfields as $bb) {
        $zz->execute();
    }
    $zz->close();
    $mysqli->query("COMMIT");

Answer 1

我需要定义它

$conn = new mysqli("localhost", "***", "****", "***");
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}

    $contents = file_get_contents("cars.txt");
    $pollfields = explode(',', $contents);

    $query = "INSERT INTO table (`name`) VALUES (?)";

    $zz = $conn->prepare($query);

    $zz ->bind_param("s", $bb);

    $conn->query("START TRANSACTION");
    foreach ($pollfields as $bb) {
        $zz->execute();
    }
    $zz->close();
    $mysqli->query("COMMIT");