ข้อมูลรูปแบบเจซัน (JSON = JavaScript Object Notation)

// เริ่มต้น curl
$ch = curl_init(); 
// set url สำหรับดึงข้อมูล 
curl_setopt($ch, CURLOPT_URL, "http://data.tmd.go.th/api/WeatherToday/V1/?type=json"); 
//return the transfer as a string 
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1); 
 // ตัวแปร $output เก็บข้อมูลทั้งหมดที่ดึงมา 
$output = curl_exec($ch); 
// ปิดการเชื่อต่อ
curl_close($ch);    
// output ออกไปครับ
echo $output;

// decode
	$string = strtoupper('\u0e01\u0e02\u0e04'); 
	$string = preg_replace('/\\\U([0-9A-F]+)/', '&#x$1;', $string); // ตัด string ที่ขึ้นต้นด้วย \U 
	echo html_entity_decode($string, ENT_COMPAT, 'UTF-8'); // เทียบ Unicode Character Ranges
	echo "<hr/>"; 
// decode
	$txt = json_encode("กขค");
	$txt = str_replace('"','',$txt);
	echo $txt; // \u0e01\u0e02\u0e04

Fields : 1) productid , 2) productname , 3) unitcost , 4) status , 5) listprice , 6) arttr1 , 7) itemid

{"total":28,"rows":[
	{"productid":"FI-SW-01","productname":"Koi","unitcost":"10.00","status":"P","listprice":"36.50","attr1":"Large","itemid":"EST-1"},
	{"productid":"K9-DL-01","productname":"Dalmation","unitcost":"12.00","status":"P","listprice":"18.50","attr1":"Spotted Adult Female","itemid":"EST-10"},
	{"productid":"RP-SN-01","productname":"Rattlesnake","unitcost":"12.00","status":"P","listprice":"38.50","attr1":"Venomless","itemid":"EST-11"},
	{"productid":"RP-SN-01","productname":"Rattlesnake","unitcost":"12.00","status":"P","listprice":"26.50","attr1":"Rattleless","itemid":"EST-12"},
	{"productid":"RP-LI-02","productname":"Iguana","unitcost":"12.00","status":"P","listprice":"35.50","attr1":"Green Adult","itemid":"EST-13"},
	{"productid":"FL-DSH-01","productname":"Manx","unitcost":"12.00","status":"P","listprice":"158.50","attr1":"Tailless","itemid":"EST-14"},
	{"productid":"FL-DSH-01","productname":"Manx","unitcost":"12.00","status":"P","listprice":"83.50","attr1":"With tail","itemid":"EST-15"},
	{"productid":"FL-DLH-02","productname":"Persian","unitcost":"12.00","status":"P","listprice":"23.50","attr1":"Adult Female","itemid":"EST-16"},
	{"productid":"FL-DLH-02","productname":"Persian","unitcost":"12.00","status":"P","listprice":"89.50","attr1":"Adult Male","itemid":"EST-17"},
	{"productid":"AV-CB-01","productname":"Amazon Parrot","unitcost":"92.00","status":"P","listprice":"63.50","attr1":"Adult Male","itemid":"EST-18"}
]}

header("content-type:text/html;charset=utf-8"); 
$curl = curl_init();
curl_setopt_array($curl, array(
CURLOPT_URL => "https://apigw1.bot.or.th/bot/public/Stat-SpotRate/v2/SPOTRATE/?start_period=2021-06-01&end_period=2021-06-07",
  CURLOPT_RETURNTRANSFER => true,
  CURLOPT_ENCODING => "",
  CURLOPT_MAXREDIRS => 10,
  CURLOPT_TIMEOUT => 30,
  CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
  CURLOPT_CUSTOMREQUEST => "GET",
  CURLOPT_HTTPHEADER => array(
    "accept: application/json",
    "x-ibm-client-id: xxxx"
  ),
));
$response = curl_exec($curl);
$err = curl_error($curl);
curl_close($curl);
if ($err) {
  echo "cURL Error #:" . $err;
} else {
  $thai_data = $response;
}
var_dump(json_decode($thai_data,true)); // array
$d = json_decode($thai_data,true); //array
echo "<hr/>";
foreach($d as $k => $v) {
	echo "<b>$k = $v</b><br/>"; 
	forarray($k,$d);
}
// -------------------
function forarray($k,$d) {
	if(is_array($d)) {
		foreach($d as $k => $v) { 
			if(is_array($v)) {
				forarray($k,$v);
			} else echo "<span style='color:blue;'>$k = $v</span><br/>"; 
		}
	} 
}

<meta charset="utf-8" /><!-- https://handsontable.com/docs/7.4.2/tutorial-quick-start.html -->
<script src="https://cdn.jsdelivr.net/npm/handsontable@7.4.2/dist/handsontable.full.min.js"></script>
<link href="https://cdn.jsdelivr.net/npm/handsontable@7.4.2/dist/handsontable.full.min.css" rel="stylesheet" media="screen">
<div id="example"></div>
<script>
var data = [
  ['', 'Ford', 'Tesla', 'Toyota', 'Honda'],
  ['2017', 10, 11, 12, 13],
  ['2018', 20, 11, 14, 13],
  ['2019', 30, 15, 12, 13]
];
var container = document.getElementById('example');
var hot = new Handsontable(container, {
  data: data,
  rowHeaders: true,
  colHeaders: true,
  filters: true,
  dropdownMenu: true,
  licenseKey: 'non-commercial-and-evaluation' // for non-commercial use only
});
</script>