StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
6823087
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2011-07-25T22:21:32.697
FavoriteCount
0
LastActivityDate
2011-07-25T22:59:02.397
LastEditDate
2011-07-25T22:59:02.397
LastEditorUserId
367456
OwnerUserId
367456
ParentId
6823032
PostTypeId
2
Score
2
ViewCount
0
LastEditorDisplayName
text
Body
<blockquote> What am i doing wrong? </blockquote> The xpath expression <code>@id</code> (second parameter) returns an array but <code>preg_match</code> expects a string. Convert it to string first: <code>string(@id)</code>. Next to that you need to actually compare the output to 1 as <code>preg_match</code> returns <code>1</code> when found: <pre><code>foreach($xpath->query("//table[@id and 1 = php:function('preg_match', '/post\d+/', string(@id))]") as $key => $row) { var_dump($key, $row, $row->ownerDocument->saveXml($row)); } </code></pre> Explanation/What happens here?: A xpath expression will by default return a node-list (more precisely node-set). If you map a PHP function onto such expressions these sets are represented in form of an array. You can easily tests that by using <code>var_dump</code>: <pre><code>$xpath->query("php:function('var_dump', //table)"); array(1) { [0]=> object(DOMElement)#3 (0) { } } </code></pre> Same for the xpath expression <code>@id</code> in the context of each table element: <pre><code>$xpath->query("//table[php:function('var_dump', @id)]"); array(1) { [0]=> object(DOMAttr)#3 (0) { } } </code></pre> You can change that into a string typed result by making use of the <a href="http://www.w3.org/TR/xpath/#section-String-Functions" rel="nofollow">xpath <code>string</code> function</a>: <blockquote> A node-set is converted to a string by returning the string-value of the node in the node-set that is first in document order. If the node-set is empty, an empty string is returned. </blockquote> <pre><code>$xpath->query("//table[php:function('var_dump', string(@id))]"); string(4) "test" </code></pre> (the table has <code>id="test"</code>)
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POUsing regex to filter attributes in xpath with php
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. UShakre
UserOwnerUserId
1. UShakre
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. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
2. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
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.