php - 通过phpMyAdmin列中的echo json数组通过PHP

您好，我有这样的JSON行：

//THis is one of My Rows
     [{"id":"26","answer":[{"option":"3","text":"HIGH"}],"type":"a"},
        {"id":"30","answer":[{"option":"3","text":"LOW"}],"type":"b"},
        {"id":"31","answer":[{"option":"3","text":"LOW"}],"type":"c"},
        {"id":"32","answer":[{"option":"3","text":"HIGH"}],"type":"d"},
        {"id":"33","answer":[{"option":"3","text":"HIGH"}],"type":"e"},
        {"id":"34","answer":[{"option":"3","text":"HIGH"}],"type":"f"},
        {"id":"40","answer":["Number 3"],"type":"g"}]

我怎样才能回音，
这是我的代码：

    <?php
    $con=mysqli_connect("localhost","root","","array");
    // Check connection
    if (mysqli_connect_errno())
      {
      echo "Failed to connect to MySQL: " . mysqli_connect_error();
      }

  //  $sql="SELECT  survey_answers->"$.id" AS `twitter` FROM user_survey_start";
    $sql="SELECT  survey_answers FROM user_survey_start";


    if ($result=mysqli_query($con,$sql))
      {
      // Fetch one and one row
      while ($row=mysqli_fetch_row($result))
        {
        printf ("%s \n",$row[0]);
        }
      // Free result set
      mysqli_free_result($result);
    }

    mysqli_close($con);
    ?>

最佳答案

可以使用json_decode（）函数将json转换为php array（）。之后，您可以根据需要迭代所有数据。