StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PONeed to extract special tags and replace them based upon their contents using regular expression
primarykey
Id
3510297
data
AcceptedAnswerId
3510347
AnswerCount
3
ClosedDate
CommentCount
2
CommunityOwnedDate
CreationDate
2010-08-18T08:38:56.190
FavoriteCount
1
LastActivityDate
2011-11-13T17:21:15.220
LastEditDate
LastEditorUserId
0
OwnerUserId
89752
ParentId
0
PostTypeId
1
Score
0
ViewCount
266
LastEditorDisplayName
text
Body
I'm working on a simple templating system. Basically I'm setting it up such that a user would enter text populated with special tags of the form: <code><== variableName ==></code> When the system would display the text it would search for all tags of the form mentioned and replace the variableName with its corresponding value from a database result. I think this would require a regular expression but I'm really messed up in REGEX here. I'm using php btw. Thanks for the help guys.
Tags
<php><regex>
Title
Need to extract special tags and replace them based upon their contents using regular expression
singulars
PostAcceptedAnswerId
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USAli
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. PL
 singulars
 LinkTypeLinkTypeId
 LTLinked
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
 PONeed to extract special tags and replace them based upon their contents using regular expression
 UserUserId
 USMrWhite
 VoteTypeVoteTypeId
 VTFavorite
CommentsPostId
1. COCall it YATS: Yet another Template System - No, seriously, why reinvent the wheel? PHP by itself is already a template engine. If you need a 3rd party Template System, why not use one of the many freely available, like Twig or Smarty or [insert favorite framework here](http://en.wikipedia.org/wiki/Template_engine_%28web%29). And if you really need to do your own, then why not go full length and make those *tags* actually tags, e.g. elements with a namespace, like `<my:var id="foo"/>`. Then you can use DOM for the replacements.
 singulars
 PostPostId
 PONeed to extract special tags and replace them based upon their contents using regular expression
 UserUserId
 USGordon
2. COThanks but its not exactly a template system in teh fullest sense of the word - my system creates email requests and need to create the emails in a specific format. The templating system just grabs values from a database to preset the emails. The client in this case needed a way to define the templates himself.
 singulars
 PostPostId
 PONeed to extract special tags and replace them based upon their contents using regular expression
 UserUserId
 USAli

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.