dongwei5740 2019-08-20 04:20
浏览 64
已采纳

使用PHP从Google表格JSON数据中回显特定值

I'm trying to figure out "how-to" echo out the "tbenrud@gushd.net" (red arrow pointing to it) value from this JSON file. I can echo $data[feed][entry][1][id], but I run into trouble when I get to gsx$emailaddress. I assume it is because of the $ in the label. I do not have control over the label name (created by Google Sheets).

Any help is greatly appreciated.

enter image description here

My Code

$urlSheet = 'https://spreadsheets.google.com/feeds/list/1s7UCtbRY2dU3YdDu_kjnr-_y5Lh49yMHQRzgiDt8D4c/2/public/values?alt=json';
$jsonSheet = file_get_contents($urlSheet);
$data = json_decode($jsonSheet, true);

Thank you!

Todd

  • 写回答

2条回答 默认 最新

  • doukuo9116 2019-08-20 04:27
    关注

    If you use single quotes, the $ won't trigger PHP variable interpolation.

    echo $data['feed']['entry'][1]['gsx$emailaddress']['$t'];
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥20 C,有个译码器,换了信道就跑不出原来数据
  • ¥15 MIMIC数据库安装问题
  • ¥60 基于JTag协议开发Fpga下载器上位机,哪位大🐂有偿指导?
  • ¥20 全书网Java爬取数据
  • ¥15 怎么获取红包封面的原始链接,并且获取红包封面序列号
  • ¥100 微信小程序跑脚本授权的问题
  • ¥100 房产抖音小程序苹果搜不到安卓可以付费悬赏
  • ¥15 STM32串口接收问题
  • ¥15 腾讯IOA系统怎么在文件夹里修改办公网络的连接
  • ¥15 安卓qpython向ksweb服务器post文件失败