StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>It's an edge case but the use of str_replace() in Styledev's answer could cause issues if one entity is contained within another. For example, "I'm a genius! #me #mensa" could become "I'm a genius! <a href="http://example.com" rel="nofollow">#me</a> <a href="http://example.com" rel="nofollow">#me</a>nsa" if the shorter entity is substituted first.</p> <p>This solution avoids that problem:</p> <pre><code><?php /** * Hyperlinks hashtags, twitter names, and urls within the text of a tweet * * @param object $apiResponseTweetObject A json_decoded() one of these: https://dev.twitter.com/docs/platform-objects/tweets * @return string The tweet's text with hyperlinks added */ function linkEntitiesWithinText($apiResponseTweetObject) { // Convert tweet text to array of one-character strings // $characters = str_split($apiResponseTweetObject->text); $characters = preg_split('//u', $apiResponseTweetObject->text, null, PREG_SPLIT_NO_EMPTY); // Insert starting and closing link tags at indices... // ... for @user_mentions foreach ($apiResponseTweetObject->entities->user_mentions as $entity) { $link = "https://twitter.com/" . $entity->screen_name; $characters[$entity->indices[0]] = "<a href=\"$link\">" . $characters[$entity->indices[0]]; $characters[$entity->indices[1] - 1] .= "</a>"; } // ... for #hashtags foreach ($apiResponseTweetObject->entities->hashtags as $entity) { $link = "https://twitter.com/search?q=%23" . $entity->text; $characters[$entity->indices[0]] = "<a href=\"$link\">" . $characters[$entity->indices[0]]; $characters[$entity->indices[1] - 1] .= "</a>"; } // ... for http://urls foreach ($apiResponseTweetObject->entities->urls as $entity) { $link = $entity->expanded_url; $characters[$entity->indices[0]] = "<a href=\"$link\">" . $characters[$entity->indices[0]]; $characters[$entity->indices[1] - 1] .= "</a>"; } // ... for media foreach ($apiResponseTweetObject->entities->media as $entity) { $link = $entity->expanded_url; $characters[$entity->indices[0]] = "<a href=\"$link\">" . $characters[$entity->indices[0]]; $characters[$entity->indices[1] - 1] .= "</a>"; } // Convert array back to string return implode('', $characters); } ?> </code></pre>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload