StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
4692072
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
1
CommunityOwnedDate
CreationDate
2011-01-14T14:29:39.413
FavoriteCount
0
LastActivityDate
2011-01-14T14:29:39.413
LastEditDate
LastEditorUserId
0
OwnerUserId
16645
ParentId
4692047
PostTypeId
2
Score
1
ViewCount
0
LastEditorDisplayName
text
Body
Here's a function modified from another I found online; it strips out any HTML, and cleans up some funky MS characters first; it then adds in an optional ellipsis character to the content to show that it's been shortened. It correctly splits at a word, so you won't have seemingly random characters; <pre><code>/** * Function to ellipse-ify text to a specific length * * @param string $text The text to be ellipsified * @param int $max The maximum number of characters (to the word) that should be allowed * @param string $append The text to append to $text * @return string The shortened text * @author Brenley Dueck * @link http://www.brenelz.com/blog/2008/12/14/creating-an-ellipsis-in-php/ */ function ellipsis($text, $max=100, $append='&hellip;') { if (strlen($text) <= $max) return $text; $replacements = array( '| |' => ' ', '|&nbsp;|' => ' ', '|&rsquo;|' => '\'', '|&lsquo;|' => '\'', '|&ldquo;|' => '"', '|&rdquo;|' => '"', ); $patterns = array_keys($replacements); $replacements = array_values($replacements); $text = preg_replace($patterns, $replacements, $text); // convert double newlines to spaces $text = strip_tags($text); // remove any html. we *only* want text $out = substr($text, 0, $max); if (strpos($text, ' ') === false) return $out.$append; return preg_replace('/(\W)&(\W)/', '$1&amp;$2', (preg_replace('/\W+$/', ' ', preg_replace('/\w+$/', '', $out)))) . $append; } </code></pre> Input: <code>The latest grocery news is that the Kroger Co. is testing a new self-checkout technology. My question is: What&rsquo;s in it for me? Kroger said the system, from Fujitsu,</code> Output: <code>The latest grocery news is that the Kroger Co. is testing a new self-checkout technology. My question is: What's in it for me? Kroger said the …</code>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POPHP - get first two sentences of a text?
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USGlen Solsberry
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. COVery nice. It works great. Thanks for sharing.
 singulars
 PostPostId
 PO
 UserUserId
 USctown4life

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.