StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
17158114
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2013-06-17T22:48:44.810
FavoriteCount
0
LastActivityDate
2013-06-17T22:48:44.810
LastEditDate
LastEditorUserId
0
OwnerUserId
2000503
ParentId
17157329
PostTypeId
2
Score
0
ViewCount
0
LastEditorDisplayName
text
Body
<p>The data you're after is stored in the node attributes in that XML, so here's a simple PHP code snippet to get you on your way.</p> <pre><code>$xml = <<<XML <?xml version="1.0"?><xml_api_reply version="1"><finance module_id="0" tab_id="0" mobile_row="0" mobile_zipped="1" row="0" section="0" ><symbol data="FUM1V"/><pretty_symbol data="FUM1V"/><symbol_lookup_url data="/finance?client=ig&amp;q=FUM1V"/><company data="Fortum Oyj"/><exchange data="HEL"/><exchange_timezone data=""/><exchange_utc_offset data=""/><exchange_closing data=""/><divisor data="2"/><currency data="EUR"/><last data="14.68"/><high data="14.77"/><low data="14.59"/><volume data="1216170"/><avg_volume data="1607"/><market_cap data="13041.22"/><open data="14.60"/><y_close data="14.59"/><change data="+0.09"/><perc_change data="0.62"/><delay data="0"/><trade_timestamp data="7 hours ago"/><trade_date_utc data="20130617"/><trade_time_utc data="152953"/><current_date_utc data="20130617"/><current_time_utc data="223403"/><symbol_url data="/finance?client=ig&amp;q=FUM1V"/><chart_url data="/finance/chart?q=HEL:FUM1V&amp;tlf=12"/><disclaimer_url data="/help/stock_disclaimer.html"/><ecn_url data=""/><isld_last data=""/><isld_trade_date_utc data=""/><isld_trade_time_utc data=""/><brut_last data=""/><brut_trade_date_utc data=""/><brut_trade_time_utc data=""/><daylight_savings data="true"/></finance><finance module_id="0" tab_id="0" mobile_row="0" mobile_zipped="1" row="0" section="0" ><symbol data="KNEBV"/><pretty_symbol data="KNEBV"/><symbol_lookup_url data="/finance?client=ig&amp;q=KNEBV"/><company data="KONE Corporation"/><exchange data="HEL"/><exchange_timezone data=""/><exchange_utc_offset data=""/><exchange_closing data=""/><divisor data="2"/><currency data="EUR"/><last data="65.95"/><high data="67.00"/><low data="65.95"/><volume data="249502"/><avg_volume data="303"/><market_cap data="16911.31"/><open data="66.10"/><y_close data="66.05"/><change data="-0.10"/><perc_change data="-0.15"/><delay data="0"/><trade_timestamp data="7 hours ago"/><trade_date_utc data="20130617"/><trade_time_utc data="152952"/><current_date_utc data="20130617"/><current_time_utc data="223403"/><symbol_url data="/finance?client=ig&amp;q=KNEBV"/><chart_url data="/finance/chart?q=HEL:KNEBV&amp;tlf=12"/><disclaimer_url data="/help/stock_disclaimer.html"/><ecn_url data=""/><isld_last data=""/><isld_trade_date_utc data=""/><isld_trade_time_utc data=""/><brut_last data=""/><brut_trade_date_utc data=""/><brut_trade_time_utc data=""/><daylight_savings data="true"/></finance></xml_api_reply> XML; $sxe = new SimpleXMLElement($xml); // In your case uncomment the following 2 lines // $url = 'http://www.google.com/ig/api?stock=KNEBV&stock=FUM1V'; // $sxe = new SimpleXMLElement($url, 0, true); foreach ($sxe->finance as $finance) { echo $finance->company->attributes()->data, '<br />'; echo $finance->symbol->attributes()->data, '<br /><br />'; } </code></pre> <h3>Output:</h3> <pre><code>Fortum Oyj FUM1V KONE Corporation KNEBV </code></pre>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POTrying to read SimpleXmlElement objects in twisted google array gives me blanks
  singulars
  PostTypePostTypeId
  PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USRolando Isidoro
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. This table or related slice is empty.
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. This table or related slice is empty.

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.