doujiling4377 2016-12-29 06:49
浏览 19

分解数组并输出到表?

I run a gaming server and it keeps some information in a database. I run a MySQL query that pulls information like cargo_items (below). How can I format this data properly in PHP? I'd like for it to be in a table. Is that possible? My knowledge of handing arrays like this is limited do to the complex nature. This is how the data is returned from the database.

 Array
 (
   [0] => Array
   (
     [0] => Array
     (
       [id] => 2237
       [cargo_weapons] =>      
       [
         ["MMG_02_black_F","","","",[],""],
         ["arifle_SDAR_F","","","",[],""],
         ["arifle_SDAR_F","","","",[],""],        
         ["arifle_SPAR_03_khk_F","","","",[],""],
         ["LMG_Zafir _F","","","",[],""],
         ["MMG_02_black_F","","","",[],""],
         ["MMG_02_black_F","","","",[],""]
       ]
     )
   )
 )

The output should be a table:

 Weapons
 -------
 MMG_02_black_F
 arifle_SDAR_F
 arifle_SDAR_F
 arifle_SPAR_03_khk_F
 LMG_Zafir_F
 MMG_02_black_F
 MMG_02_black_F
  • 写回答

1条回答 默认 最新

  • douyunhuan9886 2016-12-29 08:43
    关注

    Since you have multidimensional array, you need custom recursion function, or, in your specific case, you could use something like this:

    function get_items($item, $key)
    {
        if(!empty($item) && $key=='cargo_weapons')
        //your html table cells
        echo "$item<br>";
    }
    
    array_walk_recursive($array, 'get_items');
    

    array_walk_recursive

    will do the job (this function returns true or false), but you can (ab)use it to display desired HTML too.

    评论

报告相同问题?

悬赏问题

  • ¥15 mmocr的训练错误,结果全为0
  • ¥15 python的qt5界面
  • ¥15 无线电能传输系统MATLAB仿真问题
  • ¥50 如何用脚本实现输入法的热键设置
  • ¥20 我想使用一些网络协议或者部分协议也行,主要想实现类似于traceroute的一定步长内的路由拓扑功能
  • ¥30 深度学习,前后端连接
  • ¥15 孟德尔随机化结果不一致
  • ¥15 apm2.8飞控罗盘bad health,加速度计校准失败
  • ¥15 求解O-S方程的特征值问题给出边界层布拉休斯平行流的中性曲线
  • ¥15 谁有desed数据集呀