php - HTTP错误500 mysql php？

我尝试插入一些数据，但是我收到HTTP错误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");

最佳答案

我需要定义它

$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");

关于php - HTTP错误500 mysql php？，我们在Stack Overflow上找到一个类似的问题：https://stackoverflow.com/questions/45377229/