大家好，我有 microsoft sql management studio 18，其中有一個數據庫。我正在通過 php 執行這樣的 select 語句： $conn = OpenCon(); $query = "SELECT id, name, picture, description, numberOfEngines FROM planes"; $result = sqlsrv_query($conn, $query); if ($result === false) { $status['status'] = "0"; echo json_encode($status); } else{ while($row = sqlsrv_fetch_array($result)) { $theRows[] = $row; } echo json_encode($theRows); } CloseCon($conn);這是輸出：[{"0":1,"id":1,"1":"114","name":"114","2":"airplane1.png","picture":"airplane1.png","3":"Cessna C525","description":"Cessna C525","4":1,"numberOfEngines":1},{"0":2,"id":2,"1":"115","name":"115","2":"airplane1.png","picture":"airplane1.png","3":"Cessna C525","description":"Cessna C525","4":1,"numberOfEngines":1},{"0":3,"id":3,"1":"124","name":"124","2":"airplane1.png","picture":"airplane1.png","3":"Cessna C208B","description":"Cessna C208B","4":1,"numberOfEngines":1},{"0":4,"id":4,"1":"125","name":"125","2":"airplane1.png","picture":"airplane1.png","3":"Cessna C208B","description":"Cessna C208B","4":1,"numberOfEngines":1}]我怎樣才能刪除那些出現兩次的重復項，例如“0”：1或ariplane.png。所以我的輸出將是這樣的：[{"id":1, "name":"114", "picture":"airplane1.png", "description":"Cessna C525", "numberOfEngines":1}]
1 回答
慕萊塢森
TA貢獻1810條經驗 獲得超4個贊
要僅返回數組中的關聯鍵，請將參數SQLSRV_FETCH_ASSOC作為fetchType參數傳遞給sqlsrv_fetch_array：
while?($row?=?sqlsrv_fetch_array($result,?SQLSRV_FETCH_ASSOC))?{這將為您提供一個包含以下條目的數組：
{"id":1,"name":"114","picture":"airplane1.png","description":"Cessna?C525","numberOfEngines":1}如果您確實想要其他數字鍵，請保持代碼不變并添加
unset($row[0])
前
$theRows[]?=?$row;
- 1 回答
- 0 關注
- 132 瀏覽
添加回答
舉報
0/150
提交
取消