json encode returning only partial data

Question

Here is what I have:

public function get_model_by_make($make = null){
    $model_data = $this->vehicle_model->get_model($make);
    echo json_encode($model_data);
}   

public function get_model($make){

    $this->db->select('models_id, models_name');    
    $this->db->where('makes_id', $make);
    $models_data = $this->db->get('Models');

    $rows = array();
    $rows[0] = '-Select-';
    foreach($models_data->result() as $value){
        $rows[$value->models_id] = $value->models_name;
    }
    return $rows;
}

The problem I'm having is if I pass a 0 or 1 to the get_model_by_make() function the json data that is returned without the array key.

Example:

$data = get_model_by_make(1)
echo $data;

Result:

["-Select-","CL","CSX","EL","Integra","Legend","MDX","NSX","RDX","RL","RSX",
"SLX","TL","TSX","Vigor"]

If the number passed is greater than 1 then its returned like this:

$data = get_model_by_make(2)
echo $data;

Result:

{"0":"-Select-","35":"Alliance","36":"Ambassador","37":"AMX","38":"Classic"}

Why is json_encode not returning the key/value pair for 0 or 1? If I var_dump the data the key/value is there.

George Brighton · Accepted Answer · 2013-09-11 16:43:14Z

6

You're looking at two different JSON data structures. One is an array, the other an object. Essentially, json_encode() will use the former where possible, and switch to objects if the data can't be represented by an array.

Change json_encode($model_data); to json_encode($model_data, JSON_FORCE_OBJECT); to make json_encode() always return an object, which will have the keys you want.

Further example:

$data = array(34,26,25,23,6);

echo json_encode($data); // [34,26,25,23,6]

echo json_encode($data, JSON_FORCE_OBJECT); // {"0":34,"1":26,"2":25,"3":23,"4":6}

answered Sep 11, 2013 at 16:43

George Brighton

5,1719 gold badges30 silver badges36 bronze badges

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

Comments

webduvet · Accepted Answer · 2013-09-11 16:45:46Z

0

Have you tried using strings not integers? like

$rows['0'] = '-Select-';

and so on.

answered Sep 11, 2013 at 16:45

webduvet

4,2922 gold badges30 silver badges39 bronze badges

Collectives™ on Stack Overflow

json encode returning only partial data

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related