Home  >  Article  >  Backend Development  >  PHP method to import csv files into mysql database

PHP method to import csv files into mysql database

墨辰丷
墨辰丷Original
2018-05-23 11:42:241971browse

This article mainly introduces the method of importing csv files into mysql database through PHP programming, involving PHP file reading, conversion, database connection, insertion and other related operating skills. Friends in need can refer to it

The details are as follows:

config.db.php content is as follows;

<?php
$username="root";
$userpass="123";
$dbhost="localhost";
$dbdatabase="credits2stakes";
//生成一个连接
$db_connect=mysql_connect($dbhost,$username,$userpass) or die("Unable to connect to the MySQL!");
//选择一个需要操作的数据库
mysql_select_db($dbdatabase,$db_connect);

index.php content is as follows:

<meta http-equiv="Content-Type"content="text/html; charset=utf-8" />
<form name="frm1" enctype="multipart/form-data" action="insertdb.php" method="post">
  <input name="filename" type="file" /><input name="submit" type="submit" value="import" />
</form>

insertdb.php content is as follows:

<?php
session_start();
header("Content-type:text/html;charset:utf-8");
//全局变量
$file=$_FILES[&#39;filename&#39;];
$max_size="2000000"; //最大文件限制(单位:byte)
$fname=$file[&#39;name&#39;];
$ftype=strtolower(substr(strrchr($fname,&#39;.&#39;),1));
//文件格式
$uploadfile=$file[&#39;tmp_name&#39;];
if($_SERVER[&#39;REQUEST_METHOD&#39;]==&#39;POST&#39;){
   if(is_uploaded_file($uploadfile)){
     if($file[&#39;size&#39;]>$max_size){
     echo "Import file is too large";
     exit;
     }
     if($ftype!=&#39;csv&#39;){
     echo "Import file type is error";
     exit;
     }
   }else{
   echo "The file is not empty!";
   exit;
   }
}
require("./config.db.php");  //连接mysql数据库
$row=0;
$filename=$file[&#39;tmp_name&#39;];
$handle=fopen($filename,&#39;r&#39;);
while(!feof($handle) && $data=fgetcsv($handle,1000,&#39;,&#39;)){
  $arr_result=array();
  if($row==0){
   $row++;
   continue;
  }
  if($row>0 && !empty($data)){
    $num=count($data);
    for($i=0;$i<$num;$i++){
    array_push($arr_result,$data[$i]);
   }
  //$name = iconv(&#39;gb2312&#39;,&#39;utf-8&#39;,$arr_result[1]);
  //$sex = iconv(&#39;gb2312&#39;,&#39;utf-8&#39;,$arr_result[2]);
  $sql="insert into inviter(inviter,invitees,time) value($arr_result[1],$arr_result[2],$arr_result[3])";
  //echo $sql;
  mysql_query("set names utf8");
  $result=mysql_query($sql);
  if($result){
    echo "插入成功!!!";
   }else{
    echo "插入失败!!!";
      }
   }
   $row++;
}
fclose($handle);
?>

##The above is the entire content of this article, I hope It will be helpful to everyone’s study.


Related recommendations:

php and js example of proportional scaling of database images_javascript skills

Javascript imitationPHP $_GET gets the parameters in the URL_javascript skills

JS version of the date function (and The date function of PHP is the same)_JavaScript

The above is the detailed content of PHP method to import csv files into mysql database. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn