php - 通过 PHP 在 phpMyAdmin 列中回显 json 数组

Question

你好，我有这样的 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"}]

如何回显 id answer type,
和 db Name: array Table Name: user_survey_start JSON row Name: survey_answers, 这是我的代码:

    <?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);
    ?> 

Answer 1

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