从php准备的语句重新格式化数组结果


Reformat array result from php prepared statement

我试图以特定格式将数据输出到数组中,但我被stmt->fetch部分卡住了,无法让它以我需要的格式输出数组。

我迄今为止的代码(从各种在线来源拼凑在一起)

    private function get_results()  
{  
    $parameters = array();
    $results = array();
    $mysqli = new mysqli('localhost', $this->user, $this->pass, $this->db) 
    or die('Problem connecting to the database');
    $stmt = $mysqli->prepare($this->sql) or die('Problem preparing query, check SQL');  
    $stmt->execute();  
    $meta = $stmt->result_metadata();  
    while ( $field = $meta->fetch_field() ) {  
        $parameters[] = &$row[$field->name];
    }  
    call_user_func_array(array($stmt, 'bind_result'), $parameters);  
    while ( $stmt->fetch() ) {  
        $x = array();  
        foreach( $row as $key => $val ) {  
            $x[$key] = $val;  
        }  
        $results[] = $x;  
    }
    $mysqli->close();
    return $results;  
}

输出以下内容:

大堆([0]=>数组(蘑菇[切片]=>3)[1] =>阵列([Topping]=>橄榄[切片]=>1)[2] =>阵列(洋葱[切片]=>1)[3] =>阵列([Topping]=>意大利辣香肠[切片]=>1)[4] =>阵列([Topping]=>祖基尼[切片]=>2))

但我想要以下格式:

大堆([Topping]=>阵列([0]=>蘑菇[1] =>橄榄[2] =>洋葱[3] =>意大利辣香肠[4] =>祖奇尼)[切片]=>数组([0]=>3[1] =>1[2] =>1[3] =>1[4] =>2))

我已经试着实现这一点有一段时间了,但我似乎无法理解。任何帮助都将不胜感激!谢谢

像这个一样使用array_marge_recurive()

$ar1=array(array('topping'=>"Mushrooms",'slices'=>"3"),array('topping'=>"Olives",'slices'=>"4"));
$res=array();
foreach($ar1 as $temp)
{
  $res=array_merge_recursive($res, $temp);
}
echo '<pre>';
print_r($res);
$keys = array_keys($arr[0]);
array_unshift($arr, NULL);
$arr = call_user_func_array('array_map', $arr);
$arr = array_combine($keys, $arr);