How to make json_encode always return as JSON Array?

Question

this is my code:

  $db = connect_mysqli();

  $response = array();

  $sql = "SELECT * FROM questions ORDER BY RAND ()";
  $result = $db->query($sql);

  while($row = $result->fetch_array(MYSQL_ASSOC))
  {
    $response['answers'][$row['id']] = array('question_id'=>$row['id'], 'option_id'=>null);
  }

  echo json_encode($response);

And this is the response:

{
  answers: {
    1: {
      question_id: "1",
      option_id: null
    },
    2: {
      question_id: "2",
      option_id: null
    },
    3: {
      question_id: "3",
      option_id: null
    },
    4: {
      question_id: "4",
      option_id: null
    }
  }
}

How to make the response always return JSON Array? not JSON Object like that. Sometimes the response is return JSON Array and in some part, return JSON Object. I want all response tobe JSON Array.

So, it should be like this:

{
  answers: [
    1: {
      question_id: "1",
      option_id: null
    },
    2: {
      question_id: "2",
      option_id: null
    },
    3: {
      question_id: "3",
      option_id: null
    },
    4: {
      question_id: "4",
      option_id: null
    }
  ]
}

Try change $response['answers'][$row['id']] to $response['answers'][] — Mr Hery
– Mr Hery, Commented Dec 30, 2017 at 4:33
i need this as a key $response['answers'][$row['id']] @MrHery — Dimas Adi Andrea
– Dimas Adi Andrea, Commented Dec 30, 2017 at 4:34
If you need the key to be $row['id'], then the json output you got is correct. You cannot have an array that has keys as values in json. If you want to have it return an array then embed the id into the object instead. — Andrew Smith
– Andrew Smith, Commented Dec 30, 2017 at 10:03

Loïc Bellemare-Alford · Accepted Answer · 2017-12-30 04:38:30Z

1

$response['answers'][$row['id']] = array('question_id'=>$row['id'], 'option_id'=>null);

This previous line should be changed to:

$response['answers'][] = array('question_id'=>$row['id'], 'option_id'=>null);

The problem comes from the fact that you do not start the array at an index of 0.

answered Dec 30, 2017 at 4:38

Loïc Bellemare-Alford

5485 silver badges12 bronze badges

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

5 Comments

Dimas Adi Andrea Over a year ago

I need this $response['answers'][$row['id']] as a key

Loïc Bellemare-Alford Over a year ago

If you need a key, it's an object, not a array, you need. Arrays always start from a zero index and go up from there.

Dimas Adi Andrea Over a year ago

Hmm, then how i can show it? if is an JSON Array answers[1].option_id, how for an JSON Object?

Loïc Bellemare-Alford Over a year ago

This is how would access it an object instead of an array: $answers[1]->option_id

Loïc Bellemare-Alford Over a year ago

In JavaScript accessing an array or an object is the same notation: answers[1].option_id should work. See this: jsfiddle.net/loic294/u2shu0Ls

Akbar Soft · Accepted Answer · 2017-12-30 04:35:56Z

0

does it help you

   $response = json_encode($response);

answered Dec 30, 2017 at 4:35

Akbar Soft

1,06610 silver badges19 bronze badges

Comments

Rajeev Ranjan · Accepted Answer · 2017-12-30 04:46:05Z

0

cast the $row['id'] as string to get desired result.

$db = connect_mysqli();

$response = array();

$sql = "SELECT * FROM questions ORDER BY RAND ()";
$result = $db->query($sql);

while($row = $result->fetch_array(MYSQL_ASSOC))
 {
   $response['answers'][(string)$row['id']] = array('question_id'=>$row['id'], 'option_id'=>null);
 }

echo json_encode($response);

answered Dec 30, 2017 at 4:46

Rajeev Ranjan

4,1523 gold badges30 silver badges42 bronze badges

2 Comments

Dimas Adi Andrea Over a year ago

No, it's still same like before :(

Rajeev Ranjan Over a year ago

@DimasAdiAndrea please validate the json you are expecting.

Collectives™ on Stack Overflow

How to make json_encode always return as JSON Array?

3 Answers 3

5 Comments

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

5 Comments

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related