StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
1102931
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
1
CommunityOwnedDate
CreationDate
2009-07-09T09:56:51.607
FavoriteCount
0
LastActivityDate
2009-07-09T15:06:24.810
LastEditDate
2009-07-09T15:06:24.810
LastEditorUserId
42971
OwnerUserId
42971
ParentId
1102650
PostTypeId
2
Score
1
ViewCount
0
LastEditorDisplayName
text
Body
Based on your comment to deceze's answer, are you looking for something like PHP's <a href="http://us.php.net/manual/en/ref.filesystem.php" rel="nofollow noreferrer">filesystem functions</a>? Then, there is <a href="http://us.php.net/manual/en/function.system.php" rel="nofollow noreferrer">system</a> and its related functions, which gives access to Unix commands, but I'd recommend other ways of doing things if possible. Edit: In response to the comments about needing user and group functionality: <ul> <li>Firstly, in case your plan is to let web users have access to the whole file system (or even just their regular log in directories), I just want to advise against that - lots of security concerns (eg. if someone else gets into a user's account, they could delete everything to which they have access).</li> <li>The little experience I have with handling users in PHP was in some beginner level training. In that class, we had our users in an SQL database and used <a href="http://us.php.net/manual/en/book.session.php" rel="nofollow noreferrer">sessions</a>. We didn't use SSL, but I'd advise some sort of crypto when passing passwords around.</li> <li>If you're using <a href="http://httpd.apache.org/" rel="nofollow noreferrer">Apache</a>, it can handle the authentication for you. Other server software can probably do the same, but Apache is all I've ever worked with. I can't address whether Apache can handle sessions itself and don't have the time to research it right now.</li> </ul>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POUNIX wrapper in PHP
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USPTBNL
UserOwnerUserId
1. USPTBNL
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. POUNIX wrapper in PHP
 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. COFilesystem functions would certainly be involved, but the user and group accounts are important requirements too. I realise that there are potential issues, but I just wonder if (and hope that) someone's solved them already.
 singulars
 PostPostId
 PO
 UserUserId
 USBobby Jack

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.