StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POGet value in mutli array
primarykey
Id
11585202
data
AcceptedAnswerId
0
AnswerCount
4
ClosedDate
CommentCount
1
CommunityOwnedDate
CreationDate
2012-07-20T18:43:58.167
FavoriteCount
0
LastActivityDate
2012-07-20T20:25:55.613
LastEditDate
2012-07-20T19:49:42.077
LastEditorUserId
1415682
OwnerUserId
1415682
ParentId
0
PostTypeId
1
Score
0
ViewCount
149
LastEditorDisplayName
text
Body
<p>How would i get the value of a key in an array?</p> <p>The array is done by google shopping api which is:</p> <pre><code>// Valid source values are "public", "cx:cse", and "gan:pid" // See http://code.google.com/apis/shopping/search/v1/getting_started.html#products-feed $source = "public"; // For more information about full text search with the shopping API, please // see http://code.google.com/apis/shopping/search/v1/getting_started.html#text-search $query = "\"mp3 player\" | ipod"; //The order in which the API returns products is defined by a ranking criterion. // See http://code.google.com/apis/shopping/search/v1/getting_started.html#ranking $ranking = "relevancy"; $results = $service->products->listProducts($source, array( "country" => "UK", "q" => $query, "rankBy" => $ranking, )); print "<h1>Shopping Results</h1><pre>" . print_r($results, true) . "</pre>"; </code></pre> <p>I have the following array which outputs: Shopping Results</p> <pre><code>Array ( [kind] => shopping#products [etag] => "*********" [id] => tag:google.com,2010:shopping/products [selfLink] => https://www.googleapis.com/shopping/search/v1/public/products?country=UK&q=iphone&rankBy=relevancy [nextLink] => https://www.googleapis.com/shopping/search/v1/public/products?country=UK&q=iphone&rankBy=relevancy&startIndex=26 [totalItems] => 771622 [startIndex] => 1 [itemsPerPage] => 25 [currentItemCount] => 25 [requestId] => 0CMjH976CqbECFYNWtAodLRwAAA [items] => Array ( [0] => Array ( [kind] => shopping#product [id] => tag:google.com,2010:shopping/products/5735617/11254757413841304510 [selfLink] => https://www.googleapis.com/shopping/search/v1/public/products/5735617/gid/11254757413841304510 [product] => Array ( [googleId] => 11254757413841304510 [author] => Array ( [name] => Amazon.co.uk [accountId] => 5735617 ) [creationTime] => 2012-05-04T05:03:50.000Z [modificationTime] => 2012-07-20T02:02:16.000Z [country] => GB [language] => en [title] => Apple iPod touch 8GB - Black - 4th Generation (Latest Model - Launched Sept 2010) [description] => Apple iPod touch 8GB - Black - 4th Generation (Latest Model - Launched Sept 2010) [link] => http://www.amazon.co.uk/dp/B0040GIZTI/ref=asc_df_B0040GIZTI8843997?smid=A1YZ4RXO7GUOYN&tag=googlecouk06-21&linkCode=asn&creative=22218&creativeASIN=B0040GIZTI [brand] => Apple [condition] => new [gtin] => 00885909394739 [gtins] => Array ( [0] => 00885909394739 ) [mpns] => Array ( [0] => MC540BT/A ) [inventories] => Array ( [0] => Array ( [channel] => online [availability] => inStock [price] => 135.95 [shipping] => 1.99 [currency] => GBP ) ) [images] => Array ( [0] => Array ( [link] => http://ecx.images-amazon.com/images/I/41p2rNmazRL.jpg [status] => available ) ) ) ) [1] => Array ( [kind] => shopping#product [id] => tag:google.com,2010:shopping/products/5735617/4597224105326146239 [selfLink] => https://www.googleapis.com/shopping/search/v1/public/products/5735617/gid/4597224105326146239 [product] => Array ( [googleId] => 4597224105326146239 [author] => Array ( [name] => Amazon.co.uk [accountId] => 5735617 ) [creationTime] => 2012-05-04T05:03:50.000Z [modificationTime] => 2012-07-20T02:02:16.000Z [country] => GB [language] => en [title] => SanDisk Sansa Clip+ 8GB MP3 Player with Radio and Expandable MicroSD/SDHC Slot - Black [description] => 8 GB memory Digital FM-tuner with 40 preset radio stations Extendable microSD/microSDHC card slot [link] => http://www.amazon.co.uk/dp/B002NX0ME6/ref=asc_df_B002NX0ME68843997?smid=A3P5ROKL5A1OLE&tag=googlecouk06-21&linkCode=asn&creative=22206&creativeASIN=B002NX0ME6 [brand] => SanDisk [condition] => new [gtin] => 00619659059989 [gtins] => Array ( [0] => 00619659059989 ) [mpns] => Array ( [0] => SDMX18-008G-E46K ) [inventories] => Array ( [0] => Array ( [channel] => online [availability] => inStock [price] => 46.95 [shipping] => 0 [currency] => GBP ) ) [images] => Array ( [0] => Array ( [link] => http://ecx.images-amazon.com/images/I/419U6bYDF1L.jpg [status] => available ) ) ) ) </code></pre> <p>I don't need all this data i just need 3-4 of the keys but how would i access them? How would i echo the value of say [title] from each array?</p>
Tags
<php><arrays><multidimensional-array>
Title
Get value in mutli array
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USMark Godley
UserOwnerUserId
1. USMark Godley
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
  singulars
  PostTypePostTypeId
  PTAnswer
2. PO
  singulars
  PostTypePostTypeId
  PTAnswer
3. PO
  singulars
  PostTypePostTypeId
  PTAnswer
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. COOk i fixed it. Solution was: foreach ($results['items'] as $result) { echo $result['product']['title']; }
  singulars
  PostPostId
  POGet value in mutli array
  UserUserId
  USMark Godley

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.