<?php
$dbhost;
$username;
$passwd;
$database;
$table;
$conn = mysql_connect("$dbhost","$username","$passwd");
mysql_select_db("$database",$conn);
mysql_query("SET NAMES UTF8");
$handle = fopen('$filename', 'r');
while($data = fgetcsv($handle, 4096, "/t")) {
$str ="INSERT INTO $table
VALUES ('$data[0]', '$data[1]', '$data[2]')";
mysql_query($str);
}
echo "导入成功";
?>
使用PHP将TXT导入MYSQ
最新推荐文章于 2021-03-09 22:52:56 发布