echo json array VIA PHP

Question

Hellow, I have a name Column and This is My json:

[{"id":"26","answer":[{"option":"3","text":"HIGH"}],"type":"3"},
{"id":"30","answer":[{"option":"3","text":"LOW"}],"type":"3"},
{"id":"31","answer":[{"option":"3","text":"LOW"}],"type":"3"},
{"id":"32","answer":[{"option":"3","text":"HIGH"}],"type":"3"},
{"id":"33","answer":[{"option":"3","text":"HIGH"}],"type":"3"},
{"id":"34","answer":[{"option":"3","text":"HIGH"}],"type":"3"},
{"id":"40","answer":["Number 3"],"type":"2"}]

Why I Can't echo answer With This Code:

<?php 
  $jsonurl='C:\wamp64\www\library\json.json'; 
  $json = file_get_contents($jsonurl,0,null,null);  
  $json_output = json_decode($json, true);        
  foreach ($json_output as $trend){         
   echo $trend['id']."\n";       //   OK
   //echo $trend['answer']."\n";   //  Error 
   echo $trend['type']."<br />";  //  OK
  }  
?>

start by looking into json_decode() to make this an php array and then work you way into sql. From there you have too many option to be able to answer your question specificly. — Louis Loudog Trottier
– Louis Loudog Trottier, Commented Feb 5, 2017 at 8:20
I Read $json = '{"foo-bar": 12345}'; , But my Exaple is Defference, And I want to Select That json Column Automaticaly and I Have Radio Buttons too. — Saeed Heidarizarei
– Saeed Heidarizarei, Commented Feb 5, 2017 at 8:45

gaurav · Accepted Answer · 2017-02-05 10:53:27Z

1

First there is error in your json.json file in last line which is
{"id":"40","answer":["Number":"3"],"type":"2"}]

Second $trend['answer'] is array you can not echo so you have to use foreach loop again like this

foreach($trend['answer'] as $ans){
      if(array_key_exists("Number",$ans)){  /* this is for last line */
        echo $ans['Number']."\n" ;
       } else {
        echo $ans['option']."\n";
        echo $ans['text']."\n" ;
      }
    }

answered Feb 5, 2017 at 10:53

gaurav

1,3371 gold badge14 silver badges25 bronze badges

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

7 Comments

Saeed Heidarizarei Over a year ago

Thank you Dear Friend, Then you mean i can't print answer":["Number":"3"] ? because this is descriptive Awnser, I mean, I have 2 Model Awnser Radio Button and descriptive Awnser

gaurav Over a year ago

because answer is array so you have to use as array

gaurav Over a year ago

if it's solve your answer than choose as correct answer , it will help me .

Saeed Heidarizarei Over a year ago

1 More question, How Can I Read My jsons From a MySQL Column, Not a json File.

gaurav Over a year ago

MySQL is relation database so one column for one value but you still want to use than use MySQL 5.7 for storing in json than use query according to it. read link where you can see how query return output like object, array etc & use in it php

|

Collectives™ on Stack Overflow

echo json array VIA PHP

1 Answer 1

7 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Linked

Related