How To Run Multiple Query From Return Result In Codeigniter

Question

I have run one query to fetch data from database in model class and it is being shown after that in output i have got customer id and from customer id i want to fetch details of that customer.

Model Class:

public function viewcomplaindeails($id)
{
    $this->db->select('complainid,complainnumber,complainuserid,complaindate,complaintime,complaindescription,employeeassign,complainclosingdate,complainclosingtime,complainstatus');
    $this->db->where('complainid', $id);
    $query = $this->db->get('complain');
    return $query;
}


public function complain_get_user($complainuserid)
{
    $this->db->select('userid,name,email,mobilenumber,address,photo,usertype,city,state,createddatetime');
    $this->db->where('userid', $complainuserid);
    $query = $this->db->get('user');
    return $query;
}

Controller Class:

public function viewcomplaindeails($id)
{
    $this->load->model('dataout');
    $data['a'] = $this->dataout->viewcomplaindeails($id);
    $complainuserid = $data['a']->complainuserid;
    $data['user'] = $this->dataout->complain_get_user($complainuserid);
    $this->load->view('view_complain', $data);
}

Result:

enter image description here

What have you tried to debug the problem? – Nico Haase Oct 30 '19 at 11:16 — Nico Haase, Oct 30 '19 at 11:16
How to write a join query? – mickmackusa Oct 30 '19 at 11:49 — mickmackusa, Oct 30 '19 at 11:49

score 1 · Answer 1 · answered Oct 30 '19 at 11:14

Use result_array() or row_array() to fetch the data from the database:

Result_array() used for fetching bulk data from table

Row_array() used for fetching single row of the data from the table

public function viewcomplaindeails($id)
{
    $this->db->select('complainid,complainnumber,complainuserid,complaindate,complaintime,complaindescription,employeeassign,complainclosingdate,complainclosingtime,complainstatus');
    $this->db->where('complainid', $id);
    $query = $this->db->get('complain')->row_array();
    return $query;
}


public function complain_get_user($complainuserid)
{
    $this->db->select('userid,name,email,mobilenumber,address,photo,usertype,city,state,createddatetime');
    $this->db->where('userid', $complainuserid);
    $query = $this->db->get('user')->row_array();
    return $query;
}

in view page you write in the value as value="fieldname; ?>" — Jacky, Oct 30 '19 at 11:18

How To Run Multiple Query From Return Result In Codeigniter

1 Answers1