技巧分享 PHP批量导出csv文件_PHP教程-php教程-PHP中文网

技巧分享 PHP批量导出csv文件_PHP教程

php中文网

发布： 2016-07-15 13:33:14

原创

837人浏览过

MacsMind

电商AI超级智能客服

131

查看详情

对于

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

下面只是PHP批量导出csv文件的主要程序部分：

立即学习“PHP免费学习笔记（深入）”；

?php
function getmicrotime(){
list($usec, $sec) = explode(” “,microtime());
return ((float)$usec + (float)$sec);
}
?>

立即学习“PHP免费学习笔记（深入）”；

<ol class="dp-xml"><li class="alt"><span><span class="tag"><</span><span> ?php  </span></span></li><li><span>$</span><span class="attribute">time_start</span><span> = </span><span class="attribute-value">getmicrotime</span><span>();  </span></li><li class="alt"><span>include(&rdquo;db.inc.php&rdquo;);//连接数据库  </span></li><li><span>$</span><span class="attribute">db</span><span>=</span><span class="attribute-value">new</span><span> testcsv;  </span></li><li class="alt"><span class="tag">?></span><span> </span></li><li><span class="tag"><</span><span> ?php  </span></li><li class="alt"><span>$</span><span class="attribute">handle</span><span> = </span><span class="attribute-value">fopen</span><span> (&rdquo;test.csv&rdquo;,&rdquo;r&rdquo;);  </span></li><li><span>$</span><span class="attribute">sql</span><span>=&rdquo;insert into scores(idcard,names<br />,num,sex,nation,score) values(&rsquo;&rdquo;;  </span></li><li class="alt"><span>while ($</span><span class="attribute">data</span><span> = </span><span class="attribute-value">fgetcsv</span><span> ($handle, 1000, &ldquo;,&rdquo;)) {  </span></li><li><span>$</span><span class="attribute">num</span><span> = </span><span class="attribute-value">count</span><span> ($data);  </span></li><li class="alt"><span>for ($</span><span class="attribute">c</span><span>=</span><span class="attribute-value">0</span><span>; $c </span><span class="tag"><</span><span> $num; $c++) {  </span></li><li><span>if($</span><span class="attribute">c</span><span>==$num-1){$</span><span class="attribute">sql</span><span>=$sql.$data[$c].&rdquo;&lsquo;)&rdquo;;break;}  </span></li><li class="alt"><span>$</span><span class="attribute">sql</span><span>=$sql.$data[$c].&rdquo;&lsquo;,&rsquo;&rdquo;;  </span></li><li><span>}  </span></li><li class="alt"><span>print &ldquo;</span><span class="tag"><</span><span> </span><span class="tag-name">br</span><span class="tag">></span><span>&rdquo;;  </span></li><li><span>echo $sql.&rdquo;</span><span class="tag"><</span><span> </span><span class="tag-name">br</span><span class="tag">></span><span>&rdquo;;  </span></li><li class="alt"><span>$db-</span><span class="tag">></span><span>query($sql);  </span></li><li><span>echo &ldquo;SQL语句执行成功！</span><span class="tag"><</span><span> </span><span class="tag-name">br</span><span class="tag">></span><span>&rdquo;;  </span></li><li class="alt"><span>$</span><span class="attribute">sql</span><span>=&rdquo;insert into scores(idcard,names<br />,num,sex,nation,score) values(&rsquo;&rdquo;;  </span></li><li><span>}  </span></li><li class="alt"><span>fclose ($handle);  </span></li><li><span>$</span><span class="attribute">time_end</span><span> = </span><span class="attribute-value">getmicrotime</span><span>();  </span></li><li class="alt"><span>$</span><span class="attribute">time</span><span> = $time_end &ndash; $time_start;  </span></li><li><span>echo &ldquo;程序执行时间：&rdquo;.$time.&rdquo;秒&rdquo;;  </span></li><li class="alt"><span class="tag">?></span><span> </span></li></ol>

登录后复制

希望大家通过以上PHP批量导出csv文件的代码示例能够掌握这一技巧。