HTTP错误500 mysql php？

问题描述：

我尝试插入一些数据，但我得到HTTP错误500不知道为什么。我看到问题开始于当我准备查询。我尝试从txt文件插入多行。HTTP错误500 mysql php？

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

'$ mysqli'或'$ conn'？ –

不明白，$ mysqli我认为我不知道确切的是问题 –

你知道你在__你的code__中有'$ conn'和'$ mysqli'变量吗？你明白他们之间的区别吗？ –

答

我需要将它定义

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

HTTP错误500 mysql php？

相关推荐