PHP中txt导入mysql代码

注意在导入时保持数据库教程的编码与txt文档编码尽量一样，要不可能出现乱码问题哦。

<?php教程
//验证文件类型和错误
if($_FILES["insert_first"]["type"] == "text/plain"){
 echo "第一步：文件类型上传正确"." ";
 if($_FILES["insert_first"]["error"]){
 echo "上传错误：".$_FILES["insert_first"]["error"]." ";
 }else{
 echo "文件名称:".$_FILES["insert_first"]["name"]." ";
 echo "文件类型:".$_FILES["insert_first"]["type"]." ";
 echo "文件大小:".($_FILES["insert_first"]["size"]/1024)."Kb ";
 echo "临时名称:".$_FILES["insert_first"]["tmp_name"]." ";
 }
}else{
 echo "上传文件格式不正确";
 exit;
}

//连接数据库
$con = new mysql教程i('localhost','s503440db0','td9928ps教程','s503440db0');
if(mysqli_connect_errno()){
echo "链接数据库失败";
exit;
}

//打开文件
$file = fopen($_FILES["insert_first"]["tmp_name"],"r") or exit("打开文件失败!");

var_dump($file);
echo " ";

while(!feof($file)){
//逐行分拆
$row = explode(",",fgets($file));
$row0 = $row[0];
$row1 = (string)$row[1];
echo "$row0"."---"."$row1"." ";

//判断记录是否存在
 $query1 = "select firstid from firstcategory where firstid=$row0";
 $query2 = "select firstname from firstcategory where firstname='$row1'";
 $result1 = $con->query($query1);
 $result2 = $con->query($query2);
 //判断行数
 $result1 = mysqli_num_rows($result1);
 $result2 = mysqli_num_rows($result2);


 if($result1){
 echo "行号{$row0}已存在 ";
 }elseif($result2){
 echo "分类{$row1}已存在 ";
 }else{
 $query = "insert into firstcategory (firstid,firstname) values ($row0,'音乐')";
 $result = $con->query($query);
 }
}
echo "导入结束，请检查数据是否正确 http://www.zhutiai.com ";

fclose($file);
$con->close();

?>

mysql数据库

"create table firstcategory (
          firstid int unsigned not null primary key,
                  firstname char(50) not null
                )";

补充：Php教程,Php应用