CodeIgniter Form Step By Step Tutorial - Part 16: Now, we want to show single data at form for editing. User can choose a data from table that we create at here.
First, create a function at model(books_model.php) that will display single data.
function get($id){
$this->load->database();
$query = $this->db->getwhere('books',array('id'=>$id));
return $query->row_array();
}
Then, update input() at controller (books.php). Do like this:
function input($id = 0){
$this->load->helper('form');
$this->load->helper('html');
$this->load->model('books_model');
if($this->input->post('mysubmit')){
$this->books_model->entry_insert();
}
$data = $this->books_model->general();
if((int)$id > 0){
$query = $this->books_model->get($id);
$data['fid']['value'] = $query['id'];
$data['ftitle']['value'] = $query['title'];
$data['fauthor']['value'] = $query['author'];
$data['fpublisher']['value'] = $query['publisher'];
$data['fyear']['value'] = $query['year'];
if($query['available']=='yes'){
$data['favailable']['checked'] = TRUE;
}else{
$data['favailable']['checked'] = FALSE;
}
$data['fsummary']['value'] = $query['summary'];
}
$this->load->view('books_input',$data);
}
Now, input() can accept parameter from GET. If there is a value from GET, it will retrieve data from get at model (line 13). We enter the value to form (line 14 - 24).
Next, update view books_input() become like this:
<html>
<head>
<link rel="stylesheet" type="text/css"
href="<?php echo "$base/$css"?>">
</head>
<body>
<div id="header">
<? $this->load->view('books_header'); ?>
</div>
<div id="menu">
<? $this->load->view('books_menu'); ?>
</div>
<? echo heading($forminput,3) ?>
<? echo form_open('books/input'); ?>
<? echo form_hidden('id',$fid['value']); ?>
<? echo $title .' : '.
form_input($ftitle).br(); ?>
<? echo $author .' : '.
form_input($fauthor).br(); ?>
<? echo $publisher .' : '.
form_input($fpublisher).br(); ?>
<? echo $year .' : '.
form_dropdown('year',$years,$fyear['value']).br(); ?>
<? echo $available .' : '.
form_checkbox($favailable).br(); ?>
<? echo $summary .' : '.
form_textarea($fsummary).br(); ?>
<? echo form_submit('mysubmit','Submit!'); ?>
<? echo form_close(); ?>
<div id="footer">
<? $this->load->view('books_footer'); ?>
</div>
</body>
</html>
We add input type hidden at line 15 for editing key. Then accomodate dropdown object at line 23.
Now, try to edit a data by click edit link at table. May be you get a data like:
