EXCEL 写放MYSQL

error_reporting( E_ALL&~E_NOTICE );
header('Content-Type: text/html;charset=utf-8');
//<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
//连接数据库文件
$connect=mysql_connect("localhost","root","") or die("链接数据库失败!");
//连接数据库(ashley)
mysql_select_db("ashley",$connect) or die (mysql_error());
 
require_once 'Classes/PHPExcel.php';  
require_once 'Classes/PHPExcel/Reader/Excel2007.php';  
require_once 'Classes/PHPExcel/Reader/Excel5.php';  
include_once 'Classes/PHPExcel/IOFactory.php';  
 
//$objReader = PHPExcel_IOFactory::createReader ('Excel2007');
$objReader=PHPExcel_IOFactory::createReader('Excel5');//use excel2007 for 2007 format
 
$objReader->setReadDataOnly ( true );  

$file_url="aA.xls";
$objPHPExcel = $objReader->load ($file_url);  
//ECHO 'FDFD';DIE;
//$objWorksheet = $objPHPExcel->getActiveSheet ();  
$objWorksheet = $objPHPExcel->getSheet (0);  

//取得excel的总行数  
$highestRow = $objWorksheet->getHighestRow ();  
//取得excel的总列数  
$highestColumn = $objWorksheet->getHighestColumn ();  
$highestColumnIndex = PHPExcel_Cell::columnIndexFromString ( $highestColumn );  

//echo $highestColumnIndex;die;

$excelData = array ();  
for($row = 3; $row <= $highestRow; $row++) {  
    for($col = 1; $col < $highestColumnIndex; $col++) {  
        $excelData[$row-2][] = $objWorksheet->getCellByColumnAndRow ( $col, $row )->getValue ();  
    }  
}  

//echo "<pre>";
//print_r($excelData);  
//echo "</pre>";die;

foreach($excelData as $val)
{

    //echo $val[1].'<br/>';
    $sql="INSERT INTO bedding VALUES (
    '',
    '$val[0]',
    '$val[1]',
    '$val[2]',
    '$val[3]',
    '$val[4]',
    '$val[5]',
    '$val[6]',
    '$val[7]',
    '$val[8]',
    '$val[9]',
    '$val[10]',
    '$val[11]',
    '$val[12]',
    '$val[13]',
    '$val[14]',
    '$val[15]',
    '$val[16]',
    '$val[17]',
    '$val[18]',
    '$val[19]',
    '$val[20]',
    '$val[21]',
    '$val[22]',
    '$val[23]',
    '$val[24]',
    '$val[25]',
    '$val[26]')";
    
    //echo $sql;die;
mysql_query("SET NAMES UTF8");
mysql_query($sql) or die (mysql_error());

if (!mysql_error());
{
echo " 成功导入数据!";
}
echo $string[4]."\n";
unset($string);    
}
//unlink($file_url); //删除excel文件


  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值