StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POGet text between repeating <tr></tr> tags
primarykey
Id
18205132
data
AcceptedAnswerId
18206002
AnswerCount
3
ClosedDate
CommentCount
2
CommunityOwnedDate
CreationDate
2013-08-13T09:17:48.497
FavoriteCount
0
LastActivityDate
2013-08-14T23:52:21.220
LastEditDate
2013-08-13T09:55:09.030
LastEditorUserId
1314404
OwnerUserId
1314404
ParentId
0
PostTypeId
1
Score
-1
ViewCount
545
LastEditorDisplayName
text
Body
I got head-ache trying to solve this problem. I have a structure like this: <pre><code><tr> <td width="10%" bgcolor="#FFFFFF">17-Aug-2013</td> <td width="4%" bgcolor="#FFFFFF" align=center>Sat</td> <td width="4%" bgcolor="#FFFFFF" align="center">5 PM</td> <td width="15%" bgcolor="#FFFFFF" align="center"><a class="black_9" href="teams.asp?teamno=766&leagueNo=115">XYZ Club FC</a></td> <td width="5%" bgcolor="#FFFFFF" align="center"><img src="img/colors/white.gif"></td> <td width="5%" bgcolor="#FFFFFF" align="center"></td> <td width="5%" bgcolor="#FFFFFF" align="center">vs</td> <td width="5%" bgcolor="#FFFFFF" align="center"></td> <td width="5%" bgcolor="#FFFFFF" align="center"><img src="img/colors/orange.gif"></td> <td width="15%" bgcolor="#FFFFFF" align="center"><a class="black_9" href="teams.asp?teamno=632&leagueNo=115">ABC Football Club</a></td> <td width="15%" bgcolor="#FFFFFF" align="center"><a href="pitches.asp?id=151" class=list>APSM Pitch </a></td> <td width="4%" bgcolor="#FFFFFF" align="center"><a target="_new" href="matchpreview_frame.asp?matchno=20877"><img src="img/matchpreview_symbol.gif" border="0"></a></td> </tr> </code></pre> this format will repeat many times with different text contain, sometime, some text contain is similar. I need to extract ONLY the FIRST group of this format, where it contain "ABC Football Club" the FIRST TIME (because it could appear many times later also). How do I do that and extract the text on each line ? Thanks for the comments, I editted here to add some codes I tried: <pre><code> $ch = curl_init(); curl_setopt($ch, CURLOPT_URL, 'url link'); curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); $html = curl_exec($ch); curl_close($ch); $dom = new DOMDocument(); @$dom->loadHTML($html); $xpath = new DOMXPath($dom); $trs = $xpath->query('//tr/td[contains(.,'ABC Football Club')]'); $rows = array(); foreach($trs as $tr) $rows[] = innerHTML($tr, true); // this function I don't include here print_r($rows); </code></pre> However this one not work! :(
Tags
<php><regex><phpquery>
Title
Get text between repeating <tr></tr> tags
singulars
PostAcceptedAnswerId
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USuser1314404
UserOwnerUserId
1. USuser1314404
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. VO
 singulars
 PostPostId
 POGet text between repeating <tr></tr> tags
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTDownMod
CommentsPostId
1. COhow are you fetching the records? show some code
 singulars
 PostPostId
 POGet text between repeating <tr></tr> tags
 UserUserId
 USchirag ode
2. COfor extracting data from a "Markup"-language as XML and HTML, use tools for markup-languges insted of regexp
 singulars
 PostPostId
 POGet text between repeating <tr></tr> tags
 UserUserId
 USPuggan Se

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.