php - 如何在 PHP 中将 mysql_fetch_assoc 数组转换为 [column,column] 格式

Question

这是我的功能

$dataArray = array();
$results = mysqli_query($mysqli, ("SELECT CONCAT ('US-',  medicare_provider_charge_inpatient_drg100_fy2011.`Provider State`) AS `Provider State`,
                                        sum(ROUND(medicare_provider_charge_inpatient_drg100_fy2011.`Total Discharges`, 2)) AS `Total Discharges`
                                        FROM medicare_provider_charge_inpatient_drg100_fy2011
                                        WHERE medicare_provider_charge_inpatient_drg100_fy2011.`Provider Name` LIKE '%" . $hospital_name . "'
                                        GROUP BY CONCAT ('US-',  medicare_provider_charge_inpatient_drg100_fy2011.`Provider State`)"));
while ($row = mysqli_fetch_assoc($results)) {
    $dataArray[] = $row;
}

我想以以下格式显示数据

[Provider State, Total Discharges],
[US-AL,2051],
[US-TN,6982]

$dataArray 的转储给了我

   Array
(
[0] => Array
    (
        [Provider State] => US-AL
        [Total Discharges] => 2051.00
    )

[1] => Array
    (
        [Provider State] => US-TN
        [Total Discharges] => 6982.00
    )

)

Answer 1

while ($row = mysqli_fetch_assoc($results)) {
    $dataArray[] = $row["Provider State"]. "," .$row["Total Discharges"];
}

这应该使您的数据成为一维数组。