StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
8941073
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
3
CommunityOwnedDate
CreationDate
2012-01-20T11:56:17.737
FavoriteCount
0
LastActivityDate
2012-04-07T02:41:53.803
LastEditDate
2012-04-07T02:41:53.803
LastEditorUserId
1265397
OwnerUserId
769237
ParentId
8937472
PostTypeId
2
Score
10
ViewCount
0
LastEditorDisplayName
text
Body
I extend the session class by creating <code>/application/libaries/MY_Session.php</code> <pre><code>class MY_Session extends CI_Session { function __construct() { parent::__construct(); $this->tracker(); } function tracker() { $this->CI->load->helper('url'); $tracker =& $this->userdata('_tracker'); if( !IS_AJAX ) { $tracker[] = array( 'uri' => $this->CI->uri->uri_string(), 'ruri' => $this->CI->uri->ruri_string(), 'timestamp' => time() ); } $this->set_userdata( '_tracker', $tracker ); } function last_page( $offset = 0, $key = 'uri' ) { if( !( $history = $this->userdata('_tracker') ) ) { return $this->config->item('base_url'); } $history = array_reverse($history); if( isset( $history[$offset][$key] ) ) { return $history[$offset][$key]; } else { return $this->config->item('base_url'); } } } </code></pre> And then to retrieve the URL of the last page visited you call <pre><code>$this->session->last_page(); </code></pre> And you can increase the offset and type of information returned etc too <pre><code>$this->session->last_page(1); // page before last $this->session->last_page(2); // 3 pages ago </code></pre> The function doesn't add pages called using Ajax to the tracker but you can easily remove the <code>if( !IS_AJAX )</code> bit to make it do so. Edit: If you run to the error Undefined constant IS_AJAX, assumed IS_AJAX add the line below to <code>/application/config/constants.php</code> <pre><code>define('IS_AJAX', isset($_SERVER['HTTP_X_REQUESTED_WITH']) && strtolower($_SERVER['HTTP_X_REQUESTED_WITH']) == 'xmlhttprequest'); </code></pre>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POcreating back page links in Codeigniter
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USHafiz Bistar
UserOwnerUserId
1. USBen Swinburne
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
2. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTApproveEditSuggestion
3. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId
1. COBen your suggestion is also helpful like @Ruben ..thanks for your response.
 singulars
 PostPostId
 PO
 UserUserId
 USArslan
2. CONo problem. Any luck solving your problem?
 singulars
 PostPostId
 PO
 UserUserId
 USBen Swinburne

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.