viewpage(employee_data_edit_view)
<form method="post">
<table border='1'>
<tr>
<td><label>Name</label></td>
<td><input type="text" name="name" value="<?php echo $result->name;?>"></td>
</tr>
<tr>
<td><label>Age</label></td>
<td><input type="text" name="age" value="<?php echo $result->age;?>"></td>
</tr>
<tr>
<td><label>Gender</label></td>
<td><input type="text" name="gender" value="<?php echo $result->gender;?>"></td>
</tr>
<tr>
<td><label>Email</label></td>
<td><input type="text" name="emailid" value="<?php echo $result->emailid;?>"></td>
</tr>
<tr>
<td><label>Panno</label></td>
<td><input type="text" name="panno" value="<?php echo $result->panno;?>"></td>
</tr>
<tr>
<td><label>Phone</label></td>
<td><input type="text" name="phone" value="<?php echo $result->phone;?>"></td>
</tr>
<tr>
<td><label>Address</label></td>
<td><input type="text" name="address" value="<?php echo $result->address;?>"></td>
</tr>
<tr>
<td><label>UserId</label></td>
<td><input type="text" name="userid" value="<?php echo $result->userid;?>"></td>
</tr>
<tr>
<td><label>Password</label></td>
<td><input type="text" name="password" ></td>
</tr>
</table>
</form>
Controller(employee)
i only providing the function inside the Employee controller class
public function empdataview($id)
{
$this->load->model('employee_model');
$data=array('empcode'=>$id);
$query['result']=$this->employee_model->employee_data($data);
$this->load->view('employee_data_edit_view',$query);
}
Model(employee_model)
public function employee_data($data)
{
$this->db->select(
'user_info.name,user_info.age,user_info.gender,user_info.panno,user_info.image,user.emailid,user.phone,user.address,userlogin.userid,userlogin.password');
$this->db->from('user_info');
$this->db->join('user','user.empcode=user_info.empcode');
$this->db->join('userlogin','userlogin.empcode=user.empcode');
$this->db->where('userlogin.empcode',$data['empcode']);
$query=$this->db->get();
return $query->row();
}
<form method="post">
<table border='1'>
<tr>
<td><label>Name</label></td>
<td><input type="text" name="name" value="<?php echo $result->name;?>"></td>
</tr>
<tr>
<td><label>Age</label></td>
<td><input type="text" name="age" value="<?php echo $result->age;?>"></td>
</tr>
<tr>
<td><label>Gender</label></td>
<td><input type="text" name="gender" value="<?php echo $result->gender;?>"></td>
</tr>
<tr>
<td><label>Email</label></td>
<td><input type="text" name="emailid" value="<?php echo $result->emailid;?>"></td>
</tr>
<tr>
<td><label>Panno</label></td>
<td><input type="text" name="panno" value="<?php echo $result->panno;?>"></td>
</tr>
<tr>
<td><label>Phone</label></td>
<td><input type="text" name="phone" value="<?php echo $result->phone;?>"></td>
</tr>
<tr>
<td><label>Address</label></td>
<td><input type="text" name="address" value="<?php echo $result->address;?>"></td>
</tr>
<tr>
<td><label>UserId</label></td>
<td><input type="text" name="userid" value="<?php echo $result->userid;?>"></td>
</tr>
<tr>
<td><label>Password</label></td>
<td><input type="text" name="password" ></td>
</tr>
</table>
</form>
Controller(employee)
i only providing the function inside the Employee controller class
public function empdataview($id)
{
$this->load->model('employee_model');
$data=array('empcode'=>$id);
$query['result']=$this->employee_model->employee_data($data);
$this->load->view('employee_data_edit_view',$query);
}
Model(employee_model)
public function employee_data($data)
{
$this->db->select(
'user_info.name,user_info.age,user_info.gender,user_info.panno,user_info.image,user.emailid,user.phone,user.address,userlogin.userid,userlogin.password');
$this->db->from('user_info');
$this->db->join('user','user.empcode=user_info.empcode');
$this->db->join('userlogin','userlogin.empcode=user.empcode');
$this->db->where('userlogin.empcode',$data['empcode']);
$query=$this->db->get();
return $query->row();
}