我创建了一个csv到mysql数据库导入器。
include_once("connection.php");
if(isset($_POST["import"])){
$filename = $_FILES["file"]["tmp_name"];
if($_FILES["file"]["size"] > 0){
$file = fopen($filename, "r");
while(($column = fgetcsv($file,10000, ",")) !== FALSE){
$sqlInsert = "INSERT INTO datasets (name,email,phone) values('" . $column[0] . "', '". $column[1] . "', '" . $column[2] . "')";
$result = mysqli_query($con,$sqlInsert);
if(!empty($result)){
echo "CSV data imported into database !";
}
else{
echo "Error importing data into database ...";
}
}
}
}
?>
表格代码是-
Upload
Choose file
Submit
所以,我把意外数据标为红色。我不明白为什么会这样?代码有错误吗?