有时写程序时后台要求把大量数据导入数据库中,比如计算机考试成绩的查询、电话簿的数据等一般都是存放在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('"; while ($data = fgetcsv ($handle, 1000, ",")) { $num = count ($data); for ($c=0; $c < $num; $c++) { if($c==$num-1){$sql=$sql.$data[$c]."')";break;} $sql=$sql.$data[$c]."','"; } print "<br>"; echo $sql."<br>"; $db->query($sql); echo "SQL语句执行成功!<br>"; $sql="insert into scores(idcard,names,num,sex,nation,score) values('";//开源代码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
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

AI Hentai Generator
Generate AI Hentai for free.

Hot Article
R.E.P.O. Energy Crystals Explained and What They Do (Yellow Crystal)
1 months agoBy尊渡假赌尊渡假赌尊渡假赌
R.E.P.O. Best Graphic Settings
1 months agoBy尊渡假赌尊渡假赌尊渡假赌
Assassin's Creed Shadows: Seashell Riddle Solution
2 weeks agoByDDD
R.E.P.O. How to Fix Audio if You Can't Hear Anyone
1 months agoBy尊渡假赌尊渡假赌尊渡假赌
R.E.P.O. Chat Commands and How to Use Them
1 months agoBy尊渡假赌尊渡假赌尊渡假赌

Hot Tools

EditPlus Chinese cracked version
Small size, syntax highlighting, does not support code prompt function

WebStorm Mac version
Useful JavaScript development tools

Safe Exam Browser
Safe Exam Browser is a secure browser environment for taking online exams securely. This software turns any computer into a secure workstation. It controls access to any utility and prevents students from using unauthorized resources.

SublimeText3 English version
Recommended: Win version, supports code prompts!

Zend Studio 13.0.1
Powerful PHP integrated development environment