How can I join two tables with same fieldnames and return both in array using CodeIgniter?

Question

public function appProfile($id=null)
{
   $query= $this->db->where('software_db.id',$id)
                    ->from('software_db')
                    ->join('dev_db','software_db.dev_id=dev_db.id','right')
                    ->select(['dev_db.name','dev_db.id','software_db.id','software_db.name','software_db.file_name','software_db.image_name'])
                    ->get()
                    ->result_array();
    print_r($query);die;
}

The table structure is as follows:

dev_db(id(primary key),name,email,password,comany,skills)
software_db(id(primary key), name,file_name,image_name,description,platform,cateogory)

The output array never contains the id and name from dev_db. It should return all the fields from software_db where software.id=$id and name and id from dev_db.

Did you mean to join on software_db.id=dev_db.id rather than software_db.dev_id=dev_db.id — drfranks3
– drfranks3, Commented Oct 23, 2017 at 22:32

Vickel · Accepted Answer · 2017-10-23 22:54:36Z

1

select() shouldn't have square brackets [ ].

in your select clause create aliases, something like

->select('dev_db.name as dev_db_name') // etc

edited Oct 23, 2017 at 22:54

answered Oct 23, 2017 at 22:44

Vickel

7,9806 gold badges40 silver badges63 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

user4419336 · Accepted Answer · 2017-10-23 22:41:14Z

1

Try is this way

public function appProfile($id = '') {

    $this->db->select('dev_db.name, dev_db.id, software_db.id, software_db.name, software_db.file_name, software_db.image_name');
    $this->db->from('software_db');
    $this->db->join('dev_db', 'dev_db.id = software_db.dev_id', 'right');
    $this->db->where('software_db.id',$id);
    $query = $this->db->get();

    return $query->result_array();

}

answered Oct 23, 2017 at 22:41

user4419336

1 Comment

Vyom Srivastava Over a year ago

it is only returning the name field of dev_db

Collectives™ on Stack Overflow

How can I join two tables with same fieldnames and return both in array using CodeIgniter?

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related