01.<html>
02.<head>
03.<title>ThaiCreate.Com PHP & CSV To MySQL</title>
04.</head>
05.<body>
06.<?
07.copy($_FILES["fileCSV"]["tmp_name"],$_FILES["fileCSV"]["name"]);
08.
09.$objConnect = mysql_connect("localhost","root","root") or die("Error Connect to Database");
10.$objDB = mysql_select_db("customer");
11.
12.$objCSV = fopen("customer.csv", "r");
13.while (($objArr = fgetcsv($objCSV, 1000, ",")) !== FALSE) {
14. $strSQL = "INSERT INTO allrecords ";
15. $strSQL .="(retid,no,date,title,name,lastname,couta,namesale,codesale,model_car, color_car,engine,body,address,tumbon,aumpher,province,codeprovince,mobile, finance,career,careernote,insurance,booking,b_date,b_name,b_money,birthday, perid,carprice,type_bye,disprice,down,held,interest,paycount,payment,c_regis,regis, c_insurance,insured,berg,prb,premium,accessories,branch
16.) ";
17. $strSQL .="VALUES ";
18. $strSQL .="('".$objArr[0]."','".$objArr[1]."','".$objArr[2]."' ";
19. $strSQL .=",'".$objArr[3]."','".$objArr[4]."','".$objArr[5]."' ";
20. $strSQL .=",'".$objArr[6]."','".$objArr[7]."','".$objArr[8]."' ";
21. $strSQL .=",'".$objArr[9]."','".$objArr[10]."','".$objArr[11]."' ";
22. $strSQL .=",'".$objArr[12]."','".$objArr[13]."','".$objArr[14]."'";
23. $strSQL .=",'".$objArr[15]."','".$objArr[16]."','".$objArr[17]."' ";
24. $strSQL .=",'".$objArr[18]."','".$objArr[19]."','".$objArr[20]."' ";
25. $strSQL .=",'".$objArr[21]."','".$objArr[22]."','".$objArr[23]."' ";
26. $strSQL .=",'".$objArr[24]."','".$objArr[25]."','".$objArr[26]."' ";
27. $strSQL .=",'".$objArr[27]."','".$objArr[28]."','".$objArr[29]."' ";
28. $strSQL .=",'".$objArr[30]."','".$objArr[31]."','".$objArr[32]."' ";
29. $strSQL .=",'".$objArr[33]."','".$objArr[34]."','".$objArr[35]."' ";
30. $strSQL .=",'".$objArr[36]."','".$objArr[37]."','".$objArr[38]."' ";
31. $strSQL .=",'".$objArr[39]."','".$objArr[40]."','".$objArr[41]."' ";
32. $strSQL .=",'".$objArr[42]."','".$objArr[43]."','".$objArr[44]."','".$objArr[45]."' ) ";
33. $objQuery = mysql_query($strSQL);
34.}
35.fclose($objCSV);
36.
37.echo "Upload & Import Done.";
38.?>
39.</table>
40.</body>
41.</html>
