for 迴圈天然擁有計數器 $i,while 迴圈需自行宣告變數累加。本文示範從資料庫撈資料並建立 JSON 陣列時的計數寫法。
<?php
$link = mysql_connect('localhost', 'root', 'pwd');
mysql_select_db('db');
$sql = "SELECT region_id, local_name FROM regions WHERE region_grade = 1";
$result = mysql_query($sql);
$i = 0;
$list = [];
while ($row = mysql_fetch_assoc($result)) {
$list[$i]['text'] = $row['local_name'];
$list[$i]['value'] = $row['region_id'];
$i++;
}
$list = json_encode($list);
echo $list;
mysqli 或 PDO(支援預處理、物件導向)。$list[] = ['text' => $row['local_name'], 'value' => $row['region_id']]; 自動產生數值索引,無需手動 $i++。echo json_encode($list, JSON_UNESCAPED_UNICODE);<?php
$pdo = new PDO('mysql:host=localhost;dbname=db;charset=utf8mb4', 'root', 'pwd');
$stmt = $pdo->query("SELECT region_id, local_name FROM regions WHERE region_grade = 1");
$list = [];
while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
$list[] = [
'text' => $row['local_name'],
'value' => $row['region_id'],
];
}
header('Content-Type: application/json; charset=utf-8');
echo json_encode($list, JSON_UNESCAPED_UNICODE);
while 迴圈計數只需 $i = 0; while(...) { ... $i++; },但現代 PHP 建議用陣列 [] 自動索引 + PDO,程式碼更簡潔安全。