How to get JSON data in this format using Laravel?

Question

I tried to save data to the MySQL database and successfully saved data. I want to get JSON data in this formate

{
   "response_code":0,
   "results":[
      {
         "question":"Here is my question?",
         "correct_answer":"Correct Answer",
         "incorrect_answers":[
            "wrong_1",
            "wrong_2",
            "wrong_3"
         ]
      }
   ]
}

But I am getting my JSON data in this format

{
   "response_code":0,
   "results":[
      {
         "question":"Here is my question?",
         "correct_answer":"right_ans",
         "incorrect_answers_1":"wrong_1",
         "incorrect_answers_2":"wrong_2",
         "incorrect_answers_3":"wrong_3",
      }
   ]
}

Here is my MySql database

Please suggest to me how can I get my JSON Data in my desired format? If you want more files or information then I will edit my questions.

 public function toArray($request)
    {
        return [
            "id"=>$this->id,
            "right_ans" =>$this->right_ans,
            "incorrect_answers_1" =>$this->wrong_1,
            "incorrect_answers_1" =>$this->wrong_2,
            "incorrect_answers_1" =>$this->wrong_3,
            "created"=>$this->created_at,
        ];
    }

Please provide the code on how you generate the current format. — jrcamatog
– jrcamatog, Commented Apr 5, 2021 at 15:38
This is achievable but the DB design is incorrect. There should be a one to many relationship between questions and a new options table. This design would have made it so much simpler for your use case and also provides flexibility to increase number of options and also number of correct answers for a question. — mighty_dev
– mighty_dev, Commented Apr 5, 2021 at 15:43
@nice_dev can you please suggest to me any tutorials that how can I achieve this. — Pramod Yadav
– Pramod Yadav, Commented Apr 5, 2021 at 16:46

Hassan Malik · Accepted Answer · 2021-04-05 16:58:54Z

2

Try creating array like this. It will return json as expected.

public function toArray($request)
{
   return [
      "id"=>$this->id,
      "right_ans" =>$this->right_ans,
      "incorrect_answers" => array (
             $this->wrong_1,
             $this->wrong_2,
             $this->wrong_3),
      "created"=>$this->created_at,
    ];
}

answered Apr 5, 2021 at 16:58

Hassan Malik

13011 bronze badges

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

Collectives™ on Stack Overflow

How to get JSON data in this format using Laravel?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related