PHP method to import csv files into mysql database-PHP Tutorial-php.cn

PHP method to import csv files into mysql database

墨辰丷

Release： 2023-03-27 16:12:01

Original

2006 people have browsed it

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);

Copy after login

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>

Copy after login

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);
?>

Copy after login

##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!