01.include('cp.th_name_id_key_uid.php');
02.$search = fopen('C:\Users\Public\THAIID\DataID.CSV', 'r');
03.if($search){
04.while(($data_id = fgetcsv($search)) !== false){
05. $insert = array();
06. foreach ($data_id as $thai_id){
07. $insert[] = iconv('TIS-620', 'UTF-8', $thai_id);
08.
09.
10.
11.
12.
13.
14.
15.
16. }
17. $sql = 'INSERT INTO tree (a1,a2,a3,a4,a5,a6,a7,a8,a9,a10,a11,a12,a13,a14,a15,a16,a17,a18,a19,a20,
18. a21,a22,a23,a24,a25,a26,a27,a28,a29,a30,a31,a32,a33,a34,a35,a36,a37,a38,a39) VALUES ("'.implode('","', $insert).'")';
19. $result = mysqli_query($conn, $sql) or die(mysqli_error($conn) . "<br>$sql");
20. if(!$result){
21. echo $conn->error;
22. exit();
23. }else{
24. echo "<script type='text/javascript'>";
25. echo "alert('เพิ่มข้อมูลเรียบร้อยแล้ว!!');";
26. echo "window.location='selectexcel2.php';";
27. echo "</script>";
28. }
29.}
30. fclose($f);
31.}
