Converting nested array in JSON format with php shows numeric index and not array name

Question

I'm trying to convert a multidimensional php array into JSON format. The problem is that JSON add the "numeric key" of each value of the array.

For constructing the JSON, first I make a query, and then, for append another array which have the business hours of each place, I do another query for each result.

This is the JSON that I get:

{
"sucursales": [
    {
        "sucursal": {
            "id_sucursal": "104",
            "id_user": "2",
            "nombre_sucursal": "wena ql 2",
            "region": "0",
            "0": {
                "dia": "1",
                "hora_inicio": "600",
                "hora_fin": "600"
            },
            "1": {
                "dia": "2",
                "hora_inicio": "600",
                "hora_fin": "600"
            },
            "2": {
                "dia": "3",
                "hora_inicio": "600",
                "hora_fin": "600"
            },
            "3": {
                "dia": "4",
                "hora_inicio": "600",
                "hora_fin": "600"
            }
        }
    }
    .....
]
}

This is the JSON that I want:

{
"sucursales": [
    {
        "sucursal": {
            "id_sucursal": "104",
            "id_user": "2",
            "nombre_sucursal": "wena ql 2",
            "region": "0",
            "horario": {
                "dia": "1",
                "hora_inicio": "600",
                "hora_fin": "600"
            },
            "horario": {
                "dia": "2",
                "hora_inicio": "600",
                "hora_fin": "600"
            },
            "horario": {
                "dia": "3",
                "hora_inicio": "600",
                "hora_fin": "600"
            },
            "horario": {
                "dia": "4",
                "hora_inicio": "600",
                "hora_fin": "600"
            }
        }
    }
    .....
]
}

This is the Code that I use for appending one array to another one. Note that $result is the result of a mysql query.

/* create one master array of the records */
$sucursales = array();
if(mysql_num_rows($result)) {
    while($sucursal = mysql_fetch_assoc($result)) {

        $query_horarios = "SELECT dia,hora_inicio,hora_fin FROM horario_funcionamiento WHERE id_sucursal=".$sucursal['id_sucursal'].";";
        $resultado_horarios = mysql_query($query_horarios,$link) or die('Error en la consulta SQL'); //.$query);

        while($horario = mysql_fetch_assoc($resultado_horarios)){
            $sucursal[]= $horario;
        }
        $sucursales[] = array('sucursal'=>$sucursal);
    }
}

And the code that I use for converting the array to JSON format:

header('Content-type: application/json');
echo json_encode(array('sucursales'=>$sucursales));

you are trying to use same key for multiple objects..?

Sudhir Bastakoti
– Sudhir Bastakoti

2013-12-16 04:55:28 +00:00
Commented Dec 16, 2013 at 4:55 — Sudhir Bastakoti
– Sudhir Bastakoti, Commented Dec 16, 2013 at 4:55

Sudhir Bastakoti · Accepted Answer · 2013-12-16 04:57:47Z

1

i dont think thats possible, instead you could do:

....
while($horario = mysql_fetch_assoc($resultado_horarios)){
    $sucursal['horario'][] = $horario;
}
...

answered Dec 16, 2013 at 4:57

Sudhir Bastakoti

100k15 gold badges163 silver badges169 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Sudhir Bastakoti Over a year ago

@user2644614 you're welcome.. :) Btw, you could mark the answer as accepted if it solved your problem.. :)

Collectives™ on Stack Overflow

Converting nested array in JSON format with php shows numeric index and not array name

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related