StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PORetrieving data from other tables in the view
primarykey
Id
14381467
data
AcceptedAnswerId
14381739
AnswerCount
1
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2013-01-17T14:39:39.320
FavoriteCount
0
LastActivityDate
2013-01-17T14:58:37.987
LastEditDate
2013-01-17T14:52:13.690
LastEditorUserId
524278
OwnerUserId
524278
ParentId
0
PostTypeId
1
Score
0
ViewCount
37
LastEditorDisplayName
text
Body
I'm passing a set of objects to the view, including some foreign IDs to other tables in the database. Say objects of comments that have an attribute 'writer_id' which refers to the id of the user. How can I display user's data (name for example) from the view ? Here's the controller 'comments' : <pre><code>function index() { $this->load->model('comment_model'); $data['comments'] = $this->comment_model->get_comments(); $this->load->view('comments',$data); } </code></pre> and this is inside comment_model : <pre><code>function get_comments() { $id = $this->uri->segment(3); // ignore this , it's given $q = $this->db->query("SELECT * FROM comments WHERE post_id=$id"); if ($q->num_rows() > 0 ) { foreach ($q->result() as $row){ $data[] = $row; } return $data; } } </code></pre> All what I can use in the view is the 'writer_id' and not able to display his name or any other data. UPDATE here's the view file <pre><code> <?php if (is_array($comments)){ ?> <?php foreach ($comments as $comment) : ?> <?php echo $comment->text;?> - written by <?php echo $comment->writer_id ?> <?php endforeach ;?> <?php } ?> </code></pre> This will print: <blockquote> bla bla bla - written by 4 </blockquote> where it should be <blockquote> bla bla bla - written by John (whose id is 4 as in user table) </blockquote>
Tags
<php><codeigniter>
Title
Retrieving data from other tables in the view
singulars
PostAcceptedAnswerId
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USFahd
UserOwnerUserId
1. USFahd
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. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. This table or related slice is empty.
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.