时间戳

首页 > 解决方案 > 从 MySQL 缓存文件中导出列值

php - 从 MySQL 缓存文件中导出列值

问题描述

我这里有一个问题。我使用文件作为缓存来存储 MySQL 结果。以下是缓存文件中的结果：

[
   {
      "Name":"Bell",
      "Class":"BWB0",
      "Lv":31,
      "Kill":0,
      "Serial":3,
      "PvpPoint":0,
      "Death":0
   },
   {
      "Name":"Perkss",
      "Class":"AWB0",
      "Lv":17,
      "Kill":0,
      "Serial":6,
      "PvpPoint":2400,
      "Death":0
   },
   {
      "Name":"1233",
      "Class":"BWB0",
      "Lv":3,
      "Kill":0,
      "Serial":1,
      "PvpPoint":0,
      "Death":0
   },
   {
      "Name":"Cora",
      "Class":"CWB0",
      "Lv":1,
      "Kill":0,
      "Serial":4,
      "PvpPoint":0,
      "Death":0
   }
]

任何想法将结果缓存文件转换为通常的输出？比如“echo $row['Name']”。

谢谢，我只是一个想学习PHP的新手:)

标签： php

解决方案

$json_string = '[{"Name":"Bell","Class":"BWB0","Lv":31,"Kill":0,"Serial":3,"PvpPoint":0,"Death":0},{"Name":"Perkss","Class":"AWB0","Lv":17,"Kill":0,"Serial":6,"PvpPoint":2400,"Death":0},{"Name":"1233","Class":"BWB0","Lv":3,"Kill":0,"Serial":1,"PvpPoint":0,"Death":0},{"Name":"Cora","Class":"CWB0","Lv":1,"Kill":0,"Serial":4,"PvpPoint":0,"Death":0}]';
$a = json_decode($json_string, true);

foreach($a as $row)
    {
    echo $row['Name'];
    }

推荐阅读