| 代码如下 | 复制代码 |
|
require_once './includes/reader.php'; // excelfile($filename, $encoding); $data = new spreadsheet_excel_reader(); // set output encoding. $data->setoutputencoding('gbk'); //"data.xls"是指要导入到mysql中(的)excel文件 $data->read('date.xls'); @ $db = mysql_connect('localhost', 'root', '1234') or die("could not connect to database.");//连接数据库 mysql_query("set names 'gbk'");//输出中文 mysql_select_db('wenhuaedu'); //选择数据库 error_reporting(e_all ^ e_notice); for ($i = 1; $i <= $data->sheets[0]['numrows']; $i++) { //以下注释(的)for循环打印excel表数据 for ($j = 1; $j <= $data->sheets[0]['numcols']; $j++) { echo $data->sheets[0]['cells'][$i][$j].","; } echo "n"; //ttp://sourceforge.net/projects/phpexcelreader |
|
//下面为导入程序，注明，mysql数据库结构要与xls文档的结构一样就可以了。
| 代码如下 | 复制代码 |
|
$data = new spreadsheet_excel_reader(); $data->setoutputencoding('utf-8');//设置编码 $data->read('test.xls');//excel,csv文件位置 error_reporting(e_all ^ e_notice); for ($i = 2; $i <= $data->sheets[0]['numrows']; $i++) {//插入数据库开始 //插入数据库结束 |
|
}
//把csv导入到数据库。
| 代码如下 | 复制代码 |
|
function getmicrotime(){ list($usec, $sec) = explode(" ",microtime()); return ((float)$usec + (float)$sec); } $time_start = getmicrotime(); include ("connectdb.php"); function insert_data ($id,$summary,$description,$additional_information,$category) { $my_query1 = "insert into mantis_bug_text_table (id,description,additional_information) values ('$id','$description','$additional_information')"; $first = mysql_query($my_query1); $my_query2 = "insert into mantis_bug_table (id,project_id,summary,bug_text_id) values ('$id','$category','$summary','$id')"; $second = mysql_query($my_query2); return; } $fp = fopen("test.csv","r"); while($data = fgetcsv($fp,'1000',',')){ insert_data ($data[0],$data[1],$data[2],$data[3],$data[4]); echo "<font color = #ff0000 size = 20>数据导入成功！</font><br><br>"; } fclose ($fp); $time_end = getmicrotime(); $time = $time_end - $time_start; echo "程序执行时间：".$time."秒"; |
|