将excel文件导入数据库,很简单,但是不会的却很愁人,在网上游荡好久,终于找到一个好方法,经过改进,终于可以使用了,方法很简单,也很实用,现与大家分享:
首先将excel文件导成 csv 文件(方法:另存为,选csv格式就可以了),
然后以附件程序即可导入excel文件了
<?php
$hostname = 'localhost';
$username = 'root';
$password = '';
$dbname = 'php';
$connect = mysql_connect($hostname,$username,$password);
mysql_select_db("$dbname",$connect);
//使用时请将下面编码自动设计
//mysql_query("SET character_set_connection=utf8, character_set_results=utf8, character_set_client=binary", $connect);
$f = file("1.csv");
for($i=0;$i<count($f);$i++)
{
$aaa=explode(",",$f[$i]);
$str="insert into php_content(catid,title,userid,status,searchid) values ('31','$aaa[0]',1,99,6)";
mysql_query($str);
$iid = mysql_insert_id();
$str1="insert into php_c_news(contentid,fuzeren,tel,address,zhiwei,riqi) values ('$iid','$aaa[1]','$aaa[2]','$aaa[3]','$aaa[4]','$aaa[5]')";
mysql_query($str1);
$str2="insert into php_content_count(contentid) values ('$iid')";
}
?>
首先将excel文件导成 csv 文件(方法:另存为,选csv格式就可以了),
然后以附件程序即可导入excel文件了
<?php
$hostname = 'localhost';
$username = 'root';
$password = '';
$dbname = 'php';
$connect = mysql_connect($hostname,$username,$password);
mysql_select_db("$dbname",$connect);
//使用时请将下面编码自动设计
//mysql_query("SET character_set_connection=utf8, character_set_results=utf8, character_set_client=binary", $connect);
$f = file("1.csv");
for($i=0;$i<count($f);$i++)
{
$aaa=explode(",",$f[$i]);
$str="insert into php_content(catid,title,userid,status,searchid) values ('31','$aaa[0]',1,99,6)";
mysql_query($str);
$iid = mysql_insert_id();
$str1="insert into php_c_news(contentid,fuzeren,tel,address,zhiwei,riqi) values ('$iid','$aaa[1]','$aaa[2]','$aaa[3]','$aaa[4]','$aaa[5]')";
mysql_query($str1);
$str2="insert into php_content_count(contentid) values ('$iid')";
}
?>