StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POcodeigniter method get losing data on controller
primarykey
Id
15092238
data
AcceptedAnswerId
15092675
AnswerCount
2
ClosedDate
CommentCount
5
CommunityOwnedDate
CreationDate
2013-02-26T14:57:35.053
FavoriteCount
0
LastActivityDate
2013-02-26T15:58:50.323
LastEditDate
2013-02-26T15:11:07.620
LastEditorUserId
1511579
OwnerUserId
1511579
ParentId
0
PostTypeId
1
Score
0
ViewCount
426
LastEditorDisplayName
text
Body
<p>i have aa application where i can edit fields of a database table. Everything is fine and the data is updated, except if i go to the field that i want to update and instead of changing the text, put the field blank. In that way i get php errors because (i guess) the method of my controller lose the id of that row of the table:</p> <p>I would be glad if anyone could help me, thank's in advance.</p> <p>Part of the view file where i use the method get to pass the id of the table row (edit_fuga.php).</p> <pre><code> <div id='tab2'> <?php $query = $this->db->query("SELECT * FROM fugas WHERE tipo_fuga='2';"); foreach ($query->result_array() as $row) { echo "<input type='hidden' name='id_fuga' value='". $row['id_fuga']."'>"; echo $row['desc_fuga']."&nbsp;&nbsp;<a class='button' href='http://localhost/code/index.php/fugas/editar_fuga?var1=".$row['id_fuga']."'>Editar</a>"; echo "<br/>"; } ?> </div> </code></pre> <p>The view to where i am redirected (editar_fuga.php):</p> <pre><code><?php echo validation_errors(); ?> <?php echo form_open('fugas/editar_fuga') ?> <?php $query = $this->db->query("SELECT desc_fuga_table FROM tipos_fuga where tipo_fuga_table='".$fuga_selected['tipo_fuga']."';"); foreach ($query->result() as $row) { echo $row->desc_fuga_table; } $tipo_fuga_selected=$row->desc_fuga_table; ?> <label for="tipo_fuga"><?php echo $tipo_fuga_selected; ?></label><br/> <p/> <label for="desc_fuga">Desc da fuga:</label><p/> <textarea rows="4" cols="50" name="desc_fuga"><?php echo $fuga_selected['desc_fuga']; ?></textarea><p/> <input type="hidden" name="id_fuga" value="<?php echo $fuga_selected['id_fuga']; ?>"> <input type="submit" name="submit" value="Alterar Fuga" /><p/> <INPUT Type="button" VALUE="Voltar" onClick="history.go(-1);return true;"> </form> </code></pre> <p>The method on the controller of the view editar_fuga.php</p> <pre><code>public function editar_fuga(){ $fuga_id = $this->input->get('var1'); var_dump($fuga_id); $this->load->helper('form'); $this->load->library('form_validation'); //$this->load->view('templates/header'); $this->form_validation->set_rules('desc_fuga', 'Descrição da fuga acidental', 'required'); if ($this->form_validation->run() === FALSE) { $data['fuga_selected'] = $this->fugas_model->get_fuga($fuga_id); $this->load->view('fugas/editar_fuga', $data); } else { $this->fugas_model->update_fuga(); echo "Fuga alterada com sucesso.<br/><br/>"; $this->load->view('fichas/index'); } } </code></pre> <p>Fuga Model:</p> <pre><code> public function update_fuga(){ $data = array( 'desc_fuga' => $this->input->post('desc_fuga') ); $id=$this->input->post('id_fuga'); $this->db->where('id_fuga', $id); $this->db->update('fugas', $data); } public function get_fuga($fuga_id){ var_dump($fuga_id); $query = $this->db->query("SELECT * FROM fugas where id_fuga='".$fuga_id."';"); foreach ($query->result_array() as $row) { $data_fuga = array( 'id_fuga' => $row['id_fuga'], 'tipo_fuga' => $row['tipo_fuga'], 'desc_fuga' => $row['desc_fuga'] ); } return $data_fuga; } </code></pre>
Tags
<php><codeigniter>
Title
codeigniter method get losing data on controller
singulars
PostAcceptedAnswerId
1. PO
  singulars
  PostTypePostTypeId
  PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USuser1511579
UserOwnerUserId
1. USuser1511579
plurals
PostLinksPostIdRelatedPostId
1. PL
  singulars
  LinkTypeLinkTypeId
  LTLinked
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. This table or related slice is empty.
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.