search
Homephp教程php手册php中数据的批量导入csv文件代码

有时写程序时后台要求把大量数据导入数据库中,比如计算机考试成绩的查询、电话簿的数据等一般都是存放在excel中的,这时我们可把数据导出成csv文件,然后通过以下程序即可在后台批量导入数据到数据库中.

下面只是主要程序部分,代码如下:

<?php  
	/***************************************** 
	**********作者:冲星/arcow**************** 
	**********njj@nuc.edu.cn******************* 
	**********php导入csv文件到数据库********** 
	**********同时计算程序执行时间*********** 
	**********www.phprm.com*********** 
	****************************************/ 
	//定义获取时间函数  
	function getmicrotime(){  
	    list($usec, $sec) = explode(" ",microtime());  
	    return ((float)$usec + (float)$sec);  
	} 
	 
	<?php 
	$time_start = getmicrotime(); 
	include("db.inc.php");//连接数据库 
	$db=new testcsv; 
	 
	 
	<?php 
	$handle = fopen ("test.csv","r"); 
	$sql="insert into scores(idcard,names,num,sex,nation,score) values(&#39;"; 
	while ($data = fgetcsv ($handle, 1000, ",")) { 
	   $num = count ($data); 
	   for ($c=0; $c < $num; $c++) { 
	       if($c==$num-1){$sql=$sql.$data[$c]."&#39;)";break;} 
	       $sql=$sql.$data[$c]."&#39;,&#39;"; 
	   } 
	print "<br>"; 
	echo $sql."<br>"; 
	$db->query($sql); 
	echo "SQL语句执行成功!<br>"; 
	$sql="insert into scores(idcard,names,num,sex,nation,score) values(&#39;";//开源代码phprm.com 
	} 
	fclose ($handle); 
	$time_end = getmicrotime(); 
	$time = $time_end - $time_start; 
	echo "程序执行时间:".$time."秒"; 
	

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

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

AI Hentai Generator

AI Hentai Generator

Generate AI Hentai for free.

Hot Article

R.E.P.O. Energy Crystals Explained and What They Do (Yellow Crystal)
2 weeks agoBy尊渡假赌尊渡假赌尊渡假赌
Repo: How To Revive Teammates
1 months agoBy尊渡假赌尊渡假赌尊渡假赌
Hello Kitty Island Adventure: How To Get Giant Seeds
4 weeks agoBy尊渡假赌尊渡假赌尊渡假赌

Hot Tools

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Atom editor mac version download

Atom editor mac version download

The most popular open source editor

ZendStudio 13.5.1 Mac

ZendStudio 13.5.1 Mac

Powerful PHP integrated development environment

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

Dreamweaver Mac version

Dreamweaver Mac version

Visual web development tools