Remove key value from array in php

Question

This is my db result,

Array ([0] => Array ( [shopname] => Shop name [fueltype] => Pertol [amount] => 1000 ) 
       [1] => Array ( [shopname] => dfsdfsd [fueltype] => Pertol [amount] => 54456 )
       [2] => Array ( [shopname] => dfsdfsd [fueltype] => Disel [amount] => 54456 )
)

I need result like

[["Shop name", "Pertol", 1000],["dfsdfsd", "Pertol", 54456],["Shop name", "Disel", 54456]]

How to get like this, I have no idea?

question from:https://stackoverflow.com/questions/65516933/php-mysql-query-result-format-change

Answer 1

array_map() along with array_values() will work for you:-

<?php
$array = Array ( '0' => Array ( 'shopname' => 'Shop name','fueltype' => 'Pertol','amount' => 1000 ), 
        '1' => Array ( 'shopname' => 'dfsdfsd' ,'fueltype' => 'Pertol','amount' => 54456 ),
        '2' => Array ( 'shopname' => 'dfsdfsd','fueltype' => 'Disel','amount' => 54456 )
);


$values_data_only = array_map('array_values', $array);
$desire_result = json_encode($values_data_only);
echo $desire_result;

?>

Output:- https://eval.in/395344

Also via simple foreach() it is possible:-

<?php
$array = Array ( '0' => Array ( 'shopname' => 'Shop name','fueltype' => 'Pertol','amount' => 1000 ), 
        '1' => Array ( 'shopname' => 'dfsdfsd' ,'fueltype' => 'Pertol','amount' => 54456 ),
        '2' => Array ( 'shopname' => 'dfsdfsd','fueltype' => 'Disel','amount' => 54456 )
);

$new_array = array();

foreach ($array as $k=> $arr){
    $new_array[$k][] = $arr['shopname'];
    $new_array[$k][] = $arr['fueltype'];
    $new_array[$k][] = $arr['amount'];
}
echo "<pre/>";print_r($new_array);
$desired_result_2 = json_encode($new_array);
echo $desired_result_2;
?>

Output:-https://eval.in/395354