01.<html>
02.<head>
03.<title>ThaiCreate.Com PHP & CSV To MySQL</title>
04.</head>
05.<body>
06.<?php
07.move_uploaded_file($_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("mydatabase");
11.
12.$objCSV = fopen($_FILES["fileCSV"]["name"], "r");
13.while (($objArr = fgetcsv($objCSV, 1000, ",")) !== FALSE) {
14. $strSQL = "INSERT INTO customer ";
15. $strSQL .="(CustomerID,Name,Email,CountryCode,Budget,Used) ";
16. $strSQL .="VALUES ";
17. $strSQL .="('".$objArr[0]."','".$objArr[1]."','".$objArr[2]."' ";
18. $strSQL .=",'".$objArr[3]."','".$objArr[4]."','".$objArr[5]."') ";
19. $objQuery = mysql_query($strSQL);
20.}
21.fclose($objCSV);
22.
23.echo "Upload & Import Done.";
24.?>
25.</table>
26.</body>
27.</html>
ช่วยกันสนับสนุนรักษาเว็บไซต์ความรู้แห่งนี้ไว้ด้วยการสนับสนุน 
