I've been trying for some time to make a form in CodeIgniter 3 for editing data display in its fields the values of each column of the selected record. The update
operation is working normally, but since the fields are blank, I need to retype everything.
Below my template MY_Model.php
:
<?php
class MY_Model extends CI_Model
{
public $table = '';
protected $primary_key = 'id';
public function __construct()
{
parent::__construct();
$this->load->database();
$this->load->helper('inflector');
}
public function get($id)
{
return $this->db->get_where($this->table, array($this->primary_key = $id))->row();
}
public function select()
{
$data = array();
$this->db->from($this->table);
$this->db->order_by($this->primary_key, 'DESC');
$query = $this->db->get();
foreach ($query->result_array() as $row) {
$data[] = $row;
}
$query->free_result();
return $data;
}
public function insert($data)
{
$data['date_created'] = $data['date_updated'] = date('Y-m-d');
$data['created_from_ip'] = $data['updated_from_ip'] = $this->input->ip_address();
if ($this->db->insert($this->table, $data)) {
return $this->db->insert_id();
} else {
return false;
}
}
public function update($data, $id)
{
$data['date_updated'] = date('Y-m-d');
$data['updated_from_ip'] = $this->input->ip_address();
$this->db->where($this->primary_key, $id);
return $this->db->update($this->table, $data);
}
public function delete($id)
{
$this->db->where($this->primary_key, $id);
return $this->db->delete($this->table);
}
public function count_all()
{
return $this->db->count_all($this->table);
}
}
Here the function edit
of the control Customers
:
public function edit($id)
{
if ($this->input->post()) {
$data['name'] = $this->input->post('name');
$data['email'] = $this->input->post('email');
$data['address'] = $this->input->post('address');
$this->Customers_model->update($data, $id);
$this->session->set_flashdata('message', 'Cliente \'' . $data['name'] . '\' alterado');
redirect('/admin/customers', 'refresh');
}
$data['customer'] = $this->Customers_model->get($id);
$data['page'] = $this->config->item('admin_template_dir_admin') . 'edit_customers';
$data['module'] = 'admin';
$this->load->view($this->_container, $data);
}
I've tried a lot to display the data for editing. The way you are now, making var_dump($customer)
only shows NULL
. How to proceed?