对我的 MSSQL 数据库执行 select 语句时删除前导零列

Question

大家好，我有 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}]

Answer 1

要仅返回数组中的关联键，请将参数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;