如何使用php将带有unicode的excel文件csv支持导入mysql
问题描述:
我使用Unicode(utf-8)将我的excel文件转换为CSV,但无法插入数据库。
newsendsms.php
--------------------------
I was convert my excel file to CSV with Unicode (utf-8) but it can't insert to database.
newsendsms.php
--------------------------
<?php
mysql_query("SET NAMES utf8");
if(isset($_POST["Import"])){
echo $filename = $_FILES["file"]["tmp_name"];
if($_FILES["file"]["size"]>0){
$file = fopen($filename, "r");
//$sql_data = "SELECT * FROM tblnewusersendsms";
while(($emapData = fgetcsv($file,10000, ",")) !==FALSE)
{
$emapData = mb_convert_encoding($emapData, "EUC-JP", "auto");
mysql_query("SET NAMES utf8");
$sql = "INSERT INTO tblnewusersendsms (ACC_NBR , TERMINAL_TYPE , CUST_NAME , CUST_TYPE , DEF_LANG_NAME , CREATED_DATE) VALUES ('$emapData[0]','$emapData[1]', '$emapData[2]', '$emapData[3]', '$emapData[4]', STR_TO_DATE('$emapData[5]','%m/%d/%Y'))";
mysql_query($sql);
$res = $conn->query($sql);
}
fclose($file);
echo '<div class="alert alert-success >
<button type="button" class="close" data-dismiss="alert">×</button>
<button type="button" class="close" data-dismiss="alert">×</button>
答
_POST [ 导入])){
echo
_POST["Import"])){ echo
filename =
filename =
_FILES [ file] [ tmp_name];
if(
_FILES["file"]["tmp_name"]; if(