<!DOCTYPE html><html lang="th"><head>
<title>นำแฟ้ม .csv จาก data.go.th ไปฝากกับ thaiabc แล้วอ่านด้วย curl</title>
<meta charset="utf-8" /></head><body>
<table style="width:728px;margin-right:auto;margin-left:auto;border:1px solid black;">
<tr style="background-color:#dddddd;"><td>ลำดับ</td><td>ชื่อสมาคม</td><td>จังหวัด</td><td>ปี</td></tr>
<script>
<?php
$url_long = "http://www.thaiabc.com/travelassoc/lp67_22_009-.csv";
$curl = curl_init();
curl_setopt_array($curl, array(
CURLOPT_URL => $url_long,
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => "",
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 30,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => "GET",
CURLOPT_FOLLOWLOCATION => true,
CURLOPT_HTTPHEADER => ""
));
$response = curl_exec($curl);
curl_close($curl);
echo "var data = '\\\r\n";
$response = str_replace("\r\n",",\\"."\r\n",$response);
echo $response . "';";
?>
var array_data = data.split(",");
var seq = 1; var fld;
for(rows=2;rows<=13;rows++){
fld = rows * 3;
document.write('<tr><td>'+ (seq++) + '</td><td>' + array_data[fld - 1] + '</td>\
<td>' + array_data[fld - 2] + '</td><td>' + array_data[fld - 3] + '</td></tr>');
}
</script>
</table>
<div style="margin-left:auto;margin-right:auto;display:table;"><a href="index.php" title="back">back</a></div>
</body></html>
