<?php
header(
"Content-Type:text/html;charset=utf-8"
);
$dir
=
$_POST
[
'exceldir'
];
require_once
'PHPExcel.php'
;
if
(!
file_exists
(
"$dir"
)) {
exit
(
"not found mb.xlsx.\n"
);
}
$reader
= PHPExcel_IOFactory::createReader(
'Excel2007'
);
$PHPExcel
=
$reader
->load(
"$dir"
);
$sheet
=
$PHPExcel
->getSheet(0);
$highestRow
=
$sheet
->getHighestRow();
$highestColumm
=
$sheet
->getHighestColumn();
require
(
"conf/dbconfig.php"
);
$link
= @mysql_connect(HOST, USER, PASS)
or
die
(
"数据库连接失败!"
);
mysql_select_db(DBNAME,
$link
);
for
(
$j
= 2;
$j
<=
$highestRow
;
$j
++) {
$name
=
$PHPExcel
->getActiveSheet()->getCell(
"A"
.
$j
)->getValue();
$telephone
=
$PHPExcel
->getActiveSheet()->getCell(
"B"
.
$j
)->getValue();
$fenzu
=
$PHPExcel
->getActiveSheet()->getCell(
"C"
.
$j
)->getValue();
$school
=
$PHPExcel
->getActiveSheet()->getCell(
"D"
.
$j
)->getValue();
$banji
=
$PHPExcel
->getActiveSheet()->getCell(
"E"
.
$j
)->getValue();
$sql
=
"INSERT INTO `drtable`(`id`, `name`, `telephone`, `fenzu`, `school`, `banji`) VALUES (null,'{$name}','{$telephone}','{$fenzu}','{$school}','{$banji}')"
;
mysql_query(
$sql
,
$link
);
}
unset(
$sheet
);
unset(
$PHPExcel
);
echo
"导入成功!"
;
unlink(
$dir
);
?>