StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
14115659
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2013-01-02T00:38:09.607
FavoriteCount
0
LastActivityDate
2013-01-02T00:47:23.183
LastEditDate
2013-01-02T00:47:23.183
LastEditorUserId
1159795
OwnerUserId
1159795
ParentId
14115483
PostTypeId
2
Score
0
ViewCount
0
LastEditorDisplayName
text
Body
<pre><code>// Set up some variables $question = $choice1 = $choice2 = $choice3 = $correct = array(); $string = '1. An FMS system, besides controlling navigation, thrust and auto-nav, also provides: a) take-off and landing warnings * b) dedicated status and warnings c) GPWS warnings 2. EADI sky and ground display is provided by: a) synthetic TV signals * b) raster scan c) stroke pulse'; // Break question string into an array of questions with answers $data = explode("\r\n\r\n", $string); // Iterate through each question with answers foreach ($data AS $i => $tmp) { // Extract question and answers preg_match('/\d+\. (.*):\r\n(\*?)\ ?[abc]\) (.*)\r\n(\*?)\ ?[abc]\)\ (.*)\r\n(\*?)\ ?[abc]\)\ (.*)/s', $tmp, $matches); // Assign matches to variables $question[$i] = $matches[1]; $choice1[$i] = $matches[3]; $choice2[$i] = $matches[5]; $choice3[$i] = $matches[7]; // Figure out which answer is correct if ($matches[2] == '*') { $correct[$i] = 1; } else if ($matches[4] == '*') { $correct[$i] = 2; } else if ($matches[6] == '*') { $correct[$i] = 3; } } var_dump($question, $choice1, $choice2, $choice3, $correct); </code></pre> <p>Outputs:</p> <pre><code>// $question array(2) { [0]=> string(82) "An FMS system, besides controlling navigation, thrust and auto-nav, also provides" [1]=> string(42) "EADI sky and ground display is provided by" } // $choice1 array(2) { [0]=> string(29) "take-off and landing warnings" [1]=> string(20) "synthetic TV signals" } // $choice2 array(2) { [0]=> string(29) "dedicated status and warnings" [1]=> string(11) "raster scan" } // $choice3 array(2) { [0]=> string(13) "GPWS warnings" [1]=> string(12) "stroke pulse" } // $correct array(2) { [0]=> int(2) [1]=> int(2) } </code></pre>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POHow to extract a text using regex?
  singulars
  PostTypePostTypeId
  PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USVoitek Zylinski
UserOwnerUserId
1. USVoitek Zylinski
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.