StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
11274724
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2012-06-30T14:10:06.310
FavoriteCount
0
LastActivityDate
2012-06-30T14:17:01.970
LastEditDate
2012-06-30T14:17:01.970
LastEditorUserId
387347
OwnerUserId
387347
ParentId
11274568
PostTypeId
2
Score
1
ViewCount
0
LastEditorDisplayName
text
Body
Let's assume your domain is "showoff.com" and their domain is "acme.com" You have two basic options: "showoff.acme.com" or "acme.showoff.com". I have done this both ways. For "showoff.acme.com": <ul> <li>The customer will need to set up a CNAME entry pointing to showoff.com in their DNS. Explaining to the customer how to do this is not trivial, and doesn't make much business sense unless you have a small, high-paying customer base.</li> <li>You will need to configure an Apache virtualhost to answer all requests to all domains (not just showoff.com)</li> <li>You cannot use SSL unless you configure a virtualhost and IP and certificate for each individual customer. (A pain!)</li> </ul> For "acme.showoff.com": <ul> <li>You will need a <a href="http://en.wikipedia.org/wiki/Wildcard_DNS_record" rel="nofollow">wildcard DNS record</a> to point *.showoff.com to your server's IP (whether this is easy depends on your DNS provider); if you are unable to do this, you will need to create a DNS record for each customer.</li> <li>You will need to configure an Apache virtualhost to answer all requests to *.showoff.com</li> <li>You can use a <a href="http://en.wikipedia.org/wiki/Wildcard_SSL_certificate" rel="nofollow">wildcard SSL certificate</a> for *.showoff.com</li> </ul> In both scenarios, in your PHP you can find out what domain was requested with <code>$_SERVER['HTTP_HOST']</code>. You will want to check this against your database of recognized domains, to determine which customer's data to show. As you can see, most of the work is in DNS and Apache; it doesn't really matter whether you use PHP or some other language.
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POHow to mask URL's like cloudapp, so users can showoff our data on "their" server
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USMark Eirich
UserOwnerUserId
1. USMark Eirich
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. POHow to mask URL's like cloudapp, so users can showoff our data on "their" server
 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
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.