StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO2 Codeigniter Controller Querys on One View
primarykey
Id
1719150
data
AcceptedAnswerId
1719388
AnswerCount
2
ClosedDate
CommentCount
4
CommunityOwnedDate
CreationDate
2009-11-12T00:49:35.050
FavoriteCount
1
LastActivityDate
2011-07-28T10:25:12.897
LastEditDate
2009-11-12T01:39:43.857
LastEditorUserId
209183
OwnerUserId
209183
ParentId
0
PostTypeId
1
Score
1
ViewCount
4509
LastEditorDisplayName
text
Body
<p>How do you put two different function outputs from the same controller into the same view(page)? For example, I have a function going to the "article" div, and another function that I am trying to use within the "aside" div. (using HTML 5 nomenclature here)</p> <p>I have went as far as using the actual db query in the (view)aside div and it still only displays the 1st article function.</p> <p>I have changed the $data('result') variable to separate variables and that makes no difference.</p> <p>I am showing a todo list of jobs I have to do in the article div, then showing the titles of the completed todo's in the aside div.</p> <p>I suppose I am making a mess of this explanation. Would you use a function from a different controller?</p> <p>This is the first code in the controller</p> <pre><code>function index() { $this->load->model('work_m'); $data = array(); $config['base_url'] = base_url() . 'index.php/work/index/'; $config['total_rows'] = $this->db->count_all('work'); $config['per_page'] = '10'; $config['full_tag_open'] = '<div id="pagination">'; $config['full_tag_close'] = '</div>'; $this->pagination->initialize($config); $data['result'] = $this->work_m->get_records($config['per_page'], $this->uri-> segment(3)); $tmpl = array('table_open' => '<table border="0" cellpadding="0" cellspacing="0">', 'heading_row_start' => '<tr class="heading">', 'heading_row_end' => '</tr>', 'heading_cell_start' => '<th>', 'heading_cell_end' => '</th>', 'row_start' => '<tr>', 'row_end' => '</tr>', 'cell_start' => '<td>', 'cell_end' => '</td>', 'row_alt_start' => '<tr class="alt">', 'row_alt_end' => '</tr>', 'cell_alt_start' => '<td>', 'cell_alt_end' => '</td>', 'table_close' => '</table>'); $this->table->set_template($tmpl); $this->table->set_caption("Work Items"); //-- Header Row $this->table->set_heading('ID', 'Date', 'Title', 'Done', 'Item'); //-- Content Rows $data['title'] = 'Page Display'; $this->load->view('work_links', $data); </code></pre> <p>Note it points to work_links, a view</p> <p>the next function is this</p> <pre><code>function done() { $data = array(); if ($query = $this->work_m->dead_work()) { $data['dead'] = $query; } $tmpl = array('table_open' => '<table border="0" cellpadding="0" cellspacing="0">', 'heading_row_start' => '<tr class="heading">', 'heading_row_end' => '</tr>', 'heading_cell_start' => '<th>', 'heading_cell_end' => '</th>', 'row_start' => '<tr>', 'row_end' => '</tr>', 'cell_start' => '<td>', 'cell_end' => '</td>', 'row_alt_start' => '<tr class="alt">', 'row_alt_end' => '</tr>', 'cell_alt_start' => '<td>', 'cell_alt_end' => '</td>', 'table_close' => '</table>'); $this->table->set_template($tmpl); $this->load->view('work_links', $data); } </code></pre> <p>The models behind them are basic calls to the database</p> <p>Now this code in the view goes with the first function above(in the article div) and works perfectly</p> <pre><code>foreach($result as $row) { $this->table->add_row( anchor("work/fill_form/$row->id", $row->id), $row->date, $row->title, $row->compl, $this->typography->auto_typography($row->item) ); } $table = $this->table->generate(); echo $table; </code></pre> <p>this is the second code to go into the aside div(and goes with the second functiin above)</p> <pre><code>if (isset($dead)){ foreach($dead as $row) { $this->table->add_row( $row->id, $row->title, $row->finish ); } } $this->table->set_heading('ID', 'Title'); $table = $this->table->generate(); echo $table; </code></pre> <p>The last code only picks up the data from the first function no matter what i do.</p>
Tags
<php><codeigniter>
Title
2 Codeigniter Controller Querys on One View
singulars
PostAcceptedAnswerId
1. PO
  singulars
  PostTypePostTypeId
  PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USBrad
UserOwnerUserId
1. USBrad
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
2. PO
  singulars
  PostTypePostTypeId
  PTAnswer
VotesPostIdCreationDate
1. VO
  singulars
  PostPostId
  PO2 Codeigniter Controller Querys on One View
  UserUserId
  This table or related slice is empty.
  VoteTypeVoteTypeId
  VTUpMod
2. VO
  singulars
  PostPostId
  PO2 Codeigniter Controller Querys on One View
  UserUserId
  USwiseindy
  VoteTypeVoteTypeId
  VTFavorite
CommentsPostId

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.