列出来自数组的信息(php) [英] Listing information from an Array (php)
问题描述
我已通过CURL连接到API,并且我得到了以下内容。
I have connected to an API via CURL and I get what is below returned to me.
我有点迷茫。但是我如何在PHP的帮助下提取并显示信息,使其看起来像这样:
I'm a bit lost. But how would I with the help of PHP extract and display information so it looks like:
2018-10-26-28.46 USD
2018-10-26 - 28.46 USD
2018-10-27-25.70 USD
2018-10-27 - 25.70 USD
2018-10-28-29.07 USD
2018-10-28 - 29.07 USD
非常感谢您的帮助! / Marcus
Thank you so much for help! /Marcus
{ options:{ ranking_metric: paid_impressions, time_interval: day, report_type: time, filters:{ pid: 2759}, data_source: detailed, format: json, end_date: 2018-10-28 23:59, columns :[ paid_impressions,收入], time_zone: UTC, start_date: 2018-10-26 00:00}, sql: \n SELECT\n ,\n FIRST(CONCAT('',STRING('')))AS _combined_val,\n SUM(if(media_tbl.mtid = 3,imps,0))作为pay_impressions,SUM(pub_rev)作为收入,\ \n SUM(已付费_展示)OVER(以_combined_val为单位的商品)rank_col,\n DENSE_RANK()OVER(以rank_col DESC为单位的商品)排名,\n STRFTIME_UTC_USEC(UTC_USEC_TO_DAY(时间戳+(7 * 1000 * 1000 * 60 * 60))) ,'%F%R')作为时间戳FROM FROMnnn(SELECT * from TABLE_DATE_RANGE(counts.hourly_custom_cust1_,DATE_ADD(TIMESTAMP('2018-10-26 00:00'),-(7) ,'HOUR'),DATE_ADD(TIMESTAMP('2018-10-28 23:59'),7,'HOUR')))作为tbl\n\n LEFT JOIN(选择sid作为_sid,pid FROM counts。 udm_synchronize_table_site_tbl)as site_tbl\n ON tbl.sid = site_tbl._sid \n\n左联接(从counts.udm_synchronize_table_media_tbl中选择_mid,adid,tid和mtid为mid)作为media_tbl\n tbl.mid = media_tbl._mid\n\n在1 = 1和site_tbl处。 pid IN(2759)AND时间戳> = DATE_ADD(TIMESTAMP('2018-10-26 00:00'),-(7),'HOUR')AND时间戳< = DATE_ADD(TIMESTAMP('2018-10-28 23:59'),-(7),'HOUR')\n GROUP BY时间戳,\n ORDER BY时间戳,rank,, api_url: http://udmserve.com/udm/radalytics_api。 cpx?action = report& api_key = xxxx& api_key = xxxx,时间:1540989662,行:[{ paid_impressions: 18136,时间戳: 2018-10-26 00:00, _combined_val:, ranking_col: 49046,收入: 28.461629999999985, rank: 1, f0 _:},{ paid_impressions: 14432, timestamp : 2018-10-27 00:00, _ combined_val:, ranking_col: 49046,收入: 25.707970000000017,排名: 1, f0_: },{ paid_impressions: 16478, timestamp: 2018-10-28 00:00, _ combined_val:, ranking_col: 49046, revenue: 29.07676000000002, rank: 1, f0 _:}]}
您需要 json_decode()
卷曲响应并应用 foreach()
获得理想的结果
You need to json_decode()
curl response and apply foreach()
to get desired result
$array = json_decode($curl_response,true);
foreach($array['rows'] as $arr){
echo explode(' ',$arr['timestamp'])[0].'-'.number_format((float)$arr['revenue'], 2, '.', '').' USD'.PHP_EOL;
}
这篇关于列出来自数组的信息(php)的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!