今天才写好的 还热乎呢
功能就是讲excel中的数据通过PHPEXCEL读取出来 然后插入到数据库中
ini_set('memory_limit','100M');
/** Include path **/
set_include_path(get_include_path() . PATH_SEPARATOR . './Classes/');

/** PHPExcel_IOFactory */
include 'PHPExcel/IOFactory.php';

$inputFileName = './1.xls';
echo '加载 ',pathinfo($inputFileName,PATHINFO_BASENAME),' 使用 IOFactory
';
$objPHPExcel = PHPExcel_IOFactory::load($inputFileName);

echo '

---

';

$sheetData = $objPHPExcel->getActiveSheet()->toArray(null,true,true,true);

//连接数据库
$dsn = 'mysql:host=localhost;dbname=test';
$db = new PDO($dsn,'xxxxx','xxxxx');
$db->query('SET NAMES UTF8');
//循环写入数据
$i = 1;
foreach($sheetData as $k => $v){
$sql = "INSERT INTO 201208ftms_seller set num='$v[B]',part='$v[C]',province='$v[E]',city='$v[F]',name='$v[D]',status='1'";
$result = $db->exec($sql);
if(!$result)
die("第$i行出错!");
$i++;
}
echo '完成插入'.$i.'行';

上一篇:mysql 整型的一些信息 下一篇:快递查询API