StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
13424411
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2012-11-16T21:06:20.993
FavoriteCount
0
LastActivityDate
2012-11-16T21:06:20.993
LastEditDate
LastEditorUserId
0
OwnerUserId
461186
ParentId
13408967
PostTypeId
2
Score
1
ViewCount
0
LastEditorDisplayName
text
Body
<p>OP Asked for an example on the preferred way to write html for his example. Please don't treat this as an actual answer to his question:</p> <pre><code><?php while($row = $sth->fetch()): ?> <tr data-url="edit.php?id=<?php echo $row['id']; ?>"> <td><?php echo $row['id'] ; ?></td> <td><?php echo $row['firstName']; ?></td> <td><?php echo $row['lastName']; ?></h3><td> <td><?php echo $row['country']; ?></td> <td><?php echo $row['roomtype']; ?></td> <td><?php echo $row['roomnumber']; ?></td> <td><?php echo $row['checkin']; ?></td> <td><?php echo $row['nights']; ?></td> </tr> <?php endwhile; ?> </code></pre> <p>Here's why this is preferred, though the opinion may vary from person to person: Maintainability: if code is easier to read, it is easier to maintain. when you echo html in php you are subject to escaping html, making it more cluttered to read...</p> <pre><code><?php echo "<div class=\"someclass\">" . $content . "</div>"; ?> </code></pre> <p>effectively the same as:</p> <pre><code><?php echo '<div class="someclass">' . $content . '</div>'; ?> </code></pre> <p>except that the second example (single quotes is string literal) does not require escaping the double quotes. However, in either case, anyone who has to maintain this would much prefer this:</p> <pre><code><div class="someclass"><?php echo $content; ?></div> </code></pre> <p>Because it is cleaner. Why? It just is. Also, many of the editors people use will highlight syntax differently for each language, so that in part makes it easier to read.</p> <p>There may be cases where echoing html in php makes some sense, but treat it very sparingly. Anyone that reads your code after you will appreciate it.</p> <p>Side note - you might want to change the html attribute "url" in your example to "data-url" as this is another convention you should use to keep people happy. Custom attributes are supported, but it is not a good idea to just make them up as you go. But if you have to, data- is the standard prefix for custom attributes.</p>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POHidden field in table
  singulars
  PostTypePostTypeId
  PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USKai Qing
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
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
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.