Doubt JSON PHP

Question

I’m trying to display on the screen a structure JSON which will be built by Mysql, but I would like to separate the results into groups according to the name of the fields I set in select and would like something like:

minha_array
    carro
        carro 1
        carro 2
        carro 3
        carro 4
    imagem
        imagem 1
        imagem 2
        imagem 3
        imagem 4

My code:

<?php

//open connection to mysql db
$connection = mysqli_connect("localhost","root","","mybd") or die("Error " . mysqli_error($connection));

//fetch table rows from mysql db
$sql = "select carro, imagem from carros";
$result = mysqli_query($connection, $sql) or die("Error in Selecting " . mysqli_error($connection));

//create an array
$emparray = array();
while($row =mysqli_fetch_assoc($result))
{
    $emparray[] = $row;
}
echo json_encode($emparray);

//close the db connection
mysqli_close($connection);
?>

Answer 1

You can do it like this:

while($row = mysqli_fetch_assoc($result)) {
    $emparray['minha_array']['carro'][] = $row['carro'];
    $emparray['minha_array']['imagem'][] = $row['imagem'];
}

echo json_encode($emparray, JSON_PRETTY_PRINT);