Google Api收集Php数组中的结果（）

I'm running this in the URL:

https://www.googleapis.com/shopping/search/v1/public/products?key=thekey&country=US&q=xbox+360&alt=json

This gives me output like:

{
 "kind": "shopping#products",
 "etag": "\"czKOfew9E3svi7vOBQ3vsAgGZzo/s56qwZYTznZuaaCXzw1weX_JANI\"",
 "id": "tag:google.com,2010:shopping/products",
 "selfLink": "https://www.googleapis.com/shopping/search/v1/public/products?country=US&q=xbox+360&alt=json&startIndex=1&maxResults=25",
 "nextLink": "https://www.googleapis.com/shopping/search/v1/public/products?country=US&q=xbox+360&alt=json&startIndex=26&maxResults=25",
 "totalItems": 203461,
 "startIndex": 1,
 "itemsPerPage": 25,
 "currentItemCount": 25,
 "items": [
  {
   "kind": "shopping#product",
   "id": "tag:google.com,2010:shopping/products/1113342/8881409096328278418",
   "selfLink": "https://www.googleapis.com/shopping/search/v1/public/products/1113342/gid/8881409096328278418?alt=json",
   "product": {
    "googleId": "8881409096328278418",
    "author": {
     "name": "Walmart",
     "accountId": "1113342"
    },
    "creationTime": "2011-11-13T21:18:07.000Z",
    "modificationTime": "2011-12-08T01:12:50.000Z",
    "country": "US",
    "language": "en",
    "title": "More Facts On Xbox 360 4gb Capabilities",
    "description": "Xbox 360 4GB ConsoleBuilt-in Wi-Fi: The new Microsoft Xbox 360 console is the only console with 802.11n Wi-Fi built-in for a faster and easier connection to Xbox LIVE. Stream HD movies and TV or download games from Xbox LIVE in 1080p and 5.1 surround sound from anywhere in the house. Compatible with b/g/n networks.Xbox LIVE: Xbox LIVE brings a world of entertainment to you. Instantly watch movies and TV streaming from Netflix. In crystal-clear HD, or download game add-ons like new levels, characters, maps and songs. Easily jump right into online multiplayer fun and play along with friends around the world. Plus, get your favorite music from Last.fm, connect with friends on Facebook and post Tweets on Twitter. Xbox LIVE is your connection to more games, entertainment and fun.Kinect-Ready: Featuring a dedicated, specialized port, this Microsoft Xbox 360 console is built to connect seamlessly with the Kinect Sensor. Kin",
    "link": "http://www.walmart.com/catalog/product.do?product_id=14917960&sourceid=1500000000000003142040&ci_src=14110944&ci_sku=14917960",
    "brand": "Microsoft",
    "condition": "new",
    "gtin": "00885370138405",
    "gtins": [
     "00885370138405"
    ],
    "inventories": [
     {
      "channel": "online",
      "availability": "inStock",
      "price": 199.0,
      "shipping": 7.97,
      "currency": "USD"
     }
    ],
    "images": [
     {
      "link": "http://i.walmartimages.com/i/p/00/88/53/70/13/0088537013840_500X500.jpg"
     }
    ]
   }
  },
  {
   "kind": "shopping#product",
   "id": "tag:google.com,2010:shopping/products/10046/10100715335711953213",
   "selfLink": "https://www.googleapis.com/shopping/search/v1/public/products/10046/gid/10100715335711953213?alt=json",
   "product": {
    "googleId": "10100715335711953213",
    "author": {
     "name": "Target",
     "accountId": "10046"
    },
    "creationTime": "2011-08-23T19:06:38.000Z",
    "modificationTime": "2011-12-09T22:37:12.000Z",
    "country": "US",
    "language": "en",
    "title": "Xbox 360 4gb Console",
    "description": "The new Xbox 360 4GB Console. Here today, ready for tomorrow with a brand new, leaner machine. Wi-Fi is built-in for easier connection to the world of entertainment on Xbox LIVE, where HD movies and TV stream in an instant. It s ready for the controller-free experiences of Kinect you don t just play the game, you are the game. Xbox 360 is more games, entertainment and fun. What s In The Box? Xbox 360 4GB S Console Xbox 360 Black Wireless Controller Xbox 360 Composite A/V cable (standard definition) One Month Xbox LIVE Gold Membership 1 year limited warranty on console",
    "link": "http://www.target.com/p/Xbox-360-4GB-Console/-/A-12885804?ref=tgt_adv_XSG10001&AFID=Froogle_df&LNM=%7C12885804&CPNG=video%20games&ci_src=14110944&ci_sku=12885804",
    "brand": "Microsoft",
    "condition": "new",
    "gtin": "00885370138405",
    "gtins": [
     "00885370138405"
    ],
    "inventories": [
     {
      "channel": "online",
      "availability": "inStock",
      "price": 199.99,
      "shipping": 12.85,
      "currency": "USD"
     }
    ],
    "images": [
     {
      "link": "http://img3.targetimg3.com/wcsstore/TargetSAS/img/p/12/88/12885804.jpg"
     }
    ]
   }
  },
  {
   "kind": "shopping#product",
   "id": "tag:google.com,2010:shopping/products/1161353/4408757490534070643",
   "selfLink": "https://www.googleapis.com/shopping/search/v1/public/products/1161353/gid/4408757490534070643?alt=json",
   "product": {
    "googleId": "4408757490534070643",
    "author": {
     "name": "Buy.com",
     "accountId": "1161353"
    },
    "creationTime": "2011-04-24T04:06:32.000Z",
    "modificationTime": "2011-12-09T06:24:51.000Z",
    "country": "US",
    "language": "en",
    "title": "Xbox 360 System (4GB)",
    "description": "Product Description The new Xbox 360. Here today, ready for tomorrow with a brand new, leaner machine in an all new black gloss finish. Wi-Fi is built-in for easier connection to the world of entertainment on Xbox LIVE, where HD movies and TV stream in an instant. Kinect Ready Featuring a dedicated, specialized port, the Xbox 360 4GB is built to connect seamlessly with the Kinect Sensor. Kinect brings games and entertainment to life in extraordinary new ways no controller required. Easy to use and instantly fun, Kinect gets everyone off the couch moving, laughing and cheering. See a ball? Kick it. Want to join a friend in the fun? Simply jump in. Even control an HD movie with a wave of your hand. Xbox LIVE Xbox LIVE brings a world of entertainment to you. Instantly watch movies and TV streaming from Netflix. In crystal-clear HD, or download game add-ons like new levels, characters, maps and songs. Easily jump right into online multiplayer fun and play along with friends around the world. Plus, get your favorite music from Last.fm and your Zune Pass, connect with friends on Facebook and post Tweets on Twitter. Xbox LIVE is your connection to more games, entertainment and fun. Looking for more than just a video game system? Just connect your Digital Camera, iPod, Zune, or other MP3 player via USB cable and immediately begin enjoying all your favorite Music and Movies on the TV that your Xbox 360 is hooked up to. It plays DVDs and CDs and you can even download the latest movies and TV shows via Xbox Live. It is a full Windows Media Extender and can connect with other PCs around the house to stream your favorite media. What Does Xbox Live Mean or Do? Join Xbox Live to have full access to the Marketplace where you can download full Games, Demos, Trailers, Movies and more. Voice, Text, and Video chat with friends and even play games together online (Note: multiplayer gaming requires Xbox Live Gold subscription). Xbox 360 Games To Watch Out For Gears of War 3 Call of Duty: Modern Warfare 3 Assassin's Creed: Revelations Tomb Raider Battlefield 3 Deus Ex: Human Revolution Child of Eden Xbox 360 Wireless Controller (black) This award-winning, high-performance wireless controller features a range of up to 30 feet and a battery life of up to 30 hours on two AA batteries. Built-in Wi-Fi The new Xbox 360 is the only console with 802.11n Wi-Fi built-in for a faster and easier connection to Xbox LIVE. Stream HD movies and TV or download games from Xbox LIVE in 1080p and 5.1 surround sound from anywhere in the house. Compatible with b/g/n networks.",
    "link": "http://clickfrom.buy.com/default.asp?adid=17379&sURL=http%3A%2F%2Fwww.buy.com%2Fprod%2Fxbox-360-system-4gb%2F216907636.html",
    "brand": "Microsoft",
    "condition": "new",
    "gtin": "00885370138405",
    "gtins": [
     "00885370138405"
    ],
    "inventories": [
     {
      "channel": "online",
      "availability": "inStock",
      "price": 199.99,
      "shipping": 0.0,
      "currency": "USD"
     }
    ],
    "images": [
     {
      "link": "http://ak.buy.com/PI/0/1000/216907636.jpg"
     }
    ]
   }
  },
  {
   "kind": "shopping#product",
   "id": "tag:google.com,2010:shopping/products/1113342/2934483943836745321",
   "selfLink": "https://www.googleapis.com/shopping/search/v1/public/products/1113342/gid/2934483943836745321?alt=json",
   "product": {
    "googleId": "2934483943836745321",
    "author": {
     "name": "Walmart",
     "accountId": "1113342"
    },
    "creationTime": "2011-03-25T21:44:47.000Z",
    "modificationTime": "2011-12-08T01:12:50.000Z",
    "country": "US",
    "language": "en",
    "title": "Xbox 360 250gb Console",
    "description": "The new Xbox 360 250GB console. It's here today and ready for tomorrow, with a brand-new, leaner machine in an all-new black gloss finish. Wi-Fi is built in for easier connection to the world of entertainment on Xbox LIVE, where HD movies and TV stream in an instant. It's ready for the controller-free experiences of Kinect you don't just play the game; you are the game. Kinect brings games and entertainment to life in extraordinary new ways no controller required. Easy to use and instantly f",
    "link": "http://www.walmart.com/catalog/product.do?product_id=14683340&sourceid=1500000000000003142040&ci_src=14110944&ci_sku=14683340",
    "brand": "Microsoft",
    "condition": "new",
    "gtin": "00885370127119",
    "gtins": [
     "00885370127119"
    ],
    "inventories": [
     {
      "channel": "online",
      "availability": "inStock",
      "price": 299.0,
      "shipping": 7.97,
      "currency": "USD"
     }
    ],
    "images": [
     {
      "link": "http://i.walmartimages.com/i/p/00/88/53/70/12/0088537012711_500X500.jpg"
     }
    ]
   }
  }

I want to get all the values from price and store them into an array in php? How do I run this query on somepage.php and output the json values into a php array within that page?

写回答
好问题 0 提建议
追加酬金
关注问题
分享
邀请回答
编辑收藏删除结题
收藏举报

1条回答默认最新

关注

码龄粉丝数原力等级 --

被采纳

被点赞

采纳率
dongtaijue1578 2011-12-10 17:34
关注
The solution to this problem, in steps:

Retrieve the remote source text

Decode the JSON string into an array

Iterate over the resulting array to retrieve your desired data.

There are multiple ways to retrieve remote files/text in php. The most prominent are ...

Using file_get_contents():

$txt = file_get_contents('http://www.example.com/'); echo $txt;

And PHP's curl functions:

$url = 'http://www.mysite.com'; $ch = curl_init($url); // Tell curl_exec to return the text instead of sending it to STDOUT curl_setopt($ch, CURLOPT_RETURNTRANSFER, TRUE); // Don't include return header in output curl_setopt($ch, CURLOPT_HEADER, 0); $txt = curl_exec($ch); curl_close($ch); echo $txt;

curl is generally a better option because you more control over the exact request parameters and more possibilities for error handling when things don't go as planned.

If the remote API page returns a JSON string, you turn it into an array using json_decode() and iterate the resulting array to pull out the values you want:

// retrieve the remote text using one of the above methods $txt = file_get_contents('http://www.example.com/'); // decode the json string into an array $arr = json_decode($txt); $price_arr = array(); foreach ($arr as $a) { // this is not the exact format of the data returned // from the API, just an example to demonstrate how you // would iterate over the decoded array $price_arr[] = $a['price']; }

You could also use PHP's array_map() function for more detailed parsing of the array that results from decoding the JSON string, though a simple foreach loop will suffice for most people.
本回答被题主选为最佳回答 , 对您是否有帮助呢?

解决无用
评论打赏
分享
举报

评论

按下Enter换行，Ctrl+Enter发表内容

报告相同问题？

关注问题

Google Api收集Php数组中的结果（） php
2011-12-10 17:16

回答 1 已采纳 The solution to this problem, in steps: Retrieve the remote source text Decode the JSON string i
从Google Elevation API获取PHP数组的值[重复] json php
2019-07-28 20:24

回答 1 已采纳 The string is in JSON format. You can use json_decode to convert it to a PHP array. $json_string
如何阅读谷歌驱动api提供的数组结果[复制] json php
2016-07-13 06:59

回答 1 已采纳 You are posted $result object seems to be a Google_Service_Drive_DriveFile Object which is belong
google-trends:谷歌趋势非官方 PHP API
2021-06-13 12:43

谷歌趋势非官方 PHP API 这个非官方 API 提供了一种简单的方法来查询谷歌趋势的某些数据。数据可以作为解码的 JSON、GoogleTrendsTerm 对象或格式化数组返回（仅适用于制作您自己的图表）。不支持 CSV 导出或 ...
如何将php数组传递给Google JavaScript Map API制作标签？ javascript php
2016-10-09 20:28

回答 2 已采纳 A couple of corrections: Meta tags are self-closing, so they don't need a </meta>. Refer t
在JSON字符串数组PHP中的引号之前删除转义字符 javascript json php
2018-06-11 17:30

回答 2 已采纳 Try: var allMarkers = ["{\"address_components\":[{\"long_name\":\"London\",\"short_name\":\
如何检索在PHP函数中创建的数组值？ php
2016-12-07 03:56

回答 2 已采纳 Simply you can try the below code... <?php function geocode($address){ $address = urlencod
google-apiclient:带有Cloud Platform和Laravel支持的Google API php客户端包装
2021-05-06 05:22

Google Api客户端包装带有Cloud Platform和Laravel支持的Google API php客户端包装要求PHP> = 7.2安装通过作曲家安装composer require pulkitjalan/google-apiclientLaravel要在laravel中使用，请将以下内容添加到...
访问JSON数组PHP中的值 json php
2013-06-20 01:17

回答 1 已采纳 The results are returned in an array. Get the first element and you're done. However you should ma
如何将PHP数组嵌入到谷歌图表脚本中？ mysql php
2013-05-13 12:48

回答 1 已采纳 To use a variable inside strings, it must be in double-quotes "$var" It can be " '$var' ", but no
根据Google API距离（usort）从数据库中排序数组 json php
2015-01-31 13:37

回答 1 已采纳 First of all let me just say that this code is a mess! Seeing the commented line where id is obtai
php在线翻译类(Google Translate API For PHP) v1.0.1.zip
2019-07-10 03:04

Google Translate API For PHP是一个基于Google Translate开发的翻译类，可以帮助PHP程序员实现多国文字的翻译。　本类使用到了Google的AJAX Translate API和Snoopy类，以模拟HTTP请求的方式实现数据的翻译。　...
从PHP创建JavaScript数组 - 方括号和花括号 javascript json php
2016-05-23 21:57

回答 2 已采纳 This should do the trick: $data = [['Series1', 'Series2', ['role'=>'annotation']], [0, 1], [2,
php调用rest api,在PHP中调用REST API
2021-04-10 11:12

evv安的博客您可以使用PHP的cURL Extension来访问任何REST API。但是，API文档(方法，参数等)必须由您的客户提供！例：// Method: POST, PUT, GET etc // Data: array("param" => "value") ==> index....
PHP在线翻译类(基于谷歌翻译API开发) 1.0.1.zip
2019-05-25 02:17

PHP在线翻译类(基于谷歌翻译API开发)是一个基于谷歌Translate开发的翻译类，可以帮助PHP程序员实现多国文字的翻译。 PHP在线翻译类使用到了谷歌的AJAX Translate API和Snoopy类，以模拟HTTP请求的方式实现数据的...
没有解决我的问题, 去提问

悬赏问题

¥15 fluent的在模拟压强时使用希望得到一些建议
¥15 STM32驱动继电器
¥15 Windows server update services
¥15 关于#c语言#的问题：我现在在做一个墨水屏设计，2.9英寸的小屏怎么换4.2英寸大屏
¥15 模糊pid与pid仿真结果几乎一样
¥15 java的GUI的运用
¥15 Web.config连不上数据库
¥15 我想付费需要AKM公司DSP开发资料及相关开发。
¥15 怎么配置广告联盟瀑布流
¥15 Rstudio 保存代码闪退

Google Api收集Php数组中的结果（）

1条回答 默认 最新

悬赏问题

1条回答默认最新