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

　　下面只是主要程序部分：

<?php
/*****************************************
**********作者：冲星/arcow****************
********** *******************
**********php导入csv文件到数据库**********
**********同时计算程序执行时间***********
**********www.knowsky.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(‘";
}
fclose ($handle);
$time_end = getmicrotime();
$time = $time_end - $time_start;
echo "程序执行时间：".$time."秒";
?>

发表评论

网友评论

aabbcc 作者 访客 于 2008-11-08 14:09:09 澳洲留学中介北京留学中介法国留学中介韩国留学韩国留学中介合法留学中介荷兰留学中介荷兰预科留学服务留学公司留学咨询公司美国留学中介欧洲留学中介英国留学中介加拿大留学中介留学申请高中生留学|澳大利亚留学澳洲留学出国出国留学法国留学荷兰留学加拿大留学加拿大签证留学留学澳大利亚留学澳洲留学法国留学荷兰留学加拿大留学美国留学新加坡留学英国留学中介美国留学新加坡留学英国留学英国签证瑞典留学翻译公司翻译公司洁身器窃听器手机窃听器监听器手机监听器窃听器手机窃听器监听器手机监听器窃听器手机窃听器监听器手机监听器窃听器手机窃听器监听器手机监听器办证网上办证北京办证上海办证广州办证

onestoptown 作者 访客 于 2008-11-20 12:34:14 shoes online buy shoes sandal shoes slippers shoes ecco shoes rockport shoes.  steve madden shoes - puma shoes -   nike shoes   nike shoes replica   replica nike shoes.  air jordan shoes   replica watches rolex   replica watch - rolex watch - fake rolex watches.  oyster rolex   rolex watches -  replica watches -  replica rolex watches - rolex replica - watches online.  oyster rolex watch - quartz watch fake - nike shoes - nike shoes replica - replica nike shoes.  air jordan shoes - replica watches rolex - replica watch - rolex watch - fake rolex watches.  oyster rolex - rolex watches - replica watches - replica rolex watches - rolex replica - watches online.  oyster rolex watch - quartz watch fake -   best replica watches  rolex watches - replica watches - replica nike shoes - jordan shoes - watches online.  oyster rolex watch - quartz shoes fake -   nike shoeses

Replica Watches Jewelry Replica HandBags 作者 访客 于 2008-11-25 21:41:12 Replica Watches,Fake Watches,Replica Watch,Fake Watch,Wholesale Watches,Wholesale Replica Watches,Jewelry Watches,Replica Jewelry Watches.    Replica Watches, Replica Watches, Replica Designer Handbags, Replica Designer Handbags, Wholesale Replica Watches, Wholesale Replica Watches, Replica Watches, Replica Watches, Replica Handbags, Replica Handbags, Replica Watches, Replica Watches, Replica Watches, Replica Watches, Replica Watches, Replica Watches, Replica Watches, Replica Watches, Jewelry Wholesale, Jewelry Wholesale, Cartier Watches, Cartier Watches, Ebel Replica, Ebel Replica, Philip Stein Watch Replica, Philip Stein Watch Replica, Replica Accutron Watches, Replica Accutron Watches, Raymond Weil Watches, Raymond Weil Watches, Franck Muller Watches Replica, Franck Muller Watches Replica, Jacques Lemans Watch, Jacques Lemans Watch, Jaeger LeCoultre Replica Watches, Jaeger LeCoultre Replica Watches, Gucci Replica, Gucci Replica, Replica Oris Watch, Replica Oris Watch, Replica Emporio Armani Watches, Replica Emporio Armani Watches, Gucci Replica, Gucci Replica, Oris Replica, Oris Replica, Fake Piaget Watch, Fake Piaget Watch, Fake Gucci Watch, Fake Gucci Watch, Seiko Watches, Seiko Watches, Rolex Watch, Rolex Watch, Rolex Replica, Rolex Replica, Replica Omega, Replica Omega, Replica Chopard Watch, Replica Chopard Watch,

Replica Watches Jewelry Replica HandBags 作者 访客 于 2008-11-25 23:56:26 Replica Watches,Fake Watches,Replica Watch,Fake Watch,Wholesale Watches,Wholesale Replica Watches,Jewelry Watches,Replica Jewelry Watches.    Jewelry Wholesale, Jewelry Wholesale, Replica Watches, Replica Watches, Replica Watches, Replica Watches, Replica Watches, Replica Watches, Replica Watches, Replica Watches, Replica Watches, Replica Watches, Replica Watches, Replica Watches, Replica Watches, Replica Watches, Replica Watches, Replica Watches, Replica Handbag, Replica Handbag, luxury Raymond Weil Watches, luxury Raymond Weil Watches, Fake Concord Watch, Fake Concord Watch, Panerai Watches, Panerai Watches, Replica Cartier Watches, Replica Cartier Watches, Corum Replica Watch, Corum Replica Watch, Replica Jacques Lemans, Replica Jacques Lemans, Fake Panerai Watch, Fake Panerai Watch, Fake Rolex Watches, Fake Rolex Watches, Fake Piaget Watches, Fake Piaget Watches, Seiko Replica, Seiko Replica, Fake Gucci Watches, Fake Gucci Watches, Oris Watch, Oris Watch, Breguet Replica, Breguet Replica, A Lange Sohne Watches, A Lange Sohne Watches, Fake Oris, Fake Oris, Omega Watches, Omega Watches, Replica Montblanc Watch, Replica Montblanc Watch, Replica Chopard Watches, Replica Chopard Watches, Replica Franck Muller Watch, Replica Franck Muller Watch, Zenith Replica Watches, Zenith Replica Watches,

replica watches 作者 访客 于 2008-12-01 10:36:44 nike air jordan -  nike sneaker -   air force one shoes -   nike womens -   nike adidas -   buy nike.  nike sb  nike shox  men's puma shoes -   timberland shoe -   large shoes -   nike football shoes.  gucci shoes  nike max  Air jordan shoes -  james sneaker -   nike shoes -   women shoes -   adidas shoes -   nike king.  nike sneakers  nike shox shoes  puma shoes -   timberland boat shoes -   big shoes -   football shoes.  gucci man shoes  nike nash        swiss watch -  sport shoe -   replica watches -   sports shoes -   designer clothes -  jewelry watches -  replica shoes -   watch repair -   buy sport shoes -   clothing store -     footwear.  nike dunk  replica bag  jewelry watch -   fashion bag -   seiko watch -   replica watch.  timex watch  prada shoes      replica rolex watches-   swiss     replica watches  clothing store  swiss     replica watch  replica     Gucci watch  replica     rolex watch  replica watches  Replica Handbags  Rolex Sports Models        nike james shoes  nike max  Areplica watches -  james sneaker -   swiss watch -   replica shoes -   clothes store

beautiful 作者 访客 于 2008-12-12 11:09:23 nike air jordan -  nike sneaker -   air force one shoes -   nike womens -   nike adidas -   buy nike.  nike sb  nike shox  men's puma shoes -   timberland shoe -   large shoes -   nike football shoes.  gucci shoes  nike max  Air jordan shoes -  james sneaker -   nike shoes -   women shoes -   adidas shoes -   nike king.  nike sneakers  nike shox shoes  puma shoes -   timberland boat shoes -   big shoes -   football shoes.  gucci man shoes  nike nash  replica rolex watches-   swiss replica watches  clothing store  swiss replica watch  replica Gucci watch  replica rolex watch  replica watches  Replica Handbags  Rolex Sports Models      swiss watch -  sport shoe -   replica watches -   sports shoes -   designer clothes -  jewelry watches -  replica shoes -   watch repair -   buy sport shoes -   clothing store -       footwear.  nike dunk  replica bag  jewelry watch -   fashion bag -   seiko watch -   replica watch.  timex watch  prada shoes      nike james shoes  nike max  Areplica watches -  james sneaker -   swiss watch -   replica shoes -   clothes storec  [URL=http://www.uggforsale.us/]UGG Upside Mocha Boots   UGG Wilshire Signature Boots   ugg tall   ugg shoes online   sheepskin shoes   ugg online   ugg shoes  Ugg Boots ecommerce   UGG Classic Tall   UGG Crochet Tall Boots   Ugg Australia Classic Short   UGG Australia Boots   uggz   australian uggs   uggs shoes   uggs  ugg   cheap uggs   classic short uggs   classic tall uggs   where to buy uggs   discount uggs   women's uggs  sheepskin uggs   UGG Ultimate Cuff Boots  UGG Crochet Tall BootsUGG Suburb Crochet Boots   UGG Australia Boots   Sienna Miller Ugg Boots  Classic Tall Sand Boots   where to buy uggs   discount uggs   women's uggs  sheepskin uggs

langlang 作者 访客 于 2008-12-17 16:04:42 fashion tiffanyforsale -   women's tiffany tiffany lamp -   tiffany evans   tiffany towers   tiffany lighting.  meyda tiffany   dale tiffany   tiffany selby  tiffany table   tiffany towers -   tiffany amber -   tiffany fallon     watch china  watch net  dkny watch   online watchs  gents watches   panerai watch.  replica watches  shoes online buy shoes sandal shoes slippers shoes ecco shoes rockport shoes.  steve madden shoes -   puma shoes -    Replica Handbags  Rolex Sports Models  nike shoes   nike shoes replica   replica nike shoes.  air jordan shoes   replica watches rolex   replica watch -   rolex watch   fake rolex watches.  oyster rolex   rolex watches -  replica watches -  replica rolex watches -   rolex replica   watches online.  oyster rolex watch -   quartz watch fake   nike shoes -   nike shoes replica -   replica nike shoes.  air jordan shoes -   replica watches rolex -   replica watch -   rolex watch -   fake rolex watches.  oyster rolex -   rolex watches -   replica watches -   replica rolex watches -   rolex replica -   watches online.  oyster rolex watch -   quartz watch fake -   best replica watches  rolex watches -   replica watches -   replica nike shoes - jordan shoes -   watches online.  oyster rolex watch -   quartz shoes fake -   nike shoeses  UGG shoes sale  Wholesale UGG shoes   women UGG shoes sale   online UGG shoes sale   Wholesale Latest UGG shoes onlin   Latest UGG shoes online sale.  online UGG shoes sale - Latest UGG shoes online sale -   Wholesale UGG shoes   UGG shoes sale   women UGG shoes sale.  UGG shoes sale   Wholesale UGG shoes online   Latest UGG shoes online sale  Wholesale Latest UGG shoes onlin     UGG shoes sale -   UGG shoes online sale -   UGG shoes   UGG shoes sale   women UGG shoes.  UGG sale   Wholesale UGG shoes   Latest UGG shoes  UGG shoes online   uggs for sale   sheepskin uggs.  classic short uggs 1 - 3 ￥13.04   ugg shoes online   where to buy uggs  ugg online   womens uggs  genuine uggs

作者 访客 于 2008-12-17 16:32:47 nike air jordan -   nike james shoes -   nike shoes -   nike womens -   nike adidas -   buy nike -   nike sb -   nike shox.  puma shoes.  timberland boat shoes  large shoes  nike football shoes  gucci shoes  nike max  Air jordan shoes -   james sneaker -   air force one shoes -   women shoes -   adidas shoes -   nike king -   nike sneakers -   nike shox shoes.  men's puma shoes.  timberland shoe  big shoes  football shoes  gucci man shoes  nike nash  replica rolex watches -   breitling replica watches  cheap replica watches  swiss replica watch  best replica watches  replica rolex watch  wholesale replica watches   replica watches for sale  ugg shoes  Ugg Boots ecommerce  UGG Classic Tall  UGG Crochet Tall Boots  Ugg Australia Classic Short  UGG Australia Boots  uggz  australian uggs  uggs shoes .  uggs  fashion tiffanyforsale   women's tiffany tiffany lamp   tiffany evans  tiffany towers  tiffany lighting  meyda tiffany  dale tiffany   tiffany selby   tiffany table  tiffany towers  tiffany amber  tiffany fallon  classic short uggs   uggs for sale   sheepskin uggs   ugg shoes online   where to buy uggs   ugg online   womens uggs.  genuine uggs  swiss watch -   replica watch forum  swiss replica watch  swiss replica watches  sport shoe -  air jordan retro shoes  new air jordan shoes  nike air jordan shoes   replica watches -   replica Omega watch  replica BVLGARI   watch  replica rolex watch  sports shoes -   adidas shoes  adidas mens shoes  sheepskin shoes  australia shoes  designer clothes -   NBA Jerseys  NFL Jerseys  NHL Jerseys  footwear.  nike dunk  replica bag  jewelry watch  fashion bag  seiko watch  timex watch  prada shoes   nike shoes.  nike james shoes.  replica watches  nike adidas  swiss watch  replica shoes  designer clothes  UGG Upside Mocha Boots  UGG Wilshire Signature Boots  ugg tall  ugg shoes online   sheepskin shoes  ugg online

fghdfgj 作者 访客 于 2009-01-09 15:09:33 澳洲留学中介北京留学中介法国留学中介韩国留学韩国留学中介合法留学中介荷兰留学中介荷兰预科留学服务留学公司留学咨询公司美国留学中介欧洲留学中介英国留学中介加拿大留学中介留学申请高中生留学|澳大利亚留学澳洲留学出国出国留学法国留学荷兰留学加拿大留学加拿大签证留学留学澳大利亚留学澳洲留学法国留学荷兰留学加拿大留学美国留学新加坡留学英国留学中介美国留学新加坡留学英国留学英国签证瑞典留学翻译公司翻译公司洁身器窃听器手机窃听器监听器手机监听器窃听器手机窃听器监听器手机监听器窃听器手机窃听器监听器手机监听器办证网上办证北京办证上海办证广州办证

发表评论
用户	访客
标题
BBCode:
评论