Hi,
I want to display the questions and options in Json which is from database. I want output like this,
[
{
"survey_question_id": 1,
"survey_question_text": "How long does it take to get a new print supplier approved and set up to work with your company?",
"survey_question_option_order": 1,
"survey_question_type": "radio",
"survey_question_comment_req": true,
"survey_question_active": true,
"survey_question_option_active": true ,
“options”:[
{
"survey_question_option_value": "There is no formal supplier approval process.",
"survey_question_option_text": "There is no formal supplier approval process."
},
{
"survey_question_option_value": "There is no formal supplier approval process.",
"survey_question_option_text": "There is no formal supplier approval process."
},
{
"survey_question_option_value": "There is no formal supplier approval process.",
"survey_question_option_text": "There is no formal supplier approval process."
}
]
But when i tried i got like this output,
[
{
"survey_question_id": 1,
"survey_question_text": "How long does it take to get a new print supplier approved and set up to work with your company?",
"survey_question_option_value": "There is no formal supplier approval process.",
"survey_question_option_text": "There is no formal supplier approval process.",
"survey_question_option_order": 1,
"survey_question_type": "radio",
"survey_question_comment_req": true,
"survey_question_active": true,
"survey_question_option_active": true
},
{
"survey_question_id": 1,
"survey_question_text": "How long does it take to get a new print supplier approved and set up to work with your company?",
"survey_question_option_value": "We do have an approval process, but the approval happens right away",
"survey_question_option_text": "We do have an approval process, but the approval happens right away",
"survey_question_option_order": 2,
"survey_question_type": "radio",
"survey_question_comment_req": true,
"survey_question_active": true,
"survey_question_option_active": true
},
{
"survey_question_id": 1,
"survey_question_text": "How long does it take to get a new print supplier approved and set up to work with your company?",
"survey_question_option_value": "A few days",
"survey_question_option_text": "A few days",
"survey_question_option_order": 3,
"survey_question_type": "radio",
"survey_question_comment_req": true,
"survey_question_active": true,
"survey_question_option_active": true
},
{
"survey_question_id": 1,
"survey_question_text": "How long does it take to get a new print supplier approved and set up to work with your company?",
"survey_question_option_value": "A few weeks",
"survey_question_option_text": "A few weeks",
"survey_question_option_order": 4,
"survey_question_type": "radio",
"survey_question_comment_req": true,
"survey_question_active": true,
"survey_question_option_active": true
},
{
"survey_question_id": 1,
"survey_question_text": "How long does it take to get a new print supplier approved and set up to work with your company?",
"survey_question_option_value": "A month or more",
"survey_question_option_text": "A month or more",
"survey_question_option_order": 5,
"survey_question_type": "radio",
"survey_question_comment_req": true,
"survey_question_active": true,
"survey_question_option_active": true
},
I am new for JSON. Anybody can help me?
What I have tried:
I am new for json and i changed in coding and script. But it is not working. Anybody can help? Please help me.