如何在codeigniter中从数据库中提取JSON数组

Question

我将没有任何键值的 json 数组插入数据库现在我想将 json 数组提取为单个值

像这样存储的数据库表

我想这样显示

13

53

76

3

71

17

9

我试过这样

 <?php

     $members_id=$this->db->get_where('ag_matched_members', array('staff_id' =>$msgdata->staff_id))->row()->members_id;

                      $members_ids = json_decode($members_id, true);

                   ?>

                      <li>

                        <a href="#">

                          <i class="fa fa-envelope text-aqua"></i> <?php echo $members_ids[0];  ?>

                        </a>

                      </li>

Answer 1

使用此代码：<?php&nbsp; &nbsp; $res = $this->db->query("SELECT members_id FROM `ag_matched_members` WHERE staff_id =&nbsp; ? " , $msgdata->staff_id )->result_array();&nbsp; &nbsp; $members_ids = explode(',', json_decode($res[0]['members_id'])[0]);&nbsp; &nbsp; foreach($members_ids as $id){&nbsp; &nbsp; &nbsp; &nbsp; echo('<li><a href="#"><i class="fa fa-envelope text-aqua"></i> '.$id.'</a></li>');&nbsp; &nbsp; }?>