在PHP中转换关联数组 - Converting associative arrays in PHP

Converting associative arrays in PHP

本文关键字：关联数组转换 PHP | 更新日期: 2023-09-27

我一直在谷歌周围和搜索这个论坛，但我还没有找到一个解决方案，我需要实现。

我以这种形式从数据库中获取数组

Array
(
[0] => Array
    (
        [0] => af
        [1] => Afghanistan
    )
[1] => Array
    (
        [0] => al
        [1] => Algeria
    )
)

我需要它看起来像这样

Array
(
    [af] => Afghanistan
    [al] => Algeria
)

db是sql server，这是我用来获取数据的代码

$sQueryCountries = "SELECT Country_Code,Country_Name FROM Countries WHERE Client_Id = '$client_id'";
$params = array();
$options =  array( "Scrollable" => SQLSRV_CURSOR_KEYSET );
$rResultCountries = sqlsrv_query( $db, $sQueryCountries, $params, $options );
while ( $aRow = sqlsrv_fetch_array( $rResultCountries, SQLSRV_FETCH_NUMERIC ) )
{       
    $output[] = $aRow;      
}

取回循环中非常基本的数组构建

while ( $aRow = sqlsrv_fetch_array( $rResultCountries, SQLSRV_FETCH_NUMERIC ) )
{       
    $output[$aRow[0]] = $aRow[1];      
}

试试这个:

$res   = array();
foreach($your_array as $val){
   $res[$val[0]] = $val[1];
}
echo "<pre>";
print_r($res);