StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
5831191
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
51
CommunityOwnedDate
2013-08-24T02:49:59.620
CreationDate
2011-04-29T11:03:33.050
FavoriteCount
0
LastActivityDate
2017-03-11T02:05:38.180
LastEditDate
2017-03-11T02:05:38.180
LastEditorUserId
63550
OwnerUserId
433790
ParentId
5830387
PostTypeId
2
Score
279
ViewCount
0
LastEditorDisplayName
text
Body
A YouTube video URL may be encountered in a variety of formats: <ul> <li>latest short format: <code>http://youtu.be/NLqAF9hrVbY</code></li> <li>iframe: <code>http://www.youtube.com/embed/NLqAF9hrVbY</code></li> <li>iframe (secure): <code>https://www.youtube.com/embed/NLqAF9hrVbY</code></li> <li>object param: <code>http://www.youtube.com/v/NLqAF9hrVbY?fs=1&hl=en_US</code></li> <li>object embed: <code>http://www.youtube.com/v/NLqAF9hrVbY?fs=1&hl=en_US</code></li> <li>watch: <code>http://www.youtube.com/watch?v=NLqAF9hrVbY</code></li> <li>users: <code>http://www.youtube.com/user/Scobleizer#p/u/1/1p3vcRhsYGo</code></li> <li>ytscreeningroom: <code>http://www.youtube.com/ytscreeningroom?v=NRHVzbJVx8I</code></li> <li>any/thing/goes!: <code>http://www.youtube.com/sandalsResorts#p/c/54B8C800269D7C1B/2/PPS-8DMrAn4</code></li> <li>any/subdomain/too: <code>http://gdata.youtube.com/feeds/api/videos/NLqAF9hrVbY</code></li> <li>more params: <code>http://www.youtube.com/watch?v=spDj54kf-vY&feature=g-vrec</code></li> <li>query may have dot: <code>http://www.youtube.com/watch?v=spDj54kf-vY&feature=youtu.be</code></li> <li>nocookie domain: <code>http://www.youtube-nocookie.com</code></li> </ul> Here is a PHP function with a commented regex that matches each of these URL forms and converts them to links (if they are not links already): <pre class="lang-php prettyprint-override"><code>// Linkify youtube URLs which are not already links. function linkifyYouTubeURLs($text) { $text = preg_replace('~(?#!js YouTubeId Rev:20160125_1800) # Match non-linked youtube URL in the wild. (Rev:20130823) https?:// # Required scheme. Either http or https. (?:[0-9A-Z-]+\.)? # Optional subdomain. (?: # Group host alternatives. youtu\.be/ # Either youtu.be, | youtube # or youtube.com or (?:-nocookie)? # youtube-nocookie.com \.com # followed by \S*? # Allow anything up to VIDEO_ID, [^\w\s-] # but char before ID is non-ID char. ) # End host alternatives. ([\w-]{11}) # $1: VIDEO_ID is exactly 11 chars. (?=[^\w-]|$) # Assert next char is non-ID or EOS. (?! # Assert URL is not pre-linked. [?=&+%\w.-]* # Allow URL (query) remainder. (?: # Group pre-linked alternatives. [\'"][^<>]*> # Either inside a start tag, | </a> # or inside <a> element text contents. ) # End recognized pre-linked alts. ) # End negative lookahead assertion. [?=&+%\w.-]* # Consume any URL (query) remainder. ~ix', '<a href="http://www.youtube.com/watch?v=$1">YouTube link: $1</a>', $text); return $text; } </code></pre> ; // End $YouTubeId. And here is a JavaScript version with the exact same regex (with comments removed): <pre class="lang-js prettyprint-override"><code>// Linkify youtube URLs which are not already links. function linkifyYouTubeURLs(text) { var re = /https?:\/\/(?:[0-9A-Z-]+\.)?(?:youtu\.be\/|youtube(?:-nocookie)?\.com\S*?[^\w\s-])([\w-]{11})(?=[^\w-]|$)(?![?=&+%\w.-]*(?:['"][^<>]*>|<\/a>))[?=&+%\w.-]*/ig; return text.replace(re, '<a href="http://www.youtube.com/watch?v=$1">YouTube link: $1</a>'); } </code></pre> Notes: <ul> <li>The VIDEO_ID portion of the URL is captured in the one and only capture group: <code>$1</code>.</li> <li>If you know that your text does not contain any pre-linked URLs, you can safely remove the negative lookahead assertion which tests for this condition (The assertion beginning with the comment: "Assert URL is not pre-linked.") This will speed up the regex somewhat.</li> <li>The replace string can be modified to suit. The one provided above simply creates a link to the generic <code>"http://www.youtube.com/watch?v=VIDEO_ID"</code> style URL and sets the link text to: <code>"YouTube link: VIDEO_ID"</code>.</li> </ul> <hr> Edit 2011-07-05: Added <code>-</code> hyphen to ID char class Edit 2011-07-17: Fixed regex to consume any remaining part (e.g. query) of URL following YouTube ID. Added <code>'i'</code> ignore-case modifier. Renamed function to camelCase. Improved pre-linked lookahead test. Edit 2011-07-27: Added new "user" and "ytscreeningroom" formats of YouTube URLs. Edit 2011-08-02: Simplified/generalized to handle new "any/thing/goes" YouTube URLs. Edit 2011-08-25: Several modifications: <ul> <li>Added a Javascript version of: <code>linkifyYouTubeURLs()</code> function.</li> <li>Previous version had the scheme (HTTP protocol) part optional and thus would match invalid URLs. Made the scheme part required.</li> <li>Previous version used the <code>\b</code> word boundary anchor around the VIDEO_ID. However, this will not work if the VIDEO_ID begins or ends with a <code>-</code> dash. Fixed so that it handles this condition.</li> <li>Changed the VIDEO_ID expression so that it must be exactly 11 characters long.</li> <li>The previous version failed to exclude pre-linked URLs if they had a query string following the VIDEO_ID. Improved the negative lookahead assertion to fix this.</li> <li>Added <code>+</code> and <code>%</code> to character class matching query string.</li> <li>Changed PHP version regex delimiter from: <code>%</code> to a: <code>~</code>.</li> <li>Added a "Notes" section with some handy notes.</li> </ul> Edit 2011-10-12: YouTube URL host part may now have any subdomain (not just <code>www.</code>). Edit 2012-05-01: The consume URL section may now allow for '-'. Edit 2013-08-23: Added additional format provided by @Mei. (The query part may have a <code>.</code> dot. Edit 2013-11-30: Added additional format provided by @CRONUS: <code>youtube-nocookie.com</code>. Edit 2016-01-25: Fixed regex to handle error case provided by CRONUS.
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POHow do I find all YouTube video ids in a string using a regex?
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USPeter Mortensen
UserOwnerUserId
1. USridgerunner
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. PL
 singulars
 LinkTypeLinkTypeId
 LTLinked
PostsAcceptedAnswerId
1. POHow do I find all YouTube video ids in a string using a regex?
 singulars
 PostTypePostTypeId
 PTQuestion
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
 VTAcceptedByOriginator
3. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId

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.