StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PODOM XPath Query Help
primarykey
Id
5341995
data
AcceptedAnswerId
5342191
AnswerCount
1
ClosedDate
CommentCount
2
CommunityOwnedDate
CreationDate
2011-03-17T16:23:13.743
FavoriteCount
1
LastActivityDate
2011-03-17T16:52:18.100
LastEditDate
LastEditorUserId
0
OwnerUserId
318145
ParentId
0
PostTypeId
1
Score
3
ViewCount
2081
LastEditorDisplayName
text
Body
<p>so this xpath query is driving me crazy. What I'm trying to do is search an xml file (in this case a kml file for use with the google maps api) of golf courses for a specific course type and grab each matching <code><Placemark></code> element so that i can create a new xml object with the results so that I can further filter with a new query. Problem is I can't seem to figure out how to get each matching <code><Placemark></code> element</p> <pre><code>$xml = '<?xml version="1.0" encoding="UTF-8"?> <kml xmlns="http://earth.google.com/kml/2.1"> <Document> <Placemark id="placemark3"> <name>Test Country Club</name> <description> <![CDATA[ <div class="contact">Post Office Box 329 <a href="#" target="_blank">website</a></div> ]]> </description> <alpha>a</alpha> <position>2</position> <type>Public/Daily Fee</type> <styleUrl>#nineholeStyle</styleUrl> <Point> <coordinates>-79.285576,37.111809</coordinates> </Point> </Placemark> </Document> </kml>'; $dom = new DOMDocument(); $dom->loadXML($xml); $xpath = new DOMXPath($dom); //trying to get any Placemark element where type child matches a specific query //in this case we want to search for Public/Daily Fee and return the placemark and everything inside it. $query = $xpath->query("//Placemark[type='Public/Daily Fee']/ancestor::Placemark");; foreach ($query as $result) { //eventually want to merge each result into new xml object to be further filtered } </code></pre> <p>Any help would be greatly appreciated. Thanks</p>
Tags
<php><dom><xpath>
Title
DOM XPath Query Help
singulars
PostAcceptedAnswerId
1. PO
  singulars
  PostTypePostTypeId
  PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USJamie
plurals
PostLinksPostIdRelatedPostId
1. PL
  singulars
  LinkTypeLinkTypeId
  LTLinked
PostLinksRelatedPostIdPostId
1. PL
  singulars
  LinkTypeLinkTypeId
  LTLinked
2. PL
  singulars
  LinkTypeLinkTypeId
  LTLinked
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
  singulars
  PostTypePostTypeId
  PTAnswer
VotesPostIdCreationDate
1. VO
  singulars
  PostPostId
  PODOM XPath Query Help
  UserUserId
  This table or related slice is empty.
  VoteTypeVoteTypeId
  VTUpMod
2. VO
  singulars
  PostPostId
  PODOM XPath Query Help
  UserUserId
  This table or related slice is empty.
  VoteTypeVoteTypeId
  VTUpMod
3. VO
  singulars
  PostPostId
  PODOM XPath Query Help
  UserUserId
  USa_fan
  VoteTypeVoteTypeId
  VTFavorite
CommentsPostId
1. COpossible duplicate of [Loading KML file in to mysql / xpath and x quires](http://stackoverflow.com/questions/5341039/loading-kml-file-in-to-mysql-xpath-and-x-quires)
  singulars
  PostPostId
  PODOM XPath Query Help
  UserUserId
  This table or related slice is empty.
2. CO@Alejando true, but it doesnt have an answer. Should probably be merged then.
  singulars
  PostPostId
  PODOM XPath Query Help
  UserUserId
  USGordon

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.