1.下载phpExcelReader.zip 文件
wget http://jaist.dl.sourceforge.net/project/phpexcelreader/Spreadsheet_Excel_Reader/Interim%20update/phpExcelReader.zip
2.修改phpExcelReader下载后的配置文件
A: 修改reader.php 配置文件
require_once 'oleread.inc';
B:修改example.php文件
$data->setOutputEncoding('utf8');
C:修改example2.php
$table_output[$sheet] .= nl2br(htmlspecialchars($data->sheets[$sheet]['cells'][$row][$col]));
3.设计数据库表
Create Table |
CREATE TABLE `costa_shakeshake_coupons` ( `id` int(11) NOT NULL AUTO_INCREMENT, `activity_name` varchar(1024) DEFAULT NULL, `digital_qcode` varchar(20) DEFAULT NULL, `qcode_image` varchar(255) DEFAULT NULL, `coupon_type` varchar(64) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=739 DEFAULT CHARSET=utf8mb4 |
4.编写代码
<?php
require_once 'Excel/reader.php'; //导入类文件$data = new Spreadsheet_Excel_Reader(); //实例化对象
$data->setOutputEncoding('utf8'); //设置输出字符集
$data->read('B1G1_5001.xls'); //读取excel文件
$conn = mysql_connect("localhost","root","123456"); //数据库连接
mysql_query("set names utf8mb4");
mysql_select_db('kmsocial_weixin_costa');
error_reporting(E_ALL ^ E_NOTICE);
$array = array(); //创建一个空数组
/*读取excel文件内容到数组中*/
for ($i = 1;$i<=$data->sheets[0]['numRows'];$i++){
for ($j = 1;$j<=$data->sheets[0]['numCols'];$j++){
$array[$i][$j] = $data->sheets[0]['cells'][$i][$j];
}
}
//var_dump($array);
$number=1;
foreach($array as $k => $val) {
//echo $val['1'] .' '.$val['2'];
$file_name="B1G1_image";
$file_type='.png';
$txt=sprintf("%03d",$number);
$file=$file_name . $txt . $file_type; //拼接图片文件名
$sql = "INSERT INTO costa_shakeshake_coupons(activity_name,digital_qcode,qcode_image,coupon_type)VALUES('$val[1]','$val[2]','$file','B1G1')";
if (!mysql_query($sql,$conn)) {
die('Error: '. mysql_error());
}
$number++;
}
mysql_close($conn);
?>