這是我的 PHP 代碼：
<?php
include 'connection.php';
$result = $connection->prepare ("SELECT * FROM daftar_mobil");
$result->execute();
while($row = $result->fetch(PDO::FETCH_ASSOC)){
$response['status']= true;
$response['message']='Data Tersedia';
$response['data'] = [
'no_plat' => $row['no_plat'],
'tipe_kendaraan' => $row['tipe_kendaraan'],
'id_alat'=> $row['id_alat']
];
}
$json = json_encode($response, JSON_PRETTY_PRINT);
echo $json;
?>
這是輸出：（輸出不顯示所有資料。只顯示表中的最后一行資料）
{ "status": true, "message": "Data Tersedia", "data": { "no_plat": "AB7786DE", "tipe_kendaraan": "XENIA", "id_alat": "12" } }
uj5u.com熱心網友回復：
將每行結果推送到一個陣列上，并對其進行編碼。
<?php
include 'connection.php';
$result = $connection->prepare ("SELECT * FROM daftar_mobil");
$result->execute();
$responses = [];
while($row = $result->fetch(PDO::FETCH_ASSOC)){
$response = [
'status' => true,
'message' => 'Data Tersedia',
'data' => [
'no_plat' => $row['no_plat'],
'tipe_kendaraan' => $row['tipe_kendaraan'],
'id_alat'=> $row['id_alat']
]
];
$responses[] = $response;
}
$json = json_encode($responses, JSON_PRETTY_PRINT);
echo $json;
?>
轉載請註明出處，本文鏈接：https://www.uj5u.com/yidong/396410.html
上一篇：Laravel包基礎關系模型