将文本文件中的数据插入mysqldb-white-php

Question

我试过这个代码，但我不能使用

    <?php
$con=mysqli_connect("localhost","root","","db_insert_txt");
// Check connection
if (mysqli_connect_errno()) {
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
else{
echo "rak connecté";
}
$lines = file('test.txt');  
$test = "";  
$insert_string = "INSERT INTO `test_txt`(`test`) VALUES"; 
$counter = 0; 
$maxsize = count($lines); 
foreach($lines as $line => $company) { 
$insert_string .= "('".$company."')"; 
$counter++; 
if($counter < $maxsize){ 
$insert_string .= ","; 
}//if 
}//foreach 
mysqli_query($insert_string) or die(mysqli_error());
mysqli_close($con);
?>

它给了我以下警告：

警告：mysqli_query（）要求参数1为mysqli，字符串给定

Answer 1

错误消息很好地描述了问题所在。

您需要将DB连接参数传递给查询：

mysqli_query($con, $insert_string);

也可用于以下用途：

mysqli_error($con);