StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
20272944
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2013-11-28T18:42:00.613
FavoriteCount
0
LastActivityDate
2013-11-28T20:01:20.593
LastEditDate
2013-11-28T20:01:20.593
LastEditorUserId
2689507
OwnerUserId
2689507
ParentId
20123557
PostTypeId
2
Score
3
ViewCount
0
LastEditorDisplayName
text
Body
<p>Finally could make it work. here a short version of this (without ajax and smarty and harcoded users) online and working: </p> <p><a href="http://bootply.com/97366" rel="nofollow">http://bootply.com/97366</a></p> <p><strong>View:</strong></p> <pre><code><tbody> {foreach $frontusers as $frontuser} <tr> {if $frontuser->frontavatar_id eq null} <td><img src="{site_url()}assets/img/avatar.png" alt="" /></td> {else} <td><img src="{site_url()}assets/img/avatar1.jpg" alt="" /></td> {/if} <td class="hidden-phone">{$frontuser->username}</td> <td>{$frontuser->name}</td> <td>{$frontuser->lastname}</td> <td class="hidden-phone">{$frontuser->email}</td> <td class="hidden-phone">{$frontuser->state}</td> <td class="hidden-phone">{$frontuser->creation_date|date_format:"%Y/%m/%d"}</td> {if $frontuser->status eq 2} <td ><span class="label label-success">Activo</span></td> {else} <td ><span class="label label-warning">No Activo</span></td> {/if} <td><a class="btn mini blue-stripe" href="{site_url()}admin/editFront/{$frontuser->id}">Edit</a></td> //here in data-title i store the username so later i can "catch it" in the jquery function <td><a href="#" class="confirm-delete btn mini red-stripe" role="button" data-title="{$frontuser->username}" data-id="{$frontuser->id}">Delete</a></td> </tr>  <div id="myModal" class="modal hide fade" tabindex="-1" role="dialog" aria-labelledby="myModalLabel3" aria-hidden="true"> <div class="modal-header"> <button type="button" class="close" data-dismiss="modal" aria-hidden="true"></button> <h3 id="myModalLabel3">Delete</h3> </div> <div class="modal-body"> <p></p> </div> <div class="modal-footer"> <button class="btn" data-dismiss="modal" aria-hidden="true">Cerrar</button> <button data-dismiss="modal" class="btn red" id="btnYes">Confirmar</button> </div> </div>  {foreachelse} //no users are in the db <tr> <td colspan="2"><span class="text-error"><i class="icon-exclamation"></i> No hay Usuarios cargados.</span></td> </tr> {/foreach} </tbody> </code></pre> <p><strong>Js File:</strong></p> <pre><code>//after first function is triggered, modal shows and this function runs $('#myModal').on('show', function() { //catch the id for later deletion, and username to display on modal var id = $(this).data('id'), username = $(this).data('usern'); $('#myModal .modal-body p').html("Do you want to delete user: " + '<b>' + username + '</b>' + ' ?'); }) //when clicking "delete" button from a row, this is the first function that runs $('.confirm-delete').on('click', function(e) { e.preventDefault(); //catch the user id and username var id = $(this).data('id'); var user = $(this).data('title'); //assign to the modal id and username $('#myModal').data('id', id).modal('show'); $('#myModal').data('usern', user).modal('show'); }); $('#btnYes').click(function() { var id = $('#myModal').data('id'); //sending to php the row to be deleted from the db $.ajax({ url: 'deleteFrontUser', type: 'POST', data: 'id='+id, success: function(html){ //removing entire row $('[data-id='+id+']').parents('tr').remove(); $('#myModal').modal('hide'); } }); return false; }); </code></pre>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POsend parameter to a modal and then deleting row
  singulars
  PostTypePostTypeId
  PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USLimon
UserOwnerUserId
1. USLimon
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. POsend parameter to a modal and then deleting row
  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
  VTAcceptedByOriginator
2. 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.