<?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>
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)