使用ECSHOP程序中的一个类.
<?php
define('IN_ECS', true);
require('../includes/init.php');
$handle = fopen("test.csv","r");
$data = fgetcsv($handle,1000,',');
while ($data = fgetcsv($handle, 1000, ",")) {
$company = charset($data[0]);
$address = charset($data[1]);
$telphone = charset($data[2]);
$url = charset($data[3]);
$brand = charset($data[4]);
$sql = "INSERT INTO " .$GLOBALS['ecs']->table('search_help'). " VALUES (null, '$company','$address','$telphone','$url','$brand')";
$res = $GLOBALS['db']->query($sql);
}
fclose($handle);
function charset($str) {return iconv('gb2312','utf-8', $str);}
?>
由于各种原因,我们无法获知[excel数据导入mysql方法的类]原创作者,如侵犯了您的版权,请您及时联系我们!