Seach

multiple table join in codeigniter

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();
}