如何使用php将带有unicode的excel文件csv支持导入mysql [英] How to import excel file csv support with unicode to mysql using php

问题描述

我使用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] [< span class =code-string> tmp_name];
if（

_FILES["file"]["tmp_name"]; if(

这篇关于如何使用php将带有unicode的excel文件csv支持导入mysql的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！